APPS.IGS_PS_GEN_004 dependencies on IGS_EN_DL_OFFSET_CONS

Line 170: SELECT enr_dl_offset_cons_id FROM igs_en_dl_offset_cons

166: -- Standard then it will simply apply round function of the Duration Days/Meeting Days.
167: -------------------------------------------------------------------
168:
169: CURSOR c_call_cnstr IS
170: SELECT enr_dl_offset_cons_id FROM igs_en_dl_offset_cons
171: WHERE non_std_usec_dls_id = p_setup_id
172: AND deadline_type = 'E';
173: c_call_cnstr_rec c_call_cnstr%ROWTYPE;
174:

Line 1033: p_offset_cnstr_id IN IGS_EN_DL_OFFSET_CONS.ENR_DL_OFFSET_CONS_ID%TYPE,

1029:
1030:
1031: PROCEDURE calpl_constraint_resolve (
1032: p_date_val IN OUT NOCOPY IGS_EN_NSTD_USEC_DL.ENR_DL_DATE%TYPE,
1033: p_offset_cnstr_id IN IGS_EN_DL_OFFSET_CONS.ENR_DL_OFFSET_CONS_ID%TYPE,
1034: p_type IN IGS_EN_NSTD_USEC_DL.FUNCTION_NAME%TYPE,
1035: p_deadline_type IN VARCHAR2,
1036: p_msg_name OUT NOCOPY VARCHAR2 )
1037: AS

Line 1086: FROM IGS_EN_DL_OFFSET_CONS daoc

1082: CURSOR c_daoc_func IS
1083: SELECT daoc.OFFSET_CONS_TYPE_CD,
1084: daoc.CONSTRAINT_CONDITION,
1085: daoc.CONSTRAINT_RESOLUTION
1086: FROM IGS_EN_DL_OFFSET_CONS daoc
1087: WHERE daoc.NON_STD_USEC_DLS_ID = p_offset_cnstr_id --bug#5190760,replaced ENR_DL_OFFSET_CONS_ID with NON_STD_USEC_DLS_ID
1088: AND daoc.deadline_type = p_deadline_type;
1089:
1090: CURSOR c_daoc_adm IS

Line 1102: p_cnstrt_condition IN IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,

1098:
1099: FUNCTION calpl_holiday_resolve (
1100:
1101: p_date_val IN OUT NOCOPY DATE,
1102: p_cnstrt_condition IN IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,
1103: p_cnstrt_resolution IN IGS_EN_DL_OFFSET_CONS.constraint_resolution%TYPE )
1104:
1105: RETURN VARCHAR2
1106: AS

Line 1103: p_cnstrt_resolution IN IGS_EN_DL_OFFSET_CONS.constraint_resolution%TYPE )

1099: FUNCTION calpl_holiday_resolve (
1100:
1101: p_date_val IN OUT NOCOPY DATE,
1102: p_cnstrt_condition IN IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,
1103: p_cnstrt_resolution IN IGS_EN_DL_OFFSET_CONS.constraint_resolution%TYPE )
1104:
1105: RETURN VARCHAR2
1106: AS
1107:

Line 1219: p_cnstrt_condition IN IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,

1215:
1216:
1217: FUNCTION calpl_inst_break_resolve (
1218: p_date_val IN OUT NOCOPY DATE,
1219: p_cnstrt_condition IN IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,
1220: p_cnstrt_resolution IN IGS_EN_DL_OFFSET_CONS.constraint_resolution%TYPE )
1221:
1222: RETURN varchar2
1223: AS

Line 1220: p_cnstrt_resolution IN IGS_EN_DL_OFFSET_CONS.constraint_resolution%TYPE )

1216:
1217: FUNCTION calpl_inst_break_resolve (
1218: p_date_val IN OUT NOCOPY DATE,
1219: p_cnstrt_condition IN IGS_EN_DL_OFFSET_CONS.constraint_condition%TYPE,
1220: p_cnstrt_resolution IN IGS_EN_DL_OFFSET_CONS.constraint_resolution%TYPE )
1221:
1222: RETURN varchar2
1223: AS
1224: v_changed BOOLEAN;