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_PS_EMP_CATS_WL_PKG dependencies on IGS_PS_FAC_WL

Line 182: CURSOR cur_igs_ps_fac_wl IS

178: || Who When What
179: || (reverse chronological order - newest change first)
180: */
181:
182: CURSOR cur_igs_ps_fac_wl IS
183: SELECT cal_type,ci_sequence_number,person_id
184: FROM igs_ps_fac_wl;
185:
186: l_n_exp_wl NUMBER;

Line 184: FROM igs_ps_fac_wl;

180: */
181:
182: CURSOR cur_igs_ps_fac_wl IS
183: SELECT cal_type,ci_sequence_number,person_id
184: FROM igs_ps_fac_wl;
185:
186: l_n_exp_wl NUMBER;
187: l_n_tot_fac_wl NUMBER;
188: l_error BOOLEAN := FALSE;

Line 191: FOR cur_igs_ps_fac_wl_rec IN cur_igs_ps_fac_wl LOOP

187: l_n_tot_fac_wl NUMBER;
188: l_error BOOLEAN := FALSE;
189: BEGIN
190: IF new_references.expected_wl_num <> old_references.expected_wl_num AND new_references.expected_wl_num < old_references.expected_wl_num THEN
191: FOR cur_igs_ps_fac_wl_rec IN cur_igs_ps_fac_wl LOOP
192: IF igs_ps_gen_001.fac_exceed_exp_wl(cur_igs_ps_fac_wl_rec.cal_type,
193: cur_igs_ps_fac_wl_rec.ci_sequence_number,
194: cur_igs_ps_fac_wl_rec.person_id,
195: 0,

Line 192: IF igs_ps_gen_001.fac_exceed_exp_wl(cur_igs_ps_fac_wl_rec.cal_type,

188: l_error BOOLEAN := FALSE;
189: BEGIN
190: IF new_references.expected_wl_num <> old_references.expected_wl_num AND new_references.expected_wl_num < old_references.expected_wl_num THEN
191: FOR cur_igs_ps_fac_wl_rec IN cur_igs_ps_fac_wl LOOP
192: IF igs_ps_gen_001.fac_exceed_exp_wl(cur_igs_ps_fac_wl_rec.cal_type,
193: cur_igs_ps_fac_wl_rec.ci_sequence_number,
194: cur_igs_ps_fac_wl_rec.person_id,
195: 0,
196: l_n_tot_fac_wl,

Line 193: cur_igs_ps_fac_wl_rec.ci_sequence_number,

189: BEGIN
190: IF new_references.expected_wl_num <> old_references.expected_wl_num AND new_references.expected_wl_num < old_references.expected_wl_num THEN
191: FOR cur_igs_ps_fac_wl_rec IN cur_igs_ps_fac_wl LOOP
192: IF igs_ps_gen_001.fac_exceed_exp_wl(cur_igs_ps_fac_wl_rec.cal_type,
193: cur_igs_ps_fac_wl_rec.ci_sequence_number,
194: cur_igs_ps_fac_wl_rec.person_id,
195: 0,
196: l_n_tot_fac_wl,
197: l_n_exp_wl

Line 194: cur_igs_ps_fac_wl_rec.person_id,

190: IF new_references.expected_wl_num <> old_references.expected_wl_num AND new_references.expected_wl_num < old_references.expected_wl_num THEN
191: FOR cur_igs_ps_fac_wl_rec IN cur_igs_ps_fac_wl LOOP
192: IF igs_ps_gen_001.fac_exceed_exp_wl(cur_igs_ps_fac_wl_rec.cal_type,
193: cur_igs_ps_fac_wl_rec.ci_sequence_number,
194: cur_igs_ps_fac_wl_rec.person_id,
195: 0,
196: l_n_tot_fac_wl,
197: l_n_exp_wl
198: ) THEN