eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_UC_APP_ADDRESES

Line 126: CURSOR cur_upd_app_address ( cp_app_no IGS_UC_APP_ADDRESES.app_no%TYPE) IS

122:
123: /* Cursors used in the Export Applicant Address Details to OSS Logic */
124:
125: -- Cursor to fetch the Applicant Address Details for Update
126: CURSOR cur_upd_app_address ( cp_app_no IGS_UC_APP_ADDRESES.app_no%TYPE) IS
127: SELECT ucad.rowid,ucad.*
128: FROM IGS_UC_APP_ADDRESES ucad
129: WHERE ucad.app_no = cp_app_no;
130: cur_app_address_rec cur_upd_app_address%ROWTYPE;

Line 128: FROM IGS_UC_APP_ADDRESES ucad

124:
125: -- Cursor to fetch the Applicant Address Details for Update
126: CURSOR cur_upd_app_address ( cp_app_no IGS_UC_APP_ADDRESES.app_no%TYPE) IS
127: SELECT ucad.rowid,ucad.*
128: FROM IGS_UC_APP_ADDRESES ucad
129: WHERE ucad.app_no = cp_app_no;
130: cur_app_address_rec cur_upd_app_address%ROWTYPE;
131:
132:

Line 160: FROM IGS_UC_APP_ADDRESES ucad

156: WHERE ucap.ad_batch_id = cp_batch_id;
157:
158: CURSOR cur_proc_app_address(cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE) IS
159: SELECT ucad.rowid,ucad.*
160: FROM IGS_UC_APP_ADDRESES ucad
161: WHERE ucad.ad_batch_id = cp_batch_id;
162:
163: CURSOR cur_ad_interface_exist (cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE,
164: cp_interface_id IGS_AD_INTERFACE_ALL.INTERFACE_ID%TYPE) IS

Line 179: FROM IGS_UC_APP_ADDRESES ucadi

175:
176: -- anwest Bug# 3642740 New cursor to store UCAS applicant addresses in error
177: CURSOR cur_proc_app_address_i IS
178: SELECT ucadi.rowid, ucadi.*
179: FROM IGS_UC_APP_ADDRESES ucadi
180: WHERE ucadi.sent_to_oss_flag = 'I';
181:
182:
183: /* Cursors used to retrieve the Term Calender for insertion in the Residency

Line 247: TYPE t_cur_app_address_dtls IS REF CURSOR RETURN IGS_UC_APP_ADDRESES%ROWTYPE;

243:
244: cur_exp_applicant_dtls_rec applicant_record;
245:
246: --jchakrab added for 3691210
247: TYPE t_cur_app_address_dtls IS REF CURSOR RETURN IGS_UC_APP_ADDRESES%ROWTYPE;
248: cur_app_address_dtls t_cur_app_address_dtls;
249:
250: --cur_app_address_dtls_rec app_address_record;
251: cur_app_address_dtls_rec IGS_UC_APP_ADDRESES%ROWTYPE;

Line 251: cur_app_address_dtls_rec IGS_UC_APP_ADDRESES%ROWTYPE;

247: TYPE t_cur_app_address_dtls IS REF CURSOR RETURN IGS_UC_APP_ADDRESES%ROWTYPE;
248: cur_app_address_dtls t_cur_app_address_dtls;
249:
250: --cur_app_address_dtls_rec app_address_record;
251: cur_app_address_dtls_rec IGS_UC_APP_ADDRESES%ROWTYPE;
252:
253: --jchakrab added for 3691220
254: TYPE app_name_record IS RECORD (
255: app_no IGS_UC_APP_NAMES.APP_NO%TYPE,

Line 1007: FROM IGS_UC_APP_ADDRESES

1003: --jchakrab added for 3691210
1004: IF p_app_no IS NULL THEN
1005: OPEN cur_app_address_dtls FOR
1006: SELECT *
1007: FROM IGS_UC_APP_ADDRESES
1008: WHERE SENT_TO_OSS_FLAG = 'N'
1009: ORDER BY APP_NO;
1010: ELSE
1011: OPEN cur_app_address_dtls FOR

Line 1013: FROM IGS_UC_APP_ADDRESES

1009: ORDER BY APP_NO;
1010: ELSE
1011: OPEN cur_app_address_dtls FOR
1012: SELECT *
1013: FROM IGS_UC_APP_ADDRESES
1014: WHERE APP_NO = p_app_no AND
1015: SENT_TO_OSS_FLAG = 'N'
1016: ORDER BY APP_NO;
1017: END IF;

Line 1019: -- Loop through all the records in IGS_UC_APP_ADDRESES table satisfying the criteria,

1015: SENT_TO_OSS_FLAG = 'N'
1016: ORDER BY APP_NO;
1017: END IF;
1018:
1019: -- Loop through all the records in IGS_UC_APP_ADDRESES table satisfying the criteria,
1020: -- SENT_TO_OSS_FLAG is N and passed parameter,P_APP_NO
1021: LOOP
1022: FETCH cur_app_address_dtls INTO cur_app_address_dtls_rec;
1023: EXIT WHEN cur_app_address_dtls%NOTFOUND;

Line 1225: /* Update the IGS_UC_APP_ADDRESES Table with AD_BATCH_ID => Admissions Batch ID and

1221: ROLLBACK TO l_exp_curr_applicant;
1222:
1223: ELSE
1224:
1225: /* Update the IGS_UC_APP_ADDRESES Table with AD_BATCH_ID => Admissions Batch ID and
1226: AD_INTERFACE_ID => Admissions Interface ID */
1227: cur_app_address_rec := NULL;
1228: OPEN cur_upd_app_address (cur_app_address_dtls_rec.app_no);
1229: FETCH cur_upd_app_address INTO cur_app_address_rec;

