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

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

554: x_last_update_login => x_last_update_login
555: );
556:
557: IF (x_mode = 'S') THEN
558: igs_sc_gen_001.set_ctx('R');
559: END IF;
560: INSERT INTO igs_pe_passport (
561: passport_id,
562: person_id,

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

622: x_last_updated_by,
623: x_last_update_login
624: ) RETURNING ROWID, passport_id INTO x_rowid, x_passport_id;
625: IF (x_mode = 'S') THEN
626: igs_sc_gen_001.unset_ctx('R');
627: END IF;
628:
629:
630:

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

633: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
634: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
635: fnd_message.set_token ('ERR_CD', SQLCODE);
636: igs_ge_msg_stack.add;
637: igs_sc_gen_001.unset_ctx('R');
638: app_exception.raise_exception;
639: ELSE
640: igs_sc_gen_001.unset_ctx('R');
641: RAISE;

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

636: igs_ge_msg_stack.add;
637: igs_sc_gen_001.unset_ctx('R');
638: app_exception.raise_exception;
639: ELSE
640: igs_sc_gen_001.unset_ctx('R');
641: RAISE;
642: END IF;
643: END insert_row;
644:

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

866: x_last_update_login => x_last_update_login
867: );
868:
869: IF (x_mode = 'S') THEN
870: igs_sc_gen_001.set_ctx('R');
871: END IF;
872: UPDATE igs_pe_passport
873: SET
874: person_id = new_references.person_id,

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

903:
904: IF (SQL%NOTFOUND) THEN
905: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
906: igs_ge_msg_stack.add;
907: igs_sc_gen_001.unset_ctx('R');
908: app_exception.raise_exception;
909: END IF;
910: IF (x_mode = 'S') THEN
911: igs_sc_gen_001.unset_ctx('R');

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

907: igs_sc_gen_001.unset_ctx('R');
908: app_exception.raise_exception;
909: END IF;
910: IF (x_mode = 'S') THEN
911: igs_sc_gen_001.unset_ctx('R');
912: END IF;
913:
914: EXCEPTION
915: WHEN OTHERS THEN

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

916: IF (SQLCODE = (-28115)) THEN
917: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
918: fnd_message.set_token ('ERR_CD', SQLCODE);
919: igs_ge_msg_stack.add;
920: igs_sc_gen_001.unset_ctx('R');
921: app_exception.raise_exception;
922: ELSE
923: igs_sc_gen_001.unset_ctx('R');
924: RAISE;

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

919: igs_ge_msg_stack.add;
920: igs_sc_gen_001.unset_ctx('R');
921: app_exception.raise_exception;
922: ELSE
923: igs_sc_gen_001.unset_ctx('R');
924: RAISE;
925: END IF;
926:
927: END update_row;

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

1066: x_rowid => x_rowid
1067: );
1068:
1069: IF (x_mode = 'S') THEN
1070: igs_sc_gen_001.set_ctx('R');
1071: END IF;
1072: DELETE FROM igs_pe_passport
1073: WHERE rowid = x_rowid;
1074:

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

1074:
1075: IF (SQL%NOTFOUND) THEN
1076: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1077: igs_ge_msg_stack.add;
1078: igs_sc_gen_001.unset_ctx('R');
1079: app_exception.raise_exception;
1080: END IF;
1081: IF (x_mode = 'S') THEN
1082: igs_sc_gen_001.unset_ctx('R');

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

1078: igs_sc_gen_001.unset_ctx('R');
1079: app_exception.raise_exception;
1080: END IF;
1081: IF (x_mode = 'S') THEN
1082: igs_sc_gen_001.unset_ctx('R');
1083: END IF;
1084:
1085:
1086: END delete_row;