APPS.IGS_PE_PERS_NOTE_PKG dependencies on IGS_SC_GEN_001

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

377: x_last_update_login=>X_LAST_UPDATE_LOGIN
378: );
379:
380: IF (x_mode = 'S') THEN
381: igs_sc_gen_001.set_ctx('R');
382: END IF;
383: insert into IGS_PE_PERS_NOTE (
384: PERSON_ID,
385: REFERENCE_NUMBER,

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

403: X_LAST_UPDATED_BY,
404: X_LAST_UPDATE_LOGIN
405: );
406: IF (x_mode = 'S') THEN
407: igs_sc_gen_001.unset_ctx('R');
408: END IF;
409:
410:
411: open c;

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

426: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
427: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
428: fnd_message.set_token ('ERR_CD', SQLCODE);
429: igs_ge_msg_stack.add;
430: igs_sc_gen_001.unset_ctx('R');
431: app_exception.raise_exception;
432: ELSE
433: igs_sc_gen_001.unset_ctx('R');
434: RAISE;

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

429: igs_ge_msg_stack.add;
430: igs_sc_gen_001.unset_ctx('R');
431: app_exception.raise_exception;
432: ELSE
433: igs_sc_gen_001.unset_ctx('R');
434: RAISE;
435: END IF;
436:
437: end INSERT_ROW;

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

523: x_last_updated_by=>X_LAST_UPDATED_BY,
524: x_last_update_login=>X_LAST_UPDATE_LOGIN
525: );
526: IF (x_mode = 'S') THEN
527: igs_sc_gen_001.set_ctx('R');
528: END IF;
529: update IGS_PE_PERS_NOTE set
530: PE_NOTE_TYPE = NEW_REFERENCES.PE_NOTE_TYPE,
531: START_DATE = NEW_REFERENCES.START_DATE,

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

537: ;
538: if (sql%notfound) then
539: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
540: igs_ge_msg_stack.add;
541: igs_sc_gen_001.unset_ctx('R');
542: app_exception.raise_exception;
543: end if;
544: IF (x_mode = 'S') THEN
545: igs_sc_gen_001.unset_ctx('R');

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

541: igs_sc_gen_001.unset_ctx('R');
542: app_exception.raise_exception;
543: end if;
544: IF (x_mode = 'S') THEN
545: igs_sc_gen_001.unset_ctx('R');
546: END IF;
547:
548:
549: After_DML(

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

556: IF (SQLCODE = (-28115)) THEN
557: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
558: fnd_message.set_token ('ERR_CD', SQLCODE);
559: igs_ge_msg_stack.add;
560: igs_sc_gen_001.unset_ctx('R');
561: app_exception.raise_exception;
562: ELSE
563: igs_sc_gen_001.unset_ctx('R');
564: RAISE;

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

559: igs_ge_msg_stack.add;
560: igs_sc_gen_001.unset_ctx('R');
561: app_exception.raise_exception;
562: ELSE
563: igs_sc_gen_001.unset_ctx('R');
564: RAISE;
565: END IF;
566:
567: end UPDATE_ROW;

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

617: x_rowid => X_ROWID
618: );
619:
620: IF (x_mode = 'S') THEN
621: igs_sc_gen_001.set_ctx('R');
622: END IF;
623: delete from IGS_PE_PERS_NOTE
624: where ROWID = X_ROWID;
625: if (sql%notfound) then

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

624: where ROWID = X_ROWID;
625: if (sql%notfound) then
626: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
627: igs_ge_msg_stack.add;
628: igs_sc_gen_001.unset_ctx('R');
629: app_exception.raise_exception;
630: end if;
631: IF (x_mode = 'S') THEN
632: igs_sc_gen_001.unset_ctx('R');

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

628: igs_sc_gen_001.unset_ctx('R');
629: app_exception.raise_exception;
630: end if;
631: IF (x_mode = 'S') THEN
632: igs_sc_gen_001.unset_ctx('R');
633: END IF;
634:
635:
636: After_DML(