APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_UC_APP_CHOICES_PKG

Line 16: the package IGS_UC_APP_CHOICES_PKG.

12: Known limitations,enhancements,remarks:
13: Change History
14: Who When What
15: Nishikant 01-OCT-2002 A new column extra_round_nbr added in the TBH calls of
16: the package IGS_UC_APP_CHOICES_PKG.
17: ayedubat 20-OCT-2002 Added a Logic to check whether the decision is required to export or not
18: for the bug fix: 2628041
19: smaddali 19-oct-2002 added igs_uc_old_oustat_pkg.delete_row call whenever
20: export_to_oss_status is being set to "DC" and captured record is found ,for bug 2630219

Line 1203: igs_uc_app_choices_pkg.update_row

1199: END IF ;
1200:
1201: /* Update the Application choice record with the error code, batch_id and status */
1202:
1203: igs_uc_app_choices_pkg.update_row
1204: ( x_rowid => cur_ucas_app_choice_rec.ROWID
1205: ,x_app_choice_id => cur_ucas_app_choice_rec.app_choice_id
1206: ,x_app_id => cur_ucas_app_choice_rec.app_id
1207: ,x_app_no => cur_ucas_app_choice_rec.app_no

Line 1330: igs_uc_app_choices_pkg.update_row (

1326: FETCH cur_dec_import_error INTO cur_dec_import_error_rec;
1327:
1328: IF cur_dec_import_error%NOTFOUND THEN
1329:
1330: igs_uc_app_choices_pkg.update_row (
1331: x_rowid => cur_dp_app_choice_rec.ROWID
1332: ,x_app_choice_id => cur_dp_app_choice_rec.app_choice_id
1333: ,x_app_id => cur_dp_app_choice_rec.app_id
1334: ,x_app_no => cur_dp_app_choice_rec.app_no

Line 1434: the package IGS_UC_APP_CHOICES_PKG.

1430: Known limitations,enhancements,remarks:
1431: Change History
1432: Who When What
1433: Nishikant 01-OCT-2002 A new column extra_round_nbr added in the TBH calls of
1434: the package IGS_UC_APP_CHOICES_PKG.
1435: Ayedubat 18-OCT-2002 Passed NULL to the column,ACTUAL_OFFER_RESPONSE_DT while populating into the interface table,IGS_AD_OFFRESP_INT for the bug fix:2632302
1436: jchin 20-jan-2006 Modified for R12 Perf improvements - bug 3691277 and 3691250
1437: jchakrab 22-May-2006 Modified for 5165624
1438: jbaber 07-Jun-2006 Added decline_ofr_reason for bug 528190/5222716

Line 1951: igs_uc_app_choices_pkg.update_row

1947: END IF ; /* End of OSS Application Instance processinng */
1948: CLOSE cur_oss_appl_inst;
1949:
1950: /* update the Application choice with the error code ,batch_id and export_to_oss_status*/
1951: igs_uc_app_choices_pkg.update_row
1952: ( x_rowid => cur_ucas_app_choice_rec.ROWID
1953: ,x_app_choice_id => cur_ucas_app_choice_rec.app_choice_id
1954: ,x_app_id => cur_ucas_app_choice_rec.app_id
1955: ,x_app_no => cur_ucas_app_choice_rec.app_no

Line 2118: igs_uc_app_choices_pkg.update_row

2114: END IF ; /* End If for cur_oss_appl_inst%FOUND */
2115: CLOSE cur_oss_appl_inst;
2116:
2117: -- Update the Application Choice with export to OSS status , Concurrent Request ID
2118: igs_uc_app_choices_pkg.update_row
2119: ( x_rowid => cur_rp_app_choice_rec.ROWID
2120: ,x_app_choice_id => cur_rp_app_choice_rec.app_choice_id
2121: ,x_app_id => cur_rp_app_choice_rec.app_id
2122: ,x_app_no => cur_rp_app_choice_rec.app_no