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_APPLICANTS_PKG dependencies on DUAL

Line 122: x_dual_nationality IN NUMBER,

118: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
119: x_ad_batch_id IN NUMBER,
120: x_ad_interface_id IN NUMBER,
121: x_nationality IN NUMBER,
122: x_dual_nationality IN NUMBER,
123: x_special_needs IN VARCHAR2,
124: x_country_birth IN NUMBER,
125: x_personal_id IN VARCHAR2
126: ) AS

Line 266: new_references.dual_nationality := x_dual_nationality ;

262: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
263: new_references.ad_batch_id := x_ad_batch_id ;
264: new_references.ad_interface_id := x_ad_interface_id ;
265: new_references.nationality := x_nationality ;
266: new_references.dual_nationality := x_dual_nationality ;
267: new_references.special_needs := x_special_needs ;
268: new_references.country_birth := x_country_birth ;
269: new_references.personal_id := x_personal_id ;
270:

Line 656: x_dual_nationality IN NUMBER,

652: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
653: x_ad_batch_id IN NUMBER,
654: x_ad_interface_id IN NUMBER,
655: x_nationality IN NUMBER,
656: x_dual_nationality IN NUMBER,
657: x_special_needs IN VARCHAR2,
658: x_country_birth IN NUMBER,
659: x_personal_id IN VARCHAR2
660:

Line 787: x_dual_nationality ,

783: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
784: x_ad_batch_id ,
785: x_ad_interface_id ,
786: x_nationality ,
787: x_dual_nationality ,
788: x_special_needs ,
789: x_country_birth ,
790: x_personal_id
791: );

Line 941: x_dual_nationality IN NUMBER,

937: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
938: x_ad_batch_id IN NUMBER,
939: x_ad_interface_id IN NUMBER,
940: x_nationality IN NUMBER,
941: x_dual_nationality IN NUMBER,
942: x_special_needs IN VARCHAR2,
943: x_country_birth IN NUMBER,
944: x_personal_id IN VARCHAR2
945: ) AS

Line 991: FROM dual;

987: END IF;
988:
989: SELECT igs_uc_applicants_s1.NEXTVAL
990: INTO x_app_id
991: FROM dual;
992:
993: before_dml(
994: p_action => 'INSERT',
995: x_rowid => x_rowid,

Line 1104: x_dual_nationality => x_dual_nationality ,

1100: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
1101: x_ad_batch_id => x_ad_batch_id ,
1102: x_ad_interface_id => x_ad_interface_id ,
1103: x_nationality => x_nationality ,
1104: x_dual_nationality => x_dual_nationality ,
1105: x_special_needs => x_special_needs ,
1106: x_country_birth => x_country_birth ,
1107: x_personal_id => x_personal_id
1108: );

Line 1222: dual_nationality ,

1218: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
1219: ad_batch_id ,
1220: ad_interface_id ,
1221: nationality ,
1222: dual_nationality ,
1223: special_needs ,
1224: country_birth ,
1225: personal_id
1226: ) VALUES (

Line 1335: new_references.dual_nationality ,

1331: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
1332: new_references.ad_batch_id ,
1333: new_references.ad_interface_id ,
1334: new_references.nationality ,
1335: new_references.dual_nationality ,
1336: new_references.special_needs ,
1337: new_references.country_birth ,
1338: new_references.personal_id
1339: );

Line 1479: x_dual_nationality IN NUMBER,

1475: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
1476: x_ad_batch_id IN NUMBER,
1477: x_ad_interface_id IN NUMBER,
1478: x_nationality IN NUMBER,
1479: x_dual_nationality IN NUMBER,
1480: x_special_needs IN VARCHAR2,
1481: x_country_birth IN NUMBER,
1482: x_personal_id IN VARCHAR2
1483: ) AS

Line 1598: dual_nationality ,

1594: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
1595: ad_batch_id ,
1596: ad_interface_id ,
1597: nationality ,
1598: dual_nationality ,
1599: special_needs ,
1600: country_birth ,
1601: personal_id
1602: FROM igs_uc_applicants

