DBA Data[Home] [Help]

APPS.IGS_UC_QUAL_DETS_PKG dependencies on IGS_SC_GEN_001

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

695: x_last_update_login => x_last_update_login
696: );
697:
698: IF (x_mode = 'S') THEN
699: igs_sc_gen_001.set_ctx('R');
700: END IF;
701: INSERT INTO igs_uc_qual_dets (
702: qual_dets_id,
703: person_id,

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

741: x_last_updated_by,
742: x_last_update_login
743: );
744: IF (x_mode = 'S') THEN
745: igs_sc_gen_001.unset_ctx('R');
746: END IF;
747:
748:
749: OPEN c;

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

760: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
761: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
762: fnd_message.set_token ('ERR_CD', SQLCODE);
763: igs_ge_msg_stack.add;
764: igs_sc_gen_001.unset_ctx('R');
765: app_exception.raise_exception;
766: ELSE
767: igs_sc_gen_001.unset_ctx('R');
768: RAISE;

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

763: igs_ge_msg_stack.add;
764: igs_sc_gen_001.unset_ctx('R');
765: app_exception.raise_exception;
766: ELSE
767: igs_sc_gen_001.unset_ctx('R');
768: RAISE;
769: END IF;
770: END insert_row;
771:

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

938: x_last_update_login => x_last_update_login
939: );
940:
941: IF (x_mode = 'S') THEN
942: igs_sc_gen_001.set_ctx('R');
943: END IF;
944: UPDATE igs_uc_qual_dets
945: SET
946: person_id = new_references.person_id,

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

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

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

968: igs_sc_gen_001.unset_ctx('R');
969: app_exception.raise_exception;
970: END IF;
971: IF (x_mode = 'S') THEN
972: igs_sc_gen_001.unset_ctx('R');
973: END IF;
974:
975: EXCEPTION
976: WHEN OTHERS THEN

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

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

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

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

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

1094: x_rowid => x_rowid
1095: );
1096:
1097: IF (x_mode = 'S') THEN
1098: igs_sc_gen_001.set_ctx('R');
1099: END IF;
1100: DELETE FROM igs_uc_qual_dets
1101: WHERE rowid = x_rowid;
1102:

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

1102:
1103: IF (SQL%NOTFOUND) THEN
1104: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1105: igs_ge_msg_stack.add;
1106: igs_sc_gen_001.unset_ctx('R');
1107: app_exception.raise_exception;
1108: END IF;
1109: IF (x_mode = 'S') THEN
1110: igs_sc_gen_001.unset_ctx('R');

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

1106: igs_sc_gen_001.unset_ctx('R');
1107: app_exception.raise_exception;
1108: END IF;
1109: IF (x_mode = 'S') THEN
1110: igs_sc_gen_001.unset_ctx('R');
1111: END IF;
1112:
1113:
1114: END delete_row;