Page Comparison

SV_MIS_XE.f_get_asgn_type
  FUNCTION f_get_asgn_type( p_asty_code_in IN SIRASGN.SIRASGN_ASTY_CODE%TYPE,
                            p_fstp_code_in IN SIBINST.SIBINST_FSTP_CODE%TYPE,
                            p_report_in    IN GVVRPDF.GVVRPDF_REPORT%TYPE )
    RETURN VARCHAR2
  IS
    lv_map_value   VARCHAR2(4);

  BEGIN

    IF p_fstp_code_in IS NOT NULL THEN
      lv_map_value := gv_rept_xml.F_MapValue(p_report_in, 'XE01', p_fstp_code_in);
      IF lv_map_value IS NULL OR lv_map_value NOT IN ('1', '4') THEN
        IF p_asty_code_in IS NOT NULL THEN
          lv_map_value := gv_rept_xml.F_MapValue(p_report_in, 'XE01', p_asty_code_in);
        END IF;
      END IF;
    ELSE
      IF p_asty_code_in IS NOT NULL THEN
        lv_map_value := gv_rept_xml.F_MapValue(p_report_in, 'XE01', p_asty_code_in);
      END IF;
    END IF;
    -- C3SC JC 06/09/2011 END

    IF lv_map_value IS NOT NULL THEN
      RETURN lv_map_value;
    ELSE
      RETURN '3'; -- C3SC JC 06/09/2011 CHANGED
    END IF;

  END f_get_asgn_type;