eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_CA_GEN_002 dependencies on IGS_CA_DA_OFFCNT

Line 72: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,

68: -- s_dt_alias_offset_type = 'HOLIDAY'
69: ---------------------------------------------------------
70: FUNCTION calpl_holiday_resolve (
71: p_s_dt_offset_cnstrt_type
72: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,
73: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
74: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,
75: p_mod_count IN OUT NOCOPY PLS_INTEGER,
76: p_alias_val IN OUT NOCOPY DATE)

Line 73: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,

69: ---------------------------------------------------------
70: FUNCTION calpl_holiday_resolve (
71: p_s_dt_offset_cnstrt_type
72: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,
73: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
74: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,
75: p_mod_count IN OUT NOCOPY PLS_INTEGER,
76: p_alias_val IN OUT NOCOPY DATE)
77: RETURN varchar2

Line 74: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,

70: FUNCTION calpl_holiday_resolve (
71: p_s_dt_offset_cnstrt_type
72: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,
73: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
74: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,
75: p_mod_count IN OUT NOCOPY PLS_INTEGER,
76: p_alias_val IN OUT NOCOPY DATE)
77: RETURN varchar2
78: AS

Line 229: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,

225: -- s_dt_alias_offset_type = 'INST BREAK'
226: ---------------------------------------------------------
227: FUNCTION calpl_inst_break_resolve (
228: p_s_dt_offset_cnstrt_type
229: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,
230: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
231: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,
232: p_mod_count IN OUT NOCOPY PLS_INTEGER,
233: p_alias_val IN OUT NOCOPY DATE)

Line 230: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,

226: ---------------------------------------------------------
227: FUNCTION calpl_inst_break_resolve (
228: p_s_dt_offset_cnstrt_type
229: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,
230: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
231: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,
232: p_mod_count IN OUT NOCOPY PLS_INTEGER,
233: p_alias_val IN OUT NOCOPY DATE)
234: RETURN varchar2

Line 231: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,

227: FUNCTION calpl_inst_break_resolve (
228: p_s_dt_offset_cnstrt_type
229: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,
230: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
231: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,
232: p_mod_count IN OUT NOCOPY PLS_INTEGER,
233: p_alias_val IN OUT NOCOPY DATE)
234: RETURN varchar2
235: AS

Line 603: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,

599: -- s_dt_alias_offset_type = 'HOLIDAY'
600: ---------------------------------------------------------
601: FUNCTION calpl_holiday_resolve (
602: p_s_dt_offset_cnstrt_type
603: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,
604: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
605: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,
606: p_mod_count IN OUT NOCOPY NUMBER,
607: p_alias_val IN OUT NOCOPY DATE)

Line 604: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,

600: ---------------------------------------------------------
601: FUNCTION calpl_holiday_resolve (
602: p_s_dt_offset_cnstrt_type
603: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,
604: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
605: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,
606: p_mod_count IN OUT NOCOPY NUMBER,
607: p_alias_val IN OUT NOCOPY DATE)
608: RETURN VARCHAR2

Line 605: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,

601: FUNCTION calpl_holiday_resolve (
602: p_s_dt_offset_cnstrt_type
603: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,
604: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
605: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,
606: p_mod_count IN OUT NOCOPY NUMBER,
607: p_alias_val IN OUT NOCOPY DATE)
608: RETURN VARCHAR2
609: AS

Line 724: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,

720: -- s_dt_alias_offset_type = 'INST BREAK'
721: ---------------------------------------------------------
722: FUNCTION calpl_inst_break_resolve (
723: p_s_dt_offset_cnstrt_type
724: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,
725: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
726: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,
727: p_mod_count IN OUT NOCOPY NUMBER,
728: p_alias_val IN OUT NOCOPY DATE)

Line 725: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,

721: ---------------------------------------------------------
722: FUNCTION calpl_inst_break_resolve (
723: p_s_dt_offset_cnstrt_type
724: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,
725: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
726: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,
727: p_mod_count IN OUT NOCOPY NUMBER,
728: p_alias_val IN OUT NOCOPY DATE)
729: RETURN varchar2

Line 726: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,

722: FUNCTION calpl_inst_break_resolve (
723: p_s_dt_offset_cnstrt_type
724: IGS_CA_DA_OFFCNT.S_DT_OFFSET_CONSTRAINT_TYPE%TYPE,
725: p_cnstrt_condition IGS_CA_DA_OFFCNT.constraint_condition%TYPE,
726: p_cnstrt_resolution IGS_CA_DA_OFFCNT.constraint_resolution%TYPE,
727: p_mod_count IN OUT NOCOPY NUMBER,
728: p_alias_val IN OUT NOCOPY DATE)
729: RETURN varchar2
730: AS

Line 876: FROM IGS_CA_DA_OFFCNT daoc

872: CURSOR c_daoc IS
873: SELECT daoc.S_DT_OFFSET_CONSTRAINT_TYPE,
874: daoc.constraint_condition,
875: daoc.constraint_resolution
876: FROM IGS_CA_DA_OFFCNT daoc
877: WHERE daoc.DT_ALIAS = p_dt_alias;
878: BEGIN
879: v_msg_name := NULL;
880: FOR v_daoc_rec IN c_daoc LOOP