APPS.IGS_PE_IMMU_DTLS_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_immu_dtls (
561: immu_details_id,
562: person_id,

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

624: x_last_updated_by,
625: x_last_update_login
626: );
627: IF (x_mode = 'S') THEN
628: igs_sc_gen_001.unset_ctx('R');
629: END IF;
630:
631:
632: OPEN c;

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

643: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
644: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
645: fnd_message.set_token ('ERR_CD', SQLCODE);
646: igs_ge_msg_stack.add;
647: igs_sc_gen_001.unset_ctx('R');
648: app_exception.raise_exception;
649: ELSE
650: igs_sc_gen_001.unset_ctx('R');
651: RAISE;

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

646: igs_ge_msg_stack.add;
647: igs_sc_gen_001.unset_ctx('R');
648: app_exception.raise_exception;
649: ELSE
650: igs_sc_gen_001.unset_ctx('R');
651: RAISE;
652: END IF;
653: END insert_row;
654:

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

923: x_last_update_login => x_last_update_login
924: );
925:
926: IF (x_mode = 'S') THEN
927: igs_sc_gen_001.set_ctx('R');
928: END IF;
929: UPDATE igs_pe_immu_dtls
930: SET
931: person_id = new_references.person_id,

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

961:
962: IF (SQL%NOTFOUND) THEN
963: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
964: igs_ge_msg_stack.add;
965: igs_sc_gen_001.unset_ctx('R');
966: app_exception.raise_exception;
967: END IF;
968: IF (x_mode = 'S') THEN
969: igs_sc_gen_001.unset_ctx('R');

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

965: igs_sc_gen_001.unset_ctx('R');
966: app_exception.raise_exception;
967: END IF;
968: IF (x_mode = 'S') THEN
969: igs_sc_gen_001.unset_ctx('R');
970: END IF;
971:
972:
973:

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

976: IF (SQLCODE = (-28115)) THEN
977: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
978: fnd_message.set_token ('ERR_CD', SQLCODE);
979: igs_ge_msg_stack.add;
980: igs_sc_gen_001.unset_ctx('R');
981: app_exception.raise_exception;
982: ELSE
983: igs_sc_gen_001.unset_ctx('R');
984: RAISE;

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

979: igs_ge_msg_stack.add;
980: igs_sc_gen_001.unset_ctx('R');
981: app_exception.raise_exception;
982: ELSE
983: igs_sc_gen_001.unset_ctx('R');
984: RAISE;
985: END IF;
986: END update_row;
987:

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

1128: x_rowid => x_rowid
1129: );
1130:
1131: IF (x_mode = 'S') THEN
1132: igs_sc_gen_001.set_ctx('R');
1133: END IF;
1134: DELETE FROM igs_pe_immu_dtls
1135: WHERE rowid = x_rowid;
1136:

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

1136:
1137: IF (SQL%NOTFOUND) THEN
1138: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1139: igs_ge_msg_stack.add;
1140: igs_sc_gen_001.unset_ctx('R');
1141: app_exception.raise_exception;
1142: END IF;
1143: IF (x_mode = 'S') THEN
1144: igs_sc_gen_001.unset_ctx('R');

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

1140: igs_sc_gen_001.unset_ctx('R');
1141: app_exception.raise_exception;
1142: END IF;
1143: IF (x_mode = 'S') THEN
1144: igs_sc_gen_001.unset_ctx('R');
1145: END IF;
1146:
1147:
1148: END delete_row;