Line 1724: AND ((tlinfo.dual_nationality = x_dual_nationality ) OR (( tlinfo.dual_nationality IS NULL) AND ( x_edu_qualification IS NULL)))

1720: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
1721: AND ((tlinfo.ad_batch_id = x_ad_batch_id ) OR (( tlinfo.ad_batch_id IS NULL) AND ( x_ad_batch_id IS NULL)))
1722: AND ((tlinfo.ad_interface_id = x_ad_interface_id ) OR (( tlinfo.ad_interface_id IS NULL) AND ( x_ad_interface_id IS NULL)))
1723: AND ((tlinfo.nationality = x_nationality ) OR (( tlinfo.nationality IS NULL) AND ( x_nationality IS NULL)))
1724: AND ((tlinfo.dual_nationality = x_dual_nationality ) OR (( tlinfo.dual_nationality IS NULL) AND ( x_edu_qualification IS NULL)))
1725: AND ((tlinfo.special_needs = x_special_needs ) OR (( tlinfo.special_needs IS NULL) AND ( x_special_needs IS NULL)))
1726: AND ((tlinfo.country_birth = x_country_birth ) OR (( tlinfo.country_birth IS NULL) AND ( x_country_birth IS NULL)))
1727: AND ((tlinfo.personal_id = x_personal_id ) OR (( tlinfo.personal_id IS NULL) AND ( x_personal_id IS NULL)))
1728: ) THEN

Line 1849: x_dual_nationality IN NUMBER,

1845: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
1846: x_ad_batch_id IN NUMBER,
1847: x_ad_interface_id IN NUMBER,
1848: x_nationality IN NUMBER,
1849: x_dual_nationality IN NUMBER,
1850: x_special_needs IN VARCHAR2,
1851: x_country_birth IN NUMBER,
1852: x_personal_id IN VARCHAR2
1853: ) AS

Line 2001: x_dual_nationality => x_dual_nationality ,

1997: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
1998: x_ad_batch_id => x_ad_batch_id ,
1999: x_ad_interface_id => x_ad_interface_id ,
2000: x_nationality => x_nationality ,
2001: x_dual_nationality => x_dual_nationality ,
2002: x_special_needs => x_special_needs ,
2003: x_country_birth => x_country_birth ,
2004: x_personal_id => x_personal_id
2005: );

Line 2117: dual_nationality = new_references.dual_nationality ,

2113: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
2114: ad_batch_id = new_references.ad_batch_id ,
2115: ad_interface_id = new_references.ad_interface_id ,
2116: nationality = new_references.nationality ,
2117: dual_nationality = new_references.dual_nationality ,
2118: special_needs = new_references.special_needs ,
2119: country_birth = new_references.country_birth ,
2120: personal_id = new_references.personal_id
2121: WHERE rowid = x_rowid;

Line 2262: x_dual_nationality IN NUMBER,

2258: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
2259: x_ad_batch_id IN NUMBER,
2260: x_ad_interface_id IN NUMBER,
2261: x_nationality IN NUMBER,
2262: x_dual_nationality IN NUMBER,
2263: x_special_needs IN VARCHAR2,
2264: x_country_birth IN NUMBER,
2265: x_personal_id IN VARCHAR2
2266: ) AS

Line 2395: x_dual_nationality ,

2391: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
2392: x_ad_batch_id ,
2393: x_ad_interface_id ,
2394: x_nationality ,
2395: x_dual_nationality ,
2396: x_special_needs ,
2397: x_country_birth ,
2398: x_personal_id
2399: );

Line 2510: x_dual_nationality ,

2506: -- smaddali added these columns for ucfd203 - multiple cycles bug#2669208
2507: x_ad_batch_id ,
2508: x_ad_interface_id ,
2509: x_nationality ,
2510: x_dual_nationality ,
2511: x_special_needs ,
2512: x_country_birth ,
2513: x_personal_id
2514: );