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_TYP_PKG dependencies on IGS_AD_SS_APPL_TYP

Line 1: PACKAGE BODY igs_ad_ss_appl_typ_pkg AS

1: PACKAGE BODY igs_ad_ss_appl_typ_pkg AS
2: /* $Header: IGSAIF8B.pls 120.2 2005/12/15 03:52:25 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_ss_appl_typ%ROWTYPE;

Line 5: old_references igs_ad_ss_appl_typ%ROWTYPE;

1: PACKAGE BODY igs_ad_ss_appl_typ_pkg AS
2: /* $Header: IGSAIF8B.pls 120.2 2005/12/15 03:52:25 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_ss_appl_typ%ROWTYPE;
6: new_references igs_ad_ss_appl_typ%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_ss_appl_typ%ROWTYPE;

2: /* $Header: IGSAIF8B.pls 120.2 2005/12/15 03:52:25 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_ss_appl_typ%ROWTYPE;
6: new_references igs_ad_ss_appl_typ%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 47: FROM igs_ad_ss_appl_typ

43: */
44:
45: CURSOR cur_old_ref_values IS
46: SELECT *
47: FROM igs_ad_ss_appl_typ
48: WHERE rowid = x_rowid;
49:
50: BEGIN
51:

Line 140: || vdixit 09-Jan-2001 Calls to igs_ad_aptyp_pestat_pkg.get_fk_igs_ad_ss_appl_typ

136: || Known limitations, enhancements or remarks :
137: || Change History :
138: || Who When What
139: || (reverse chronological order - newest change first)
140: || vdixit 09-Jan-2001 Calls to igs_ad_aptyp_pestat_pkg.get_fk_igs_ad_ss_appl_typ
141: || and igs_ad_pestat_group_pkg.get_fk_igs_ad_ss_appl_typ added
142: || a part of Enh. 2152871
143: || rboddu 26-dec-2001 added call to igs_ad_appl_pkg.get_fk_igs_ad_ss_appl_typ procedure.
144: || Bug no : 2158524

Line 141: || and igs_ad_pestat_group_pkg.get_fk_igs_ad_ss_appl_typ added

137: || Change History :
138: || Who When What
139: || (reverse chronological order - newest change first)
140: || vdixit 09-Jan-2001 Calls to igs_ad_aptyp_pestat_pkg.get_fk_igs_ad_ss_appl_typ
141: || and igs_ad_pestat_group_pkg.get_fk_igs_ad_ss_appl_typ added
142: || a part of Enh. 2152871
143: || rboddu 26-dec-2001 added call to igs_ad_appl_pkg.get_fk_igs_ad_ss_appl_typ procedure.
144: || Bug no : 2158524
145: || rghosh 28-oct-2002 Added the get fk calls to the tables IGS_AD_DEPLVL_PRG and

Line 143: || rboddu 26-dec-2001 added call to igs_ad_appl_pkg.get_fk_igs_ad_ss_appl_typ procedure.

139: || (reverse chronological order - newest change first)
140: || vdixit 09-Jan-2001 Calls to igs_ad_aptyp_pestat_pkg.get_fk_igs_ad_ss_appl_typ
141: || and igs_ad_pestat_group_pkg.get_fk_igs_ad_ss_appl_typ added
142: || a part of Enh. 2152871
143: || rboddu 26-dec-2001 added call to igs_ad_appl_pkg.get_fk_igs_ad_ss_appl_typ procedure.
144: || Bug no : 2158524
145: || rghosh 28-oct-2002 Added the get fk calls to the tables IGS_AD_DEPLVL_PRG and
146: || IGS_AD_DEPLVL_PRGTY for Bug #2602077
147: */

