APPS.IGS_AD_IMP_PRBLTY_VAL_PKG dependencies on IGS_AD_RECRUIT_PI

Line 23: FROM igs_ad_recruit_pi_v

19:
20: --Cursor to check for duplicate record
21: CURSOR duplicate_check_cur IS
22: SELECT 'X'
23: FROM igs_ad_recruit_pi_v
24: WHERE person_id = p_person_id AND
25: TRUNC(calculation_date) = TRUNC(p_calculation_date) AND
26: probability_type_code_id = p_prblty_type_code_id;
27:

Line 137: l_probability_index_id igs_ad_recruit_pi.probability_index_id%TYPE;

133: skip_this_record EXCEPTION;
134: l_person_id igs_ad_recrt_pi_int.person_id%TYPE;
135: l_error_code igs_ad_recrt_pi_int.error_code%TYPE;
136: l_rowid ROWID;
137: l_probability_index_id igs_ad_recruit_pi.probability_index_id%TYPE;
138: l_records_processed NUMBER := 0;
139: l_exists VARCHAR2(1);
140:
141: --Cursor to select all the records in pending status in the batch_id as given by the user

Line 266: FROM igs_ad_recruit_pi_v

262: CURSOR null_hdlg_adm_recrt_pi_cur(c_person_id igs_ad_recrt_pi_int.person_id%TYPE,
263: c_calculation_date igs_ad_recrt_pi_int.calculation_date%TYPE,
264: c_prblty_type_code_id igs_ad_recrt_pi_int.prblty_type_code_id%TYPE) IS
265: SELECT *
266: FROM igs_ad_recruit_pi_v
267: WHERE person_id = c_person_id AND
268: calculation_date = c_calculation_date AND
269: probability_type_code_id = c_prblty_type_code_id;
270:

Line 279: igs_ad_recruit_pi_pkg.lock_row (

275: CLOSE null_hdlg_adm_recrt_pi_cur;
276:
277: --Call the lock row of the OSS table TBH to check whether that particular record is locked
278: --If locked then it will throw an exception for nowait condition and the updation will be skipped.
279: igs_ad_recruit_pi_pkg.lock_row (
280: x_rowid => null_hdlg_adm_recrt_pi_rec.row_id,
281: x_probability_index_id => null_hdlg_adm_recrt_pi_rec.probability_index_id,
282: x_person_id => null_hdlg_adm_recrt_pi_rec.person_id,
283: x_probability_type_code_id => null_hdlg_adm_recrt_pi_rec.probability_type_code_id,

Line 289: igs_ad_recruit_pi_pkg.update_row (

285: x_probability_value => null_hdlg_adm_recrt_pi_rec.probability_value,
286: x_probability_source_code_id => null_hdlg_adm_recrt_pi_rec.probability_source_code_id
287: );
288:
289: igs_ad_recruit_pi_pkg.update_row (
290: x_mode => 'R',
291: x_rowid => null_hdlg_adm_recrt_pi_rec.row_id,
292: x_probability_index_id => null_hdlg_adm_recrt_pi_rec.probability_index_id,
293: x_person_id => null_hdlg_adm_recrt_pi_rec.person_id,

Line 369: igs_ad_recruit_pi_pkg.insert_row (

365: --import the record by creating a new record in OSS table taking values from Interface table
366: IF l_error_code IS NULL THEN
367: BEGIN
368:
369: igs_ad_recruit_pi_pkg.insert_row (
370: x_mode => 'R',
371: x_rowid => l_rowid,
372: x_probability_index_id => l_probability_index_id,
373: x_person_id => l_person_id,