Line 1231: igs_uc_app_addreses_pkg.update_row (

1227: cur_app_address_rec := NULL;
1228: OPEN cur_upd_app_address (cur_app_address_dtls_rec.app_no);
1229: FETCH cur_upd_app_address INTO cur_app_address_rec;
1230: CLOSE cur_upd_app_address;
1231: igs_uc_app_addreses_pkg.update_row (
1232: x_rowid => cur_app_address_rec.rowid,
1233: x_app_no => cur_app_address_rec.app_no,
1234: x_address_area => cur_app_address_rec.address_area,
1235: x_address1 => cur_app_address_rec.address1,

Line 1539: -- Processing the records in the IGS_UC_APP_ADDRESES Table

1535: ,x_country_birth => cur_ucas_app_rec.country_birth );
1536:
1537: END LOOP;
1538:
1539: -- Processing the records in the IGS_UC_APP_ADDRESES Table
1540: FOR cur_proc_app_address_rec IN cur_proc_app_address(l_ad_batch_id) LOOP
1541:
1542: -- Check whether the record exist in the IGS_AD_INTERFACE Table for the
1543: -- Admission Batch ID and Interface ID

Line 1555: -- Update the IGS_UC_APP_ADDRESES Table

1551: l_sent_to_oss_flag := 'Y';
1552: END IF;
1553: CLOSE cur_ad_interface_exist;
1554:
1555: -- Update the IGS_UC_APP_ADDRESES Table
1556: cur_app_address_rec := NULL;
1557: OPEN cur_upd_app_address (cur_proc_app_address_rec.app_no);
1558: FETCH cur_upd_app_address INTO cur_app_address_rec;
1559: CLOSE cur_upd_app_address;

Line 1560: igs_uc_app_addreses_pkg.update_row (

1556: cur_app_address_rec := NULL;
1557: OPEN cur_upd_app_address (cur_proc_app_address_rec.app_no);
1558: FETCH cur_upd_app_address INTO cur_app_address_rec;
1559: CLOSE cur_upd_app_address;
1560: igs_uc_app_addreses_pkg.update_row (
1561: x_rowid => cur_app_address_rec.rowid,
1562: x_app_no => cur_app_address_rec.app_no,
1563: x_address_area => cur_app_address_rec.address_area,
1564: x_address1 => cur_app_address_rec.address1,

Line 1727: -- Processing the records in the IGS_UC_APP_ADDRESES Table with SENT_TO_OSS_FLAG set to 'I'

1723: END LOOP;
1724:
1725:
1726: -- anwest Bug# 3642740
1727: -- Processing the records in the IGS_UC_APP_ADDRESES Table with SENT_TO_OSS_FLAG set to 'I'
1728: FOR cur_proc_app_address_i_rec IN cur_proc_app_address_i LOOP
1729:
1730: -- Check whether the record exist in the IGS_AD_INTERFACE Table for the
1731: -- Admission Batch ID and Interface ID

Line 1742: igs_uc_app_addreses_pkg.update_row (

1738: cur_app_address_rec := NULL;
1739: OPEN cur_upd_app_address (cur_proc_app_address_i_rec.app_no);
1740: FETCH cur_upd_app_address INTO cur_app_address_rec;
1741: CLOSE cur_upd_app_address;
1742: igs_uc_app_addreses_pkg.update_row (
1743: x_rowid => cur_app_address_rec.rowid,
1744: x_app_no => cur_app_address_rec.app_no,
1745: x_address_area => cur_app_address_rec.address_area,
1746: x_address1 => cur_app_address_rec.address1,

Line 2777: FUNCTION get_country_code(p_app_no IN IGS_UC_APP_ADDRESES.app_no%TYPE,

2773:
2774: END pop_contact_int;
2775:
2776:
2777: FUNCTION get_country_code(p_app_no IN IGS_UC_APP_ADDRESES.app_no%TYPE,
2778: p_ucas_country_code IN VARCHAR2,
2779: p_address_area IN VARCHAR2,
2780: p_address4 IN VARCHAR2,
2781: p_adr_type IN VARCHAR2)

Line 2853: PROCEDURE pop_address_int ( p_app_address_dtls_rec IN IGS_UC_APP_ADDRESES%ROWTYPE,

2849:
2850: END get_country_code;
2851:
2852:
2853: PROCEDURE pop_address_int ( p_app_address_dtls_rec IN IGS_UC_APP_ADDRESES%ROWTYPE,
2854: p_domocile_apr IN VARCHAR2,
2855: p_interface_id IN NUMBER,
2856: p_addr_usage_home IN VARCHAR2,
2857: p_addr_usage_corr IN VARCHAR2,