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 IGS_UC_APPLICANTS

Line 1: PACKAGE BODY igs_uc_applicants_pkg AS

1: PACKAGE BODY igs_uc_applicants_pkg AS
2: /* $Header: IGSXI01B.pls 120.3 2006/08/21 03:36:34 jbaber ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_applicants%ROWTYPE;

Line 5: old_references igs_uc_applicants%ROWTYPE;

1: PACKAGE BODY igs_uc_applicants_pkg AS
2: /* $Header: IGSXI01B.pls 120.3 2006/08/21 03:36:34 jbaber ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_applicants%ROWTYPE;
6: new_references igs_uc_applicants%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_applicants%ROWTYPE;

2: /* $Header: IGSXI01B.pls 120.3 2006/08/21 03:36:34 jbaber ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_applicants%ROWTYPE;
6: new_references igs_uc_applicants%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 141: FROM IGS_UC_APPLICANTS

137: */
138:
139: CURSOR cur_old_ref_values IS
140: SELECT *
141: FROM IGS_UC_APPLICANTS
142: WHERE rowid = x_rowid;
143:
144: BEGIN
145:

Line 304: igs_uc_app_choices_pkg.get_fk_igs_uc_applicants (

300: || (reverse chronological order - newest change first)
301: */
302: BEGIN
303:
304: igs_uc_app_choices_pkg.get_fk_igs_uc_applicants (
305: old_references.app_id
306: );
307:
308: igs_uc_app_clearing_pkg.get_fk_igs_uc_applicants (

Line 308: igs_uc_app_clearing_pkg.get_fk_igs_uc_applicants (

304: igs_uc_app_choices_pkg.get_fk_igs_uc_applicants (
305: old_references.app_id
306: );
307:
308: igs_uc_app_clearing_pkg.get_fk_igs_uc_applicants (
309: old_references.app_id
310: );
311:
312: igs_uc_app_stats_pkg.get_fk_igs_uc_applicants (

Line 312: igs_uc_app_stats_pkg.get_fk_igs_uc_applicants (

308: igs_uc_app_clearing_pkg.get_fk_igs_uc_applicants (
309: old_references.app_id
310: );
311:
312: igs_uc_app_stats_pkg.get_fk_igs_uc_applicants (
313: old_references.app_id
314: );
315:
316: igs_uc_app_results_pkg.get_fk_igs_uc_applicants(

Line 316: igs_uc_app_results_pkg.get_fk_igs_uc_applicants(

312: igs_uc_app_stats_pkg.get_fk_igs_uc_applicants (
313: old_references.app_id
314: );
315:
316: igs_uc_app_results_pkg.get_fk_igs_uc_applicants(
317: old_references.app_id
318: );
319:
320: -- smaddali added these new child checks as part of bug#2669208 - ucfd203 multiple cycles build

Line 321: igs_uc_app_addreses_pkg.get_ufk_igs_uc_applicants(

317: old_references.app_id
318: );
319:
320: -- smaddali added these new child checks as part of bug#2669208 - ucfd203 multiple cycles build
321: igs_uc_app_addreses_pkg.get_ufk_igs_uc_applicants(
322: old_references.app_no
323: );
324:
325: igs_uc_app_names_pkg.get_ufk_igs_uc_applicants(

Line 325: igs_uc_app_names_pkg.get_ufk_igs_uc_applicants(

321: igs_uc_app_addreses_pkg.get_ufk_igs_uc_applicants(
322: old_references.app_no
323: );
324:
325: igs_uc_app_names_pkg.get_ufk_igs_uc_applicants(
326: old_references.app_no
327: );
328:
329: igs_uc_app_referees_pkg.get_ufk_igs_uc_applicants(

Line 329: igs_uc_app_referees_pkg.get_ufk_igs_uc_applicants(

325: igs_uc_app_names_pkg.get_ufk_igs_uc_applicants(
326: old_references.app_no
327: );
328:
329: igs_uc_app_referees_pkg.get_ufk_igs_uc_applicants(
330: old_references.app_no
331: );
332:
333: igs_uc_form_quals_pkg.get_ufk_igs_uc_applicants(

Line 333: igs_uc_form_quals_pkg.get_ufk_igs_uc_applicants(

329: igs_uc_app_referees_pkg.get_ufk_igs_uc_applicants(
330: old_references.app_no
331: );
332:
333: igs_uc_form_quals_pkg.get_ufk_igs_uc_applicants(
334: old_references.app_no
335: );
336:
337: END check_child_existance;

Line 419: FROM igs_uc_applicants

415: || (reverse chronological order - newest change first)
416: */
417: CURSOR cur_rowid IS
418: SELECT rowid
419: FROM igs_uc_applicants
420: WHERE ((system_code = x_system_code));
421:
422: lv_rowid cur_rowid%RowType;
423:

Line 453: FROM igs_uc_applicants

449: || (reverse chronological order - newest change first)
450: */
451: CURSOR cur_rowid IS
452: SELECT rowid
453: FROM igs_uc_applicants
454: WHERE ((oss_person_id = x_oss_person_id));
455:
456: lv_rowid cur_rowid%RowType;
457:

Line 487: FROM igs_uc_applicants

483: || (reverse chronological order - newest change first)
484: */
485: CURSOR cur_rowid IS
486: SELECT rowid
487: FROM igs_uc_applicants
488: WHERE app_id = x_app_id ;
489:
490: lv_rowid cur_rowid%RowType;
491:

Line 522: FROM igs_uc_applicants

518: || (reverse chronological order - newest change first)
519: */
520: CURSOR cur_rowid IS
521: SELECT rowid
522: FROM igs_uc_applicants
523: WHERE app_no = x_app_no
524: AND ((l_rowid IS NULL) OR (rowid <> l_rowid)) ;
525:
526: lv_rowid cur_rowid%RowType;

Line 954: || igs_uc_applicants_s2 which is removed now. UCFD06-Bug#2574566.

950: || Known limitations, enhancements or remarks :
951: || Change History :
952: || Who When What
953: || Nishikant 24SEP2002 The value for the column enquiry_no was being populated from a sequence
954: || igs_uc_applicants_s2 which is removed now. UCFD06-Bug#2574566.
955: || smaddali added columns for ucfd203 - multiple cycles bug#2669208
956: || (reverse chronological order - newest change first)
957: || dsridhar 27-AUG-2003 Bug No: 3087784. Resetting the value of l_rowid to NULL.
958: */

Line 961: FROM igs_uc_applicants

957: || dsridhar 27-AUG-2003 Bug No: 3087784. Resetting the value of l_rowid to NULL.
958: */
959: CURSOR c IS
960: SELECT rowid
961: FROM igs_uc_applicants
962: WHERE app_id = x_app_id;
963:
964: x_last_update_date DATE;
965: x_last_updated_by NUMBER;

Line 989: SELECT igs_uc_applicants_s1.NEXTVAL

985: igs_ge_msg_stack.add;
986: app_exception.raise_exception;
987: END IF;
988:
989: SELECT igs_uc_applicants_s1.NEXTVAL
990: INTO x_app_id
991: FROM dual;
992:
993: before_dml(

Line 1113: INSERT INTO igs_uc_applicants (

1109:
1110: IF (x_mode = 'S') THEN
1111: igs_sc_gen_001.set_ctx('R');
1112: END IF;
1113: INSERT INTO igs_uc_applicants (
1114: app_id,
1115: app_no,
1116: check_digit,
1117: enquiry_no,

Line 1602: FROM igs_uc_applicants

1598: dual_nationality ,
1599: special_needs ,
1600: country_birth ,
1601: personal_id
1602: FROM igs_uc_applicants
1603: WHERE rowid = x_rowid
1604: FOR UPDATE NOWAIT;
1605:
1606: tlinfo c1%ROWTYPE;

Line 2010: UPDATE igs_uc_applicants

2006:
2007: IF (x_mode = 'S') THEN
2008: igs_sc_gen_001.set_ctx('R');
2009: END IF;
2010: UPDATE igs_uc_applicants
2011: SET
2012: app_no = new_references.app_no,
2013: check_digit = new_references.check_digit,
2014: enquiry_no = new_references.enquiry_no,

Line 2279: FROM igs_uc_applicants

2275: || (reverse chronological order - newest change first)
2276: */
2277: CURSOR c1 IS
2278: SELECT rowid
2279: FROM igs_uc_applicants
2280: WHERE app_id = x_app_id;
2281:
2282: BEGIN
2283:

Line 2543: DELETE FROM igs_uc_applicants

2539:
2540: IF (x_mode = 'S') THEN
2541: igs_sc_gen_001.set_ctx('R');
2542: END IF;
2543: DELETE FROM igs_uc_applicants
2544: WHERE rowid = x_rowid;
2545:
2546: IF (SQL%NOTFOUND) THEN
2547: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 2562: END igs_uc_applicants_pkg;

2558: l_rowid := NULL;
2559:
2560: END delete_row;
2561:
2562: END igs_uc_applicants_pkg;