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.

[Home] [Help]

APPS.IGS_AD_CODE_CLASSES_PKG dependencies on IGS_AD_CODE_CLASSES

Line 1: PACKAGE BODY igs_ad_code_classes_pkg AS

1: PACKAGE BODY igs_ad_code_classes_pkg AS
2: /* $Header: IGSAI75B.pls 120.3 2005/09/21 07:03:17 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_code_classes%RowType;
5: new_references igs_ad_code_classes%RowType;

Line 4: old_references igs_ad_code_classes%RowType;

1: PACKAGE BODY igs_ad_code_classes_pkg AS
2: /* $Header: IGSAI75B.pls 120.3 2005/09/21 07:03:17 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_code_classes%RowType;
5: new_references igs_ad_code_classes%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_code_classes%RowType;

1: PACKAGE BODY igs_ad_code_classes_pkg AS
2: /* $Header: IGSAI75B.pls 120.3 2005/09/21 07:03:17 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_code_classes%RowType;
5: new_references igs_ad_code_classes%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2,

Line 40: FROM IGS_AD_CODE_CLASSES

36: ***************************************************************/
37:
38: CURSOR cur_old_ref_values IS
39: SELECT *
40: FROM IGS_AD_CODE_CLASSES
41: WHERE rowid = x_rowid;
42:
43: BEGIN
44:

Line 191: Added the call igs_ad_recruit_pi_pkg.get_fk_igs_ad_code_classes for

187: as part of Bug#2177686 to IGS_PE_CREDENTIALS
188: agairola 09-AUG-2001 Added the code for Foreign Key with Statistics and IGS_PE_HZ_PARTIES
189: for Bug No. 1872994
190: pkpatel 19-JUL-2001 Bug no. 1890270 Admissions Standards and Rules Dld_adsr_setup
191: Added the call igs_ad_recruit_pi_pkg.get_fk_igs_ad_code_classes for
192: checking child existence in igs_ad_recruit_pi table
193: nsinha Aug 01, 2001 Bug enh no : 1905651 changes.
194: Added Igs_Ad_Appl_Pkg.Get_FK_Igs_Ad_Code_Classes
195: rboddu Oct 10, 2001 Bug no: 2019075 changes

Line 194: Added Igs_Ad_Appl_Pkg.Get_FK_Igs_Ad_Code_Classes

190: pkpatel 19-JUL-2001 Bug no. 1890270 Admissions Standards and Rules Dld_adsr_setup
191: Added the call igs_ad_recruit_pi_pkg.get_fk_igs_ad_code_classes for
192: checking child existence in igs_ad_recruit_pi table
193: nsinha Aug 01, 2001 Bug enh no : 1905651 changes.
194: Added Igs_Ad_Appl_Pkg.Get_FK_Igs_Ad_Code_Classes
195: rboddu Oct 10, 2001 Bug no: 2019075 changes
196: Added Igs_Ad_Acad_Honors_Pkg..Get_FK_Igs_Ad_Cod
197: npalanis OCT 31 2002 Bug : 2608360
198: remove get fk for code classes migrated to lookups e_classes for checking

