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_AD_SS_APPL_PGS_PKG dependencies on IGS_AD_SS_APPL_PGS

Line 1: PACKAGE BODY igs_ad_ss_appl_pgs_pkg AS

1: PACKAGE BODY igs_ad_ss_appl_pgs_pkg AS
2: /* $Header: IGSAIF9B.pls 120.2 2005/08/01 05:47:44 appldev ship $ */
3:
4: PROCEDURE reset_checklist_data(p_admission_application_type IN igs_ad_ss_appl_pgs.admission_application_type%TYPE);
5:

Line 4: PROCEDURE reset_checklist_data(p_admission_application_type IN igs_ad_ss_appl_pgs.admission_application_type%TYPE);

1: PACKAGE BODY igs_ad_ss_appl_pgs_pkg AS
2: /* $Header: IGSAIF9B.pls 120.2 2005/08/01 05:47:44 appldev ship $ */
3:
4: PROCEDURE reset_checklist_data(p_admission_application_type IN igs_ad_ss_appl_pgs.admission_application_type%TYPE);
5:
6: l_rowid VARCHAR2(25);
7: old_references igs_ad_ss_appl_pgs%ROWTYPE;
8: new_references igs_ad_ss_appl_pgs%ROWTYPE;

Line 7: old_references igs_ad_ss_appl_pgs%ROWTYPE;

3:
4: PROCEDURE reset_checklist_data(p_admission_application_type IN igs_ad_ss_appl_pgs.admission_application_type%TYPE);
5:
6: l_rowid VARCHAR2(25);
7: old_references igs_ad_ss_appl_pgs%ROWTYPE;
8: new_references igs_ad_ss_appl_pgs%ROWTYPE;
9:
10: PROCEDURE set_column_values (
11: p_action IN VARCHAR2,

Line 8: new_references igs_ad_ss_appl_pgs%ROWTYPE;

4: PROCEDURE reset_checklist_data(p_admission_application_type IN igs_ad_ss_appl_pgs.admission_application_type%TYPE);
5:
6: l_rowid VARCHAR2(25);
7: old_references igs_ad_ss_appl_pgs%ROWTYPE;
8: new_references igs_ad_ss_appl_pgs%ROWTYPE;
9:
10: PROCEDURE set_column_values (
11: p_action IN VARCHAR2,
12: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 37: FROM igs_ad_ss_appl_pgs

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM igs_ad_ss_appl_pgs
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 122: FROM igs_ad_ss_appl_pgs

118: || (reverse chronological order - newest change first)
119: */
120: CURSOR cur_rowid IS
121: SELECT rowid
122: FROM igs_ad_ss_appl_pgs
123: WHERE page_name = x_page_name
124: AND admission_application_type = x_admission_application_type
125: FOR UPDATE NOWAIT;
126:

Line 184: FROM igs_ad_ss_appl_pgs

180: || (reverse chronological order - newest change first)
181: */
182: CURSOR cur_rowid IS
183: SELECT rowid
184: FROM igs_ad_ss_appl_pgs
185: WHERE ((admission_application_type = x_admission_appl_type));
186:
187: lv_rowid cur_rowid%RowType;
188:

Line 308: FROM igs_ad_ss_appl_pgs

304: || (reverse chronological order - newest change first)
305: */
306: CURSOR c IS
307: SELECT rowid
308: FROM igs_ad_ss_appl_pgs
309: WHERE page_name = x_page_name
310: AND admission_application_type = x_admission_application_type;
311:
312: x_last_update_date DATE;

Line 353: INSERT INTO igs_ad_ss_appl_pgs (

349: x_disp_order => x_disp_order,
350: x_page_disp_name => x_page_disp_name
351: );
352:
353: INSERT INTO igs_ad_ss_appl_pgs (
354: page_name,
355: admission_application_type,
356: include_ind,
357: required_ind,

Line 412: FROM igs_ad_ss_appl_pgs

408: CURSOR c1 IS
409: SELECT
410: include_ind,
411: page_disp_name
412: FROM igs_ad_ss_appl_pgs
413: WHERE rowid = x_rowid
414: FOR UPDATE NOWAIT;
415:
416: tlinfo c1%ROWTYPE;

Line 507: UPDATE igs_ad_ss_appl_pgs

503: x_disp_order => x_disp_order,
504: x_page_disp_name => x_page_disp_name
505: );
506:
507: UPDATE igs_ad_ss_appl_pgs
508: SET
509: include_ind = new_references.include_ind,
510: required_ind = new_references.required_ind,
511: last_update_date = x_last_update_date,

Line 553: FROM igs_ad_ss_appl_pgs

549: || (reverse chronological order - newest change first)
550: */
551: CURSOR c1 IS
552: SELECT rowid
553: FROM igs_ad_ss_appl_pgs
554: WHERE page_name = x_page_name
555: AND admission_application_type = x_admission_application_type;
556:
557: BEGIN

Line 611: DELETE FROM igs_ad_ss_appl_pgs

607: p_action => 'DELETE',
608: x_rowid => x_rowid
609: );
610:
611: DELETE FROM igs_ad_ss_appl_pgs
612: WHERE rowid = x_rowid;
613:
614: IF (SQL%NOTFOUND) THEN
615: RAISE NO_DATA_FOUND;

Line 620: PROCEDURE reset_checklist_data(p_admission_application_type IN igs_ad_ss_appl_pgs.admission_application_type%TYPE) AS

616: END IF;
617:
618: END delete_row;
619:
620: PROCEDURE reset_checklist_data(p_admission_application_type IN igs_ad_ss_appl_pgs.admission_application_type%TYPE) AS
621: /*
622: || Created By : tray
623: || Created On : 18-DEC-2002
624: || Purpose : Refreshes Checklist data on setup change

Line 635: CURSOR c_get_section_status(cp_person_id igs_ss_adm_appl_stg.person_id%TYPE,cp_appl_id igs_ss_adm_appl_stg.ss_adm_appl_id%TYPE,cp_section_name igs_ad_ss_appl_pgs.page_name%TYPE) IS

631: SELECT ss_adm_appl_id, person_id, admission_application_type
632: FROM IGS_SS_ADM_APPL_STG
633: WHERE admission_application_type = p_admission_application_type;
634:
635: CURSOR c_get_section_status(cp_person_id igs_ss_adm_appl_stg.person_id%TYPE,cp_appl_id igs_ss_adm_appl_stg.ss_adm_appl_id%TYPE,cp_section_name igs_ad_ss_appl_pgs.page_name%TYPE) IS
636: SELECT section, completion_status
637: FROM IGS_SS_AD_SEC_STAT
638: WHERE ss_adm_appl_id=cp_appl_id
639: AND person_id=cp_person_id

Line 644: FROM IGS_AD_SS_APPL_PGS

640: AND section=cp_section_name;
641:
642: CURSOR c_get_page_setup IS
643: SELECT *
644: FROM IGS_AD_SS_APPL_PGS
645: WHERE admission_application_type = p_admission_application_type;
646:
647: c_get_section_status_record c_get_section_status%ROWTYPE;
648:

Line 701: END igs_ad_ss_appl_pgs_pkg;

697: END IF;
698: END LOOP; --1
699: END reset_checklist_data ;
700:
701: END igs_ad_ss_appl_pgs_pkg;