DBA Data[Home] [Help]

APPS.IGS_RE_CDT_ATT_HIST_PKG dependencies on IGS_SC_GEN_001

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

469: x_org_id => igs_ge_gen_003.get_org_id
470: );
471:
472: IF (x_mode = 'S') THEN
473: igs_sc_gen_001.set_ctx('R');
474: END IF;
475: insert into IGS_RE_CDT_ATT_HIST_ALL (
476: PERSON_ID,
477: CA_SEQUENCE_NUMBER,

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

501: X_LAST_UPDATE_LOGIN,
502: NEW_REFERENCES.ORG_ID
503: );
504: IF (x_mode = 'S') THEN
505: igs_sc_gen_001.unset_ctx('R');
506: END IF;
507:
508:
509: open c;

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

519: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
520: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
521: fnd_message.set_token ('ERR_CD', SQLCODE);
522: igs_ge_msg_stack.add;
523: igs_sc_gen_001.unset_ctx('R');
524: app_exception.raise_exception;
525: ELSE
526: igs_sc_gen_001.unset_ctx('R');
527: RAISE;

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

522: igs_ge_msg_stack.add;
523: igs_sc_gen_001.unset_ctx('R');
524: app_exception.raise_exception;
525: ELSE
526: igs_sc_gen_001.unset_ctx('R');
527: RAISE;
528: END IF;
529:
530: end INSERT_ROW;

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

624: x_last_update_login => X_LAST_UPDATE_LOGIN
625: );
626:
627: IF (x_mode = 'S') THEN
628: igs_sc_gen_001.set_ctx('R');
629: END IF;
630: update IGS_RE_CDT_ATT_HIST_ALL set
631: HIST_START_DT = NEW_REFERENCES.HIST_START_DT,
632: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,

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

639:
640: if (sql%notfound) then
641: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
642: igs_ge_msg_stack.add;
643: igs_sc_gen_001.unset_ctx('R');
644: app_exception.raise_exception;
645: end if;
646: IF (x_mode = 'S') THEN
647: igs_sc_gen_001.unset_ctx('R');

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

643: igs_sc_gen_001.unset_ctx('R');
644: app_exception.raise_exception;
645: end if;
646: IF (x_mode = 'S') THEN
647: igs_sc_gen_001.unset_ctx('R');
648: END IF;
649:
650:
651:

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

654: IF (SQLCODE = (-28115)) THEN
655: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
656: fnd_message.set_token ('ERR_CD', SQLCODE);
657: igs_ge_msg_stack.add;
658: igs_sc_gen_001.unset_ctx('R');
659: app_exception.raise_exception;
660: ELSE
661: igs_sc_gen_001.unset_ctx('R');
662: RAISE;

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

657: igs_ge_msg_stack.add;
658: igs_sc_gen_001.unset_ctx('R');
659: app_exception.raise_exception;
660: ELSE
661: igs_sc_gen_001.unset_ctx('R');
662: RAISE;
663: END IF;
664:
665: end UPDATE_ROW;

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

722: x_rowid => X_ROWID
723: );
724:
725: IF (x_mode = 'S') THEN
726: igs_sc_gen_001.set_ctx('R');
727: END IF;
728: delete from IGS_RE_CDT_ATT_HIST_ALL
729: where ROWID = X_ROWID;
730: if (sql%notfound) then

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

729: where ROWID = X_ROWID;
730: if (sql%notfound) then
731: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
732: igs_ge_msg_stack.add;
733: igs_sc_gen_001.unset_ctx('R');
734: app_exception.raise_exception;
735: end if;
736: IF (x_mode = 'S') THEN
737: igs_sc_gen_001.unset_ctx('R');

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

733: igs_sc_gen_001.unset_ctx('R');
734: app_exception.raise_exception;
735: end if;
736: IF (x_mode = 'S') THEN
737: igs_sc_gen_001.unset_ctx('R');
738: END IF;
739:
740:
741: end DELETE_ROW;