APPS.IGS_AD_IMP_PRBLTY_VAL_PKG dependencies on IGS_AD_RECRUIT_PI_PKG

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,