DBA Data[Home] [Help]

APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on IGF_AP_PERSON_MATCH_PKG

Line 3378: igf_ap_person_match_pkg.update_row(

3374: -- Update record _status
3375: FOR person_data IN cur_person_match(pn_apm_id)
3376: LOOP
3377:
3378: igf_ap_person_match_pkg.update_row(
3379: x_rowid => person_data.row_id ,
3380: x_apm_id => pn_apm_id ,
3381: x_css_id => person_data.css_id ,
3382: x_si_id => person_data.si_id ,

Line 3641: igf_ap_person_match_pkg.update_row(

3637:
3638: --Opening the cursor to update the record_status field to MATCHED
3639: FOR person_data IN cur_person_match(p_apm_id) LOOP
3640: -- procedure to update the record_status of igf_ap_person_match to 'MATCHED'
3641: igf_ap_person_match_pkg.update_row(
3642: x_rowid => person_data.row_id ,
3643: x_apm_id => person_data.apm_id ,
3644: x_css_id => person_data.css_id ,
3645: x_si_id => person_data.si_id ,

Line 3669: igf_ap_person_match_pkg.update_row(

3665: ELSE
3666: --Opening the cursor to update the record_status field to UNMATCHED
3667: FOR person_data IN cur_person_match(p_apm_id) LOOP
3668: -- procedure to update the record_status of igf_ap_person_match to 'UNMATCHED'
3669: igf_ap_person_match_pkg.update_row(
3670: x_rowid => person_data.row_id ,
3671: x_apm_id => person_data.apm_id ,
3672: x_css_id => person_data.css_id ,
3673: x_si_id => person_data.si_id ,

Line 3695: igf_ap_person_match_pkg.update_row(

3691: --Opening the cursor to update the record_status field to UNMATCHED
3692: FOR person_data IN cur_person_match(p_apm_id)
3693: LOOP
3694: -- procedure to update the record_status of igf_ap_person_match to 'UNMATCHED'
3695: igf_ap_person_match_pkg.update_row(
3696: x_rowid => person_data.row_id ,
3697: x_apm_id => person_data.apm_id ,
3698: x_css_id => person_data.css_id ,
3699: x_si_id => person_data.si_id ,

Line 3758: igf_ap_person_match_pkg.update_row(

3754: FOR person_data IN cur_person_match(p_apm_id)
3755: LOOP
3756:
3757: --Procedure to update the record_status of igf_ap_person_match to review
3758: igf_ap_person_match_pkg.update_row(
3759: x_rowid => person_data.row_id ,
3760: x_apm_id => person_data.apm_id ,
3761: x_css_id => person_data.css_id ,
3762: x_si_id => person_data.si_id ,

Line 3985: igf_ap_person_match_pkg.insert_row(

3981: END;
3982:
3983: -- Inserting new student record into igf_ap_person_match table.
3984: lv_rowid := NULL;
3985: igf_ap_person_match_pkg.insert_row(
3986: x_rowid => lv_rowid ,
3987: x_apm_id => p_out_apm_id,
3988: x_css_id => g_cur_data.css_id,
3989: x_si_id => NULL ,