Line 208: Igs_Ad_Adv_Placement_Pkg.Get_FK_Igs_Ad_Code_Classes (

204: ***************************************************************/
205:
206: BEGIN
207:
208: Igs_Ad_Adv_Placement_Pkg.Get_FK_Igs_Ad_Code_Classes (
209: old_references.code_id
210: );
211:
212: Igs_Ad_Appl_Eval_Pkg.Get_FK_Igs_Ad_Code_Classes (

Line 212: Igs_Ad_Appl_Eval_Pkg.Get_FK_Igs_Ad_Code_Classes (

208: Igs_Ad_Adv_Placement_Pkg.Get_FK_Igs_Ad_Code_Classes (
209: old_references.code_id
210: );
211:
212: Igs_Ad_Appl_Eval_Pkg.Get_FK_Igs_Ad_Code_Classes (
213: old_references.code_id
214: );
215:
216: Igs_Ad_App_Intent_Pkg.Get_FK_Igs_Ad_Code_Classes (

Line 216: Igs_Ad_App_Intent_Pkg.Get_FK_Igs_Ad_Code_Classes (

212: Igs_Ad_Appl_Eval_Pkg.Get_FK_Igs_Ad_Code_Classes (
213: old_references.code_id
214: );
215:
216: Igs_Ad_App_Intent_Pkg.Get_FK_Igs_Ad_Code_Classes (
217: old_references.code_id
218: );
219:
220: Igs_Ad_App_Req_Pkg.Get_FK_Igs_Ad_Code_Classes (

Line 220: Igs_Ad_App_Req_Pkg.Get_FK_Igs_Ad_Code_Classes (

216: Igs_Ad_App_Intent_Pkg.Get_FK_Igs_Ad_Code_Classes (
217: old_references.code_id
218: );
219:
220: Igs_Ad_App_Req_Pkg.Get_FK_Igs_Ad_Code_Classes (
221: old_references.code_id
222: );
223:
224: Igs_Ad_Conv_Gs_Types_Pkg.Get_FK_Igs_Ad_Code_Classes (

Line 224: Igs_Ad_Conv_Gs_Types_Pkg.Get_FK_Igs_Ad_Code_Classes (

220: Igs_Ad_App_Req_Pkg.Get_FK_Igs_Ad_Code_Classes (
221: old_references.code_id
222: );
223:
224: Igs_Ad_Conv_Gs_Types_Pkg.Get_FK_Igs_Ad_Code_Classes (
225: old_references.code_id
226: );
227:
228: Igs_Ad_Edugoal_Pkg.Get_FK_Igs_Ad_Code_Classes (

Line 228: Igs_Ad_Edugoal_Pkg.Get_FK_Igs_Ad_Code_Classes (

224: Igs_Ad_Conv_Gs_Types_Pkg.Get_FK_Igs_Ad_Code_Classes (
225: old_references.code_id
226: );
227:
228: Igs_Ad_Edugoal_Pkg.Get_FK_Igs_Ad_Code_Classes (
229: old_references.code_id
230: );
231:
232:

Line 233: Igs_Ad_Past_History_Pkg.Get_FK_Igs_Ad_Code_Classes (

229: old_references.code_id
230: );
231:
232:
233: Igs_Ad_Past_History_Pkg.Get_FK_Igs_Ad_Code_Classes (
234: old_references.code_id
235: );
236:
237: Igs_Ad_Ps_Appl_Inst_Pkg.Get_FK_Igs_Ad_Code_Classes (

Line 237: Igs_Ad_Ps_Appl_Inst_Pkg.Get_FK_Igs_Ad_Code_Classes (

233: Igs_Ad_Past_History_Pkg.Get_FK_Igs_Ad_Code_Classes (
234: old_references.code_id
235: );
236:
237: Igs_Ad_Ps_Appl_Inst_Pkg.Get_FK_Igs_Ad_Code_Classes (
238: old_references.code_id
239: );
240:
241: Igs_Ad_Spl_Talents_Pkg.Get_FK_Igs_Ad_Code_Classes (

Line 241: Igs_Ad_Spl_Talents_Pkg.Get_FK_Igs_Ad_Code_Classes (

237: Igs_Ad_Ps_Appl_Inst_Pkg.Get_FK_Igs_Ad_Code_Classes (
238: old_references.code_id
239: );
240:
241: Igs_Ad_Spl_Talents_Pkg.Get_FK_Igs_Ad_Code_Classes (
242: old_references.code_id
243: );
244:
245: Igs_Ad_Term_Unitdtls_Pkg.Get_FK_Igs_Ad_Code_Classes (

Line 245: Igs_Ad_Term_Unitdtls_Pkg.Get_FK_Igs_Ad_Code_Classes (

241: Igs_Ad_Spl_Talents_Pkg.Get_FK_Igs_Ad_Code_Classes (
242: old_references.code_id
243: );
244:
245: Igs_Ad_Term_Unitdtls_Pkg.Get_FK_Igs_Ad_Code_Classes (
246: old_references.code_id
247: );
248:
249: Igs_Ad_Test_Results_Pkg.Get_FK_Igs_Ad_Code_Classes (

Line 249: Igs_Ad_Test_Results_Pkg.Get_FK_Igs_Ad_Code_Classes (

245: Igs_Ad_Term_Unitdtls_Pkg.Get_FK_Igs_Ad_Code_Classes (
246: old_references.code_id
247: );
248:
249: Igs_Ad_Test_Results_Pkg.Get_FK_Igs_Ad_Code_Classes (
250: old_references.code_id
251: );
252:
253: Igs_Ad_Transcript_Pkg.Get_FK_Igs_Ad_Code_Classes (

Line 253: Igs_Ad_Transcript_Pkg.Get_FK_Igs_Ad_Code_Classes (

249: Igs_Ad_Test_Results_Pkg.Get_FK_Igs_Ad_Code_Classes (
250: old_references.code_id
251: );
252:
253: Igs_Ad_Transcript_Pkg.Get_FK_Igs_Ad_Code_Classes (
254: old_references.code_id
255: );
256:
257: Igs_Ad_Tst_Rslt_Dtls_Pkg.Get_FK_Igs_Ad_Code_Classes (

Line 257: Igs_Ad_Tst_Rslt_Dtls_Pkg.Get_FK_Igs_Ad_Code_Classes (

253: Igs_Ad_Transcript_Pkg.Get_FK_Igs_Ad_Code_Classes (
254: old_references.code_id
255: );
256:
257: Igs_Ad_Tst_Rslt_Dtls_Pkg.Get_FK_Igs_Ad_Code_Classes (
258: old_references.code_id
259: );
260:
261: Igs_Ad_Appqual_Code_Pkg.Get_FK_Igs_Ad_Code_Classes(

Line 261: Igs_Ad_Appqual_Code_Pkg.Get_FK_Igs_Ad_Code_Classes(

257: Igs_Ad_Tst_Rslt_Dtls_Pkg.Get_FK_Igs_Ad_Code_Classes (
258: old_references.code_id
259: );
260:
261: Igs_Ad_Appqual_Code_Pkg.Get_FK_Igs_Ad_Code_Classes(
262: old_references.code_id
263: );
264:
265: IF NVL(fnd_profile.value('IGS_RECRUITING_ENABLED'), 'N') = 'Y' THEN

Line 267: 'begin Igr_I_Appl_Pkg.Get_FK_Igs_Ad_Code_Classes (:1); end;'

263: );
264:
265: IF NVL(fnd_profile.value('IGS_RECRUITING_ENABLED'), 'N') = 'Y' THEN
266: EXECUTE IMMEDIATE
267: 'begin Igr_I_Appl_Pkg.Get_FK_Igs_Ad_Code_Classes (:1); end;'
268: USING old_references.code_id;
269: END IF;
270:
271: igs_ad_recruit_pi_pkg.get_fk_igs_ad_code_classes (

Line 271: igs_ad_recruit_pi_pkg.get_fk_igs_ad_code_classes (

267: 'begin Igr_I_Appl_Pkg.Get_FK_Igs_Ad_Code_Classes (:1); end;'
268: USING old_references.code_id;
269: END IF;
270:
271: igs_ad_recruit_pi_pkg.get_fk_igs_ad_code_classes (
272: old_references.code_id
273: );
274:
275: Igs_Ad_Appl_Pkg.Get_FK_Igs_Ad_Code_Classes (

Line 275: Igs_Ad_Appl_Pkg.Get_FK_Igs_Ad_Code_Classes (

271: igs_ad_recruit_pi_pkg.get_fk_igs_ad_code_classes (
272: old_references.code_id
273: );
274:
275: Igs_Ad_Appl_Pkg.Get_FK_Igs_Ad_Code_Classes (
276: old_references.code_id
277: );
278:
279:

Line 280: IGS_PE_HZ_PARTIES_PKG.Get_Fk_IGS_AD_CODE_CLASSES1(

276: old_references.code_id
277: );
278:
279:
280: IGS_PE_HZ_PARTIES_PKG.Get_Fk_IGS_AD_CODE_CLASSES1(
281: old_references.code_id
282: );
283:
284:

Line 285: IGS_UC_DEFAULTS_PKG.GET_FK_IGS_AD_CODE_CLASSES(

281: old_references.code_id
282: );
283:
284:
285: IGS_UC_DEFAULTS_PKG.GET_FK_IGS_AD_CODE_CLASSES(
286: old_references.code_id
287: );
288:
289: IGS_AD_PANEL_DTLS_PKG.GET_UFK_IGS_AD_CODE_CLASSES(

Line 289: IGS_AD_PANEL_DTLS_PKG.GET_UFK_IGS_AD_CODE_CLASSES(

285: IGS_UC_DEFAULTS_PKG.GET_FK_IGS_AD_CODE_CLASSES(
286: old_references.code_id
287: );
288:
289: IGS_AD_PANEL_DTLS_PKG.GET_UFK_IGS_AD_CODE_CLASSES(
290: old_references.name,
291: old_references.class
292: );
293:

Line 294: IGS_AD_PNMEMBR_DTLS_PKG.GET_UFK_IGS_AD_CODE_CLASSES(

290: old_references.name,
291: old_references.class
292: );
293:
294: IGS_AD_PNMEMBR_DTLS_PKG.GET_UFK_IGS_AD_CODE_CLASSES(
295: old_references.name,
296: old_references.class
297: );
298:

Line 299: IGS_AD_PNL_HIS_DTLS_PKG.GET_UFK_IGS_AD_CODE_CLASSES(

295: old_references.name,
296: old_references.class
297: );
298:
299: IGS_AD_PNL_HIS_DTLS_PKG.GET_UFK_IGS_AD_CODE_CLASSES(
300: old_references.name,
301: old_references.class
302: );
303:

Line 324: FROM igs_ad_code_classes

320: ***************************************************************/
321:
322: CURSOR cur_rowid IS
323: SELECT rowid
324: FROM igs_ad_code_classes
325: WHERE code_id = x_code_id AND
326: closed_ind = NVL(x_closed_ind,closed_ind);
327:
328: lv_rowid cur_rowid%RowType;

Line 364: FROM igs_ad_code_classes

360: l_class_type_code VARCHAR2(30);
361:
362: CURSOR cur_rowid(cp_class_type_code IN VARCHAR2) IS
363: SELECT rowid
364: FROM igs_ad_code_classes
365: WHERE name = x_name AND
366: class = x_class AND
367: class_type_code = cp_class_type_code AND
368: ((l_rowid is null) or (rowid <> l_rowid)) AND

Line 409: FROM igs_ad_code_classes

405: l_class_type_code VARCHAR2(30);
406:
407: CURSOR cur_rowid(cp_class_type_code IN VARCHAR2) IS
408: SELECT rowid
409: FROM igs_ad_code_classes
410: WHERE code_id = x_code_id AND
411: class = x_class AND
412: class_type_code = cp_class_type_code AND
413: ((l_rowid is null) or (rowid <> l_rowid)) AND

Line 579: cursor C is select ROWID from IGS_AD_CODE_CLASSES

575:
576: (reverse chronological order - newest change first)
577: ***************************************************************/
578:
579: cursor C is select ROWID from IGS_AD_CODE_CLASSES
580: where CODE_ID= X_CODE_ID
581: ;
582: X_LAST_UPDATE_DATE DATE ;
583: X_LAST_UPDATED_BY NUMBER ;

Line 622: insert into IGS_AD_CODE_CLASSES (

618: x_created_by=>X_LAST_UPDATED_BY,
619: x_last_update_date=>X_LAST_UPDATE_DATE,
620: x_last_updated_by=>X_LAST_UPDATED_BY,
621: x_last_update_login=>X_LAST_UPDATE_LOGIN);
622: insert into IGS_AD_CODE_CLASSES (
623: CODE_ID
624: ,NAME
625: ,DESCRIPTION
626: ,CLASS

Line 637: IGS_AD_CODE_CLASSES_S.NEXTVAL

633: ,LAST_UPDATED_BY
634: ,LAST_UPDATE_LOGIN
635: ,class_type_code
636: ) values (
637: IGS_AD_CODE_CLASSES_S.NEXTVAL
638: ,NEW_REFERENCES.NAME
639: ,NEW_REFERENCES.DESCRIPTION
640: ,NEW_REFERENCES.CLASS
641: ,NEW_REFERENCES.CLOSED_IND

Line 692: from IGS_AD_CODE_CLASSES

688: , CLOSED_IND
689: , SYSTEM_STATUS
690: , SYSTEM_DEFAULT
691: , class_type_code
692: from IGS_AD_CODE_CLASSES
693: where ROWID = X_ROWID
694: for update nowait;
695: tlinfo c1%rowtype;
696: begin

Line 790: update IGS_AD_CODE_CLASSES set

786: x_created_by=>X_LAST_UPDATED_BY,
787: x_last_update_date=>X_LAST_UPDATE_DATE,
788: x_last_updated_by=>X_LAST_UPDATED_BY,
789: x_last_update_login=>X_LAST_UPDATE_LOGIN);
790: update IGS_AD_CODE_CLASSES set
791: NAME = NEW_REFERENCES.NAME,
792: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
793: CLASS = NEW_REFERENCES.CLASS,
794: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 834: cursor c1 is select ROWID from IGS_AD_CODE_CLASSES

830:
831: (reverse chronological order - newest change first)
832: ***************************************************************/
833:
834: cursor c1 is select ROWID from IGS_AD_CODE_CLASSES
835: where CODE_ID= X_CODE_ID
836: ;
837: begin
838: open c1;

Line 887: delete from IGS_AD_CODE_CLASSES

883: Before_DML (
884: p_action => 'DELETE',
885: x_rowid => X_ROWID
886: );
887: delete from IGS_AD_CODE_CLASSES
888: where ROWID = X_ROWID;
889: if (sql%notfound) then
890: raise no_data_found;
891: end if;

Line 897: END igs_ad_code_classes_pkg;

893: p_action => 'DELETE',
894: x_rowid => X_ROWID
895: );
896: end DELETE_ROW;
897: END igs_ad_code_classes_pkg;