Line 150: igs_ad_appl_pkg.get_fk_igs_ad_ss_appl_typ(

146: || IGS_AD_DEPLVL_PRGTY for Bug #2602077
147: */
148: BEGIN
149:
150: igs_ad_appl_pkg.get_fk_igs_ad_ss_appl_typ(
151: old_references.admission_application_type
152: );
153:
154: igs_ad_aptyp_pestat_pkg.get_fk_igs_ad_ss_appl_typ(

Line 154: igs_ad_aptyp_pestat_pkg.get_fk_igs_ad_ss_appl_typ(

150: igs_ad_appl_pkg.get_fk_igs_ad_ss_appl_typ(
151: old_references.admission_application_type
152: );
153:
154: igs_ad_aptyp_pestat_pkg.get_fk_igs_ad_ss_appl_typ(
155: old_references.admission_application_type
156: );
157:
158: igs_ad_pestat_group_pkg.get_fk_igs_ad_ss_appl_typ(

Line 158: igs_ad_pestat_group_pkg.get_fk_igs_ad_ss_appl_typ(

154: igs_ad_aptyp_pestat_pkg.get_fk_igs_ad_ss_appl_typ(
155: old_references.admission_application_type
156: );
157:
158: igs_ad_pestat_group_pkg.get_fk_igs_ad_ss_appl_typ(
159: old_references.admission_application_type
160: );
161: igs_ad_deplvl_prgty_pkg.get_fk_igs_ad_ss_appl_typ(
162: old_references.admission_application_type

Line 161: igs_ad_deplvl_prgty_pkg.get_fk_igs_ad_ss_appl_typ(

157:
158: igs_ad_pestat_group_pkg.get_fk_igs_ad_ss_appl_typ(
159: old_references.admission_application_type
160: );
161: igs_ad_deplvl_prgty_pkg.get_fk_igs_ad_ss_appl_typ(
162: old_references.admission_application_type
163: );
164: igs_ad_deplvl_prg_pkg.get_fk_igs_ad_ss_appl_typ(
165: old_references.admission_application_type

Line 164: igs_ad_deplvl_prg_pkg.get_fk_igs_ad_ss_appl_typ(

160: );
161: igs_ad_deplvl_prgty_pkg.get_fk_igs_ad_ss_appl_typ(
162: old_references.admission_application_type
163: );
164: igs_ad_deplvl_prg_pkg.get_fk_igs_ad_ss_appl_typ(
165: old_references.admission_application_type
166: );
167:
168: igs_uc_defaults_pkg.get_fk_igs_ad_ss_appl_typ(

Line 168: igs_uc_defaults_pkg.get_fk_igs_ad_ss_appl_typ(

164: igs_ad_deplvl_prg_pkg.get_fk_igs_ad_ss_appl_typ(
165: old_references.admission_application_type
166: );
167:
168: igs_uc_defaults_pkg.get_fk_igs_ad_ss_appl_typ(
169: old_references.admission_application_type );
170:
171:
172: END check_child_existance;

Line 190: FROM igs_ad_ss_appl_typ

186: || (reverse chronological order - newest change first)
187: */
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM igs_ad_ss_appl_typ
191: WHERE UPPER(admission_application_type) = UPPER(x_admission_application_type) AND
192: closed_ind = NVL(x_closed_ind,closed_ind);
193:
194: lv_rowid cur_rowid%RowType;

Line 226: FROM igs_ad_ss_appl_typ

222: (reverse chronological order - newest change first)
223: ***************************************************************/
224: CURSOR cur_rowid IS
225: SELECT rowid
226: FROM igs_ad_ss_appl_typ
227: WHERE admission_cat = x_admission_cat
228: AND s_admission_process_type = x_s_admission_process_type ;
229:
230: lv_rowid cur_rowid%RowType;

Line 416: FROM igs_ad_ss_appl_typ

412: || (reverse chronological order - newest change first)
413: */
414: CURSOR c IS
415: SELECT rowid
416: FROM igs_ad_ss_appl_typ
417: WHERE admission_application_type = x_admission_application_type;
418:
419: x_last_update_date DATE;
420: x_last_updated_by NUMBER;

Line 472: INSERT INTO igs_ad_ss_appl_typ (

468: x_submit_instr => x_submit_instr,
469: x_submit_err_instr => x_submit_err_instr
470: );
471:
472: INSERT INTO igs_ad_ss_appl_typ (
473: admission_application_type,
474: description,
475: admission_cat,
476: s_admission_process_type,

Line 588: FROM igs_ad_ss_appl_typ

584: use_in_appl_self_srvc,
585: crt_rev_instr,
586: submit_instr,
587: submit_err_instr
588: FROM igs_ad_ss_appl_typ
589: WHERE rowid = x_rowid
590: FOR UPDATE NOWAIT;
591:
592: tlinfo c1%ROWTYPE;

Line 728: UPDATE igs_ad_ss_appl_typ

724: x_submit_instr => x_submit_instr,
725: x_submit_err_instr => x_submit_err_instr
726: );
727:
728: UPDATE igs_ad_ss_appl_typ
729: SET
730: description = new_references.description,
731: admission_cat = new_references.admission_cat,
732: s_admission_process_type = new_references.s_admission_process_type,

Line 798: FROM igs_ad_ss_appl_typ

794: || (reverse chronological order - newest change first)
795: */
796: CURSOR c1 IS
797: SELECT rowid
798: FROM igs_ad_ss_appl_typ
799: WHERE admission_application_type = x_admission_application_type;
800:
801: BEGIN
802:

Line 875: FROM igs_ad_ss_appl_typ

871: */
872:
873: CURSOR c_del_at_ss_pgs (v_rowid VARCHAR2) IS
874: SELECT admission_application_type
875: FROM igs_ad_ss_appl_typ
876: WHERE rowid=v_rowid;
877:
878: CURSOR c_del_sspgs(v_atyp VARCHAR2) IS
879: SELECT ROWID

Line 885: v_aat igs_ad_ss_appl_typ.admission_application_type%TYPE;

881: WHERE admission_application_type=v_atyp;
882:
883: rec_c_del_sspgs c_del_sspgs%ROWTYPE;
884:
885: v_aat igs_ad_ss_appl_typ.admission_application_type%TYPE;
886: BEGIN
887:
888: before_dml (
889: p_action => 'DELETE',

Line 902: DELETE FROM igs_ad_ss_appl_typ

898: igs_ad_ss_appl_pgs_pkg.delete_row(x_rowid => rec_c_del_sspgs.rowid);
899: END LOOP;
900:
901:
902: DELETE FROM igs_ad_ss_appl_typ
903: WHERE rowid = x_rowid;
904:
905: IF (SQL%NOTFOUND) THEN
906: RAISE NO_DATA_FOUND;

Line 929: END igs_ad_ss_appl_typ_pkg;

925:
926: END check_child_existance_apc;
927:
928:
929: END igs_ad_ss_appl_typ_pkg;