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_PNMEMBR_DTLS_PKG dependencies on IGS_AD_PNMEMBR_DTLS

Line 1: PACKAGE BODY igs_ad_pnmembr_dtls_pkg AS

1: PACKAGE BODY igs_ad_pnmembr_dtls_pkg AS
2: /* $Header: IGSAIH2B.pls 120.4 2006/01/29 22:29:30 pfotedar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_pnmembr_dtls%ROWTYPE;

Line 5: old_references igs_ad_pnmembr_dtls%ROWTYPE;

1: PACKAGE BODY igs_ad_pnmembr_dtls_pkg AS
2: /* $Header: IGSAIH2B.pls 120.4 2006/01/29 22:29:30 pfotedar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_pnmembr_dtls%ROWTYPE;
6: new_references igs_ad_pnmembr_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_pnmembr_dtls%ROWTYPE;

2: /* $Header: IGSAIH2B.pls 120.4 2006/01/29 22:29:30 pfotedar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_pnmembr_dtls%ROWTYPE;
6: new_references igs_ad_pnmembr_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 60: FROM igs_ad_pnmembr_dtls

56: */
57:
58: CURSOR cur_old_ref_values IS
59: SELECT *
60: FROM igs_ad_pnmembr_dtls
61: WHERE rowid = x_rowid;
62:
63: BEGIN
64:

Line 220: igs_ad_pnmembr_nots_pkg.get_fk_igs_ad_pnmembr_dtls (

216: || Who When What
217: || (reverse chronological order - newest change first)
218: */
219: BEGIN
220: igs_ad_pnmembr_nots_pkg.get_fk_igs_ad_pnmembr_dtls (
221: old_references.panel_dtls_id,
222: old_references.member_person_id
223: );
224: END check_child_existance;

Line 242: FROM igs_ad_pnmembr_dtls

238: || (reverse chronological order - newest change first)
239: */
240: CURSOR cur_rowid IS
241: SELECT rowid
242: FROM igs_ad_pnmembr_dtls
243: WHERE panel_dtls_id = x_panel_dtls_id
244: AND member_person_id = x_member_person_id
245: FOR UPDATE NOWAIT;
246:

Line 278: FROM igs_ad_pnmembr_dtls

274: || (reverse chronological order - newest change first)
275: */
276: CURSOR cur_rowid IS
277: SELECT rowid
278: FROM igs_ad_pnmembr_dtls
279: WHERE ((panel_dtls_id = x_panel_dtls_id));
280:
281: lv_rowid cur_rowid%RowType;
282:

Line 314: FROM igs_ad_pnmembr_dtls

310: || (reverse chronological order - newest change first)
311: */
312: CURSOR cur_rowid IS
313: SELECT rowid
314: FROM igs_ad_pnmembr_dtls
315: WHERE ((member_decision_code = x_name) AND
316: (member_decision_type = x_class));
317:
318: lv_rowid cur_rowid%RowType;

Line 350: FROM igs_ad_pnmembr_dtls

346: || (reverse chronological order - newest change first)
347: */
348: CURSOR cur_rowid IS
349: SELECT rowid
350: FROM igs_ad_pnmembr_dtls
351: WHERE ((location_cd = x_location_cd));
352:
353: lv_rowid cur_rowid%RowType;
354:

Line 385: FROM igs_ad_pnmembr_dtls

381: || (reverse chronological order - newest change first)
382: */
383: CURSOR cur_rowid IS
384: SELECT rowid
385: FROM igs_ad_pnmembr_dtls
386: WHERE ((room_id = x_room_id));
387:
388: lv_rowid cur_rowid%RowType;
389:

Line 472: igs_Ad_pnmembr_Dtls pmbr

468:
469: CURSOR c_instance_dets IS
470: SELECT person_id,admission_appl_number,nominated_course_Cd,sequence_number
471: FROM igs_ad_panel_dtls pdtls,
472: igs_Ad_pnmembr_Dtls pmbr
473: WHERE pdtls.panel_Dtls_id = pmbr.panel_dtls_id
474: AND pmbr.panel_dtls_id = NVL(old_references.panel_dtls_id, new_references.panel_dtls_id);
475:
476: instance_dets_rec c_instance_dets%ROWTYPE;

Line 909: fnd_message.set_token ('ROUTINE', 'IGS_AD_PNMEMBR_DTLS_PKG.INSERT_ROW');

905: x_last_update_login := -1;
906: END IF;
907: ELSE
908: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
909: fnd_message.set_token ('ROUTINE', 'IGS_AD_PNMEMBR_DTLS_PKG.INSERT_ROW');
910: igs_ge_msg_stack.add;
911: app_exception.raise_exception;
912: END IF;
913:

Line 958: INSERT INTO igs_ad_pnmembr_dtls (

954:
955: IF (x_mode = 'S') THEN
956: igs_sc_gen_001.set_ctx('R');
957: END IF;
958: INSERT INTO igs_ad_pnmembr_dtls (
959: panel_dtls_id,
960: role_type_code,
961: member_person_id,
962: interview_date,

Line 1133: FROM igs_ad_pnmembr_dtls

1129: attribute17,
1130: attribute18,
1131: attribute19,
1132: attribute20
1133: FROM igs_ad_pnmembr_dtls
1134: WHERE rowid = x_rowid
1135: FOR UPDATE NOWAIT;
1136:
1137: tlinfo c1%ROWTYPE;

Line 1261: fnd_message.set_token ('ROUTINE', 'IGS_AD_PNMEMBR_DTLS_PKG.UPDATE_ROW');

1257: x_last_update_login := -1;
1258: END IF;
1259: ELSE
1260: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1261: fnd_message.set_token ('ROUTINE', 'IGS_AD_PNMEMBR_DTLS_PKG.UPDATE_ROW');
1262: igs_ge_msg_stack.add;
1263: app_exception.raise_exception;
1264: END IF;
1265:

Line 1310: UPDATE igs_ad_pnmembr_dtls

1306:
1307: IF (x_mode = 'S') THEN
1308: igs_sc_gen_001.set_ctx('R');
1309: END IF;
1310: UPDATE igs_ad_pnmembr_dtls
1311: SET
1312: role_type_code = new_references.role_type_code,
1313: interview_date = new_references.interview_date,
1314: interview_time = new_references.interview_time,

Line 1426: FROM igs_ad_pnmembr_dtls

1422: || (reverse chronological order - newest change first)
1423: */
1424: CURSOR c1 IS
1425: SELECT rowid
1426: FROM igs_ad_pnmembr_dtls
1427: WHERE panel_dtls_id = x_panel_dtls_id
1428: AND member_person_id = x_member_person_id;
1429: l_mode VARCHAR2(1);
1430: BEGIN

Line 1539: DELETE FROM igs_ad_pnmembr_dtls

1535:
1536: IF (x_mode = 'S') THEN
1537: igs_sc_gen_001.set_ctx('R');
1538: END IF;
1539: DELETE FROM igs_ad_pnmembr_dtls
1540: WHERE rowid = x_rowid;
1541:
1542: IF (SQL%NOTFOUND) THEN
1543: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 1576: END igs_ad_pnmembr_dtls_pkg;

1572: END IF;
1573: END delete_row;
1574:
1575:
1576: END igs_ad_pnmembr_dtls_pkg;