DBA Data[Home] [Help]

APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_APPLICANTS_PKG

Line 309: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

305: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
306:
307: -- update UCAS Applicants table with Person ID.
308: BEGIN
309: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
310: (
311: x_rowid => ucas_app_person_rec.rowid
312: ,x_app_id => ucas_app_person_rec.app_id
313: ,x_app_no => ucas_app_person_rec.app_no

Line 852: igs_uc_applicants_pkg.insert_row -- IGSXI01B.pls

848: IF appl_rec.rowid IS NULL THEN
849:
850: -- since corresponding record does not exist in UCAS APplicants, Insert a record with basic details.
851: BEGIN
852: igs_uc_applicants_pkg.insert_row -- IGSXI01B.pls
853: (
854: x_rowid => appl_rec.rowid
855: ,x_app_id => appl_rec.app_id -- can be used since this rec variable would be null
856: ,x_app_no => new_ivstarn_rec.appno

Line 1611: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

1607: g_error_code := '1000';
1608: ELSE
1609:
1610: -- call the TBH to update the record setting sent to OSS as No.
1611: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
1612: (
1613: x_rowid => app_rec.rowid
1614: ,x_app_id => app_rec.app_id
1615: ,x_app_no => app_rec.app_no

Line 2186: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

2182:
2183: BEGIN
2184: -- call the TBH to update the record
2185: -- smaddali updating criminal_conv, ukentrydate,ni_number with interface record values as per bug#3088436
2186: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
2187: (
2188: x_rowid => old_stark_rec.rowid
2189: ,x_app_id => old_stark_rec.app_id
2190: ,x_app_no => old_stark_rec.app_no

Line 3430: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

3426: -- update Applicants record for some fields
3427: -- (gcse_eng, gcse_match, degree_subject, degree_status, degree_class, gcse_csi).
3428: BEGIN
3429: -- call the TBH to update the record
3430: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
3431: (
3432: x_rowid => get_appl_dets_rec.rowid
3433: ,x_app_id => get_appl_dets_rec.app_id
3434: ,x_app_no => get_appl_dets_rec.app_no

Line 4130: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

4126:
4127:
4128: BEGIN
4129: -- call the TBH to update the record
4130: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
4131: (
4132: x_rowid => old_start_rec.rowid
4133: ,x_app_id => old_start_rec.app_id
4134: ,x_app_no => old_start_rec.app_no

Line 4387: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

4383:
4384:
4385: BEGIN
4386: -- call the TBH to update the record
4387: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
4388: (
4389: x_rowid => old_qual_rec.rowid
4390: ,x_app_id => old_qual_rec.app_id
4391: ,x_app_no => old_qual_rec.app_no

Line 4658: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

4654: IF old_stmt_rec.personal_statement IS NULL AND new_ivstmt_rec.statement IS NOT NULL THEN
4655:
4656: -- update the statement as the existing value is null
4657: BEGIN
4658: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls
4659: (
4660: x_rowid => old_stmt_rec.rowid
4661: ,x_app_id => old_stmt_rec.app_id
4662: ,x_app_no => old_stmt_rec.app_no