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_PANEL_DTLS_PKG dependencies on IGS_AD_PANEL_DTLS

Line 1: PACKAGE BODY igs_ad_panel_dtls_pkg AS

1: PACKAGE BODY igs_ad_panel_dtls_pkg AS
2: /* $Header: IGSAIH1B.pls 120.2 2005/09/30 05:33:22 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_panel_dtls%ROWTYPE;

Line 5: old_references igs_ad_panel_dtls%ROWTYPE;

1: PACKAGE BODY igs_ad_panel_dtls_pkg AS
2: /* $Header: IGSAIH1B.pls 120.2 2005/09/30 05:33:22 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_panel_dtls%ROWTYPE;
6: new_references igs_ad_panel_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_panel_dtls%ROWTYPE;

2: /* $Header: IGSAIH1B.pls 120.2 2005/09/30 05:33:22 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_panel_dtls%ROWTYPE;
6: new_references igs_ad_panel_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 64: FROM igs_ad_panel_dtls

60: */
61:
62: CURSOR cur_old_ref_values IS
63: SELECT *
64: FROM igs_ad_panel_dtls
65: WHERE rowid = x_rowid;
66:
67: BEGIN
68:

Line 279: igs_ad_pnl_his_dtls_pkg.get_fk_igs_ad_panel_dtls (

275: || (reverse chronological order - newest change first)
276: */
277: BEGIN
278:
279: igs_ad_pnl_his_dtls_pkg.get_fk_igs_ad_panel_dtls (
280: old_references.panel_dtls_id
281: );
282:
283: igs_ad_pnmembr_dtls_pkg.get_fk_igs_ad_panel_dtls (

Line 283: igs_ad_pnmembr_dtls_pkg.get_fk_igs_ad_panel_dtls (

279: igs_ad_pnl_his_dtls_pkg.get_fk_igs_ad_panel_dtls (
280: old_references.panel_dtls_id
281: );
282:
283: igs_ad_pnmembr_dtls_pkg.get_fk_igs_ad_panel_dtls (
284: old_references.panel_dtls_id
285: );
286:
287: END check_child_existance;

Line 304: FROM igs_ad_panel_dtls

300: || (reverse chronological order - newest change first)
301: */
302: CURSOR cur_rowid IS
303: SELECT rowid
304: FROM igs_ad_panel_dtls
305: WHERE panel_dtls_id = x_panel_dtls_id
306: FOR UPDATE NOWAIT;
307:
308: lv_rowid cur_rowid%RowType;

Line 343: FROM igs_ad_panel_dtls

339: || (reverse chronological order - newest change first)
340: */
341: CURSOR cur_rowid IS
342: SELECT rowid
343: FROM igs_ad_panel_dtls
344: WHERE person_id = x_person_id
345: AND admission_appl_number = x_admission_appl_number
346: AND nominated_course_cd = x_nominated_course_cd
347: AND sequence_number = x_sequence_number

Line 382: FROM igs_ad_panel_dtls

378: || (reverse chronological order - newest change first)
379: */
380: CURSOR cur_rowid IS
381: SELECT rowid
382: FROM igs_ad_panel_dtls
383: WHERE ((panel_code = x_panel_code));
384:
385: lv_rowid cur_rowid%RowType;
386:

Line 417: FROM igs_ad_panel_dtls

413: || (reverse chronological order - newest change first)
414: */
415: CURSOR cur_rowid IS
416: SELECT rowid
417: FROM igs_ad_panel_dtls
418: WHERE ((location_cd = x_location_cd));
419:
420: lv_rowid cur_rowid%RowType;
421:

Line 452: FROM igs_ad_panel_dtls

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

Line 488: FROM igs_ad_panel_dtls

484: || (reverse chronological order - newest change first)
485: */
486: CURSOR cur_rowid IS
487: SELECT rowid
488: FROM igs_ad_panel_dtls
489: WHERE ((final_decision_code = x_name) AND
490: (final_decision_type = x_class));
491:
492: lv_rowid cur_rowid%RowType;

Line 593: FROM igs_ad_panel_dtls

589:
590: -- Cursor to Check closed flag associated to panel code.
591: CURSOR c_chk_final_decision IS
592: SELECT *
593: FROM igs_ad_panel_dtls
594: WHERE panel_dtls_id = NVL(old_references.panel_dtls_id, new_references.panel_dtls_id);
595:
596: rec_chk_final_decision c_chk_final_decision%ROWTYPE;
597:

Line 601: igs_ad_panel_dtls pdtls,

597:
598: CURSOR c_final_decison IS
599: SELECT 'X'
600: FROM
601: igs_ad_panel_dtls pdtls,
602: igs_Ad_code_classes cdcls
603: WHERE person_id = new_references.person_id
604: AND admission_appl_number = new_references.admission_Appl_number
605: AND nominated_course_cd = new_references.nominated_course_Cd

Line 632: FROM igs_ad_intvw_pnls pnls, igs_ad_panel_dtls pdtls

628: l_final_decison_rec c_final_decison%ROWTYPE;
629:
630: CURSOR c_intvw_pnl_exsts IS
631: SELECT 'X'
632: FROM igs_ad_intvw_pnls pnls, igs_ad_panel_dtls pdtls
633: WHERE pnls.panel_type_code='INTERVIEW'
634: AND pnls.panel_code = pdtls.panel_code
635: AND pdtls.person_id = NVL(old_references.person_id, new_references.person_id)
636: AND pdtls.admission_appl_number = NVL(old_references.admission_appl_number, new_references.admission_appl_number)

Line 646: igs_ad_panel_dtls pdtls

642: -- Check any member exists for this panel instance.
643: CURSOR c_memb_exsts IS
644: SELECT mbrdtls.member_person_id
645: FROM igs_ad_pnmembr_dtls mbrdtls,
646: igs_ad_panel_dtls pdtls
647: WHERE mbrdtls.panel_dtls_id = pdtls.panel_dtls_id
648: AND pdtls.panel_dtls_id = new_references.panel_dtls_id;
649:
650: memb_exsts_rec c_memb_exsts%ROWTYPE;

Line 1308: fnd_message.set_token ('ROUTINE', 'IGS_AD_PANEL_DTLS_PKG.INSERT_ROW');

1304: x_last_update_login := -1;
1305: END IF;
1306: ELSE
1307: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1308: fnd_message.set_token ('ROUTINE', 'IGS_AD_PANEL_DTLS_PKG.INSERT_ROW');
1309: igs_ge_msg_stack.add;
1310: app_exception.raise_exception;
1311: END IF;
1312:

Line 1363: INSERT INTO igs_ad_panel_dtls (

1359:
1360: IF (x_mode = 'S') THEN
1361: igs_sc_gen_001.set_ctx('R');
1362: END IF;
1363: INSERT INTO igs_ad_panel_dtls (
1364: panel_dtls_id,
1365: person_id,
1366: admission_appl_number,
1367: nominated_course_cd,

Line 1405: igs_ad_panel_dtls_s.NEXTVAL,

1401: last_update_date,
1402: last_updated_by,
1403: last_update_login
1404: ) VALUES (
1405: igs_ad_panel_dtls_s.NEXTVAL,
1406: new_references.person_id,
1407: new_references.admission_appl_number,
1408: new_references.nominated_course_cd,
1409: new_references.sequence_number,

Line 1557: FROM igs_ad_panel_dtls

1553: attribute17,
1554: attribute18,
1555: attribute19,
1556: attribute20
1557: FROM igs_ad_panel_dtls
1558: WHERE rowid = x_rowid
1559: FOR UPDATE NOWAIT;
1560:
1561: tlinfo c1%ROWTYPE;

Line 1695: fnd_message.set_token ('ROUTINE', 'IGS_AD_PANEL_DTLS_PKG.UPDATE_ROW');

1691: x_last_update_login := -1;
1692: END IF;
1693: ELSE
1694: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1695: fnd_message.set_token ('ROUTINE', 'IGS_AD_PANEL_DTLS_PKG.UPDATE_ROW');
1696: igs_ge_msg_stack.add;
1697: app_exception.raise_exception;
1698: END IF;
1699:

Line 1748: UPDATE igs_ad_panel_dtls

1744:
1745: IF (x_mode = 'S') THEN
1746: igs_sc_gen_001.set_ctx('R');
1747: END IF;
1748: UPDATE igs_ad_panel_dtls
1749: SET
1750: person_id = new_references.person_id,
1751: admission_appl_number = new_references.admission_appl_number,
1752: nominated_course_cd = new_references.nominated_course_cd,

Line 1875: FROM igs_ad_panel_dtls

1871: || (reverse chronological order - newest change first)
1872: */
1873: CURSOR c1 IS
1874: SELECT rowid
1875: FROM igs_ad_panel_dtls
1876: WHERE panel_dtls_id = x_panel_dtls_id;
1877: l_mode VARCHAR2(1);
1878: BEGIN
1879: l_mode := NVL(x_mode, 'R');

Line 1995: DELETE FROM igs_ad_panel_dtls

1991:
1992: IF (x_mode = 'S') THEN
1993: igs_sc_gen_001.set_ctx('R');
1994: END IF;
1995: DELETE FROM igs_ad_panel_dtls
1996: WHERE rowid = x_rowid;
1997:
1998: IF (SQL%NOTFOUND) THEN
1999: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 2032: END igs_ad_panel_dtls_pkg;

2028: END IF;
2029: END delete_row;
2030:
2031:
2032: END igs_ad_panel_dtls_pkg;