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_HE_ST_SPA_CC_PKG dependencies on IGS_SC_GEN_001

Line 325: igs_sc_gen_001.set_ctx('R');

321: x_last_update_login => x_last_update_login
322: );
323:
324: IF (x_mode = 'S') THEN
325: igs_sc_gen_001.set_ctx('R');
326: END IF;
327: INSERT INTO igs_he_st_spa_cc (
328: he_spa_cc_id,
329: person_id,

Line 353: igs_sc_gen_001.unset_ctx('R');

349: x_last_updated_by,
350: x_last_update_login
351: ) RETURNING ROWID, he_spa_cc_id INTO x_rowid, x_he_spa_cc_id;
352: IF (x_mode = 'S') THEN
353: igs_sc_gen_001.unset_ctx('R');
354: END IF;
355:
356:
357: l_rowid := NULL;

Line 366: igs_sc_gen_001.unset_ctx('R');

362: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
363: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
364: fnd_message.set_token ('ERR_CD', SQLCODE);
365: igs_ge_msg_stack.add;
366: igs_sc_gen_001.unset_ctx('R');
367: app_exception.raise_exception;
368: ELSE
369: igs_sc_gen_001.unset_ctx('R');
370: RAISE;

Line 369: igs_sc_gen_001.unset_ctx('R');

365: igs_ge_msg_stack.add;
366: igs_sc_gen_001.unset_ctx('R');
367: app_exception.raise_exception;
368: ELSE
369: igs_sc_gen_001.unset_ctx('R');
370: RAISE;
371: END IF;
372: END insert_row;
373:

Line 500: igs_sc_gen_001.set_ctx('R');

496: x_last_update_login => x_last_update_login
497: );
498:
499: IF (x_mode = 'S') THEN
500: igs_sc_gen_001.set_ctx('R');
501: END IF;
502: UPDATE igs_he_st_spa_cc
503: SET
504: person_id = new_references.person_id,

Line 517: igs_sc_gen_001.unset_ctx('R');

513:
514: IF (SQL%NOTFOUND) THEN
515: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
516: igs_ge_msg_stack.add;
517: igs_sc_gen_001.unset_ctx('R');
518: app_exception.raise_exception;
519: END IF;
520: IF (x_mode = 'S') THEN
521: igs_sc_gen_001.unset_ctx('R');

Line 521: igs_sc_gen_001.unset_ctx('R');

517: igs_sc_gen_001.unset_ctx('R');
518: app_exception.raise_exception;
519: END IF;
520: IF (x_mode = 'S') THEN
521: igs_sc_gen_001.unset_ctx('R');
522: END IF;
523:
524:
525: l_rowid := NULL;

Line 533: igs_sc_gen_001.unset_ctx('R');

529: IF (SQLCODE = (-28115)) THEN
530: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
531: fnd_message.set_token ('ERR_CD', SQLCODE);
532: igs_ge_msg_stack.add;
533: igs_sc_gen_001.unset_ctx('R');
534: app_exception.raise_exception;
535: ELSE
536: igs_sc_gen_001.unset_ctx('R');
537: RAISE;

Line 536: igs_sc_gen_001.unset_ctx('R');

532: igs_ge_msg_stack.add;
533: igs_sc_gen_001.unset_ctx('R');
534: app_exception.raise_exception;
535: ELSE
536: igs_sc_gen_001.unset_ctx('R');
537: RAISE;
538: END IF;
539:
540: END update_row;

Line 623: igs_sc_gen_001.set_ctx('R');

619: x_rowid => x_rowid
620: );
621:
622: IF (x_mode = 'S') THEN
623: igs_sc_gen_001.set_ctx('R');
624: END IF;
625: DELETE FROM igs_he_st_spa_cc
626: WHERE rowid = x_rowid;
627:

Line 631: igs_sc_gen_001.unset_ctx('R');

627:
628: IF (SQL%NOTFOUND) THEN
629: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
630: igs_ge_msg_stack.add;
631: igs_sc_gen_001.unset_ctx('R');
632: app_exception.raise_exception;
633: END IF;
634: IF (x_mode = 'S') THEN
635: igs_sc_gen_001.unset_ctx('R');

Line 635: igs_sc_gen_001.unset_ctx('R');

631: igs_sc_gen_001.unset_ctx('R');
632: app_exception.raise_exception;
633: END IF;
634: IF (x_mode = 'S') THEN
635: igs_sc_gen_001.unset_ctx('R');
636: END IF;
637:
638:
639: l_rowid := NULL;