DBA Data[Home] [Help]

APPS.IGS_PR_STDNT_PR_CK_PKG dependencies on IGS_SC_GEN_001

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

386: x_last_update_login => x_last_update_login
387: ) ;
388:
389: IF (x_mode = 'S') THEN
390: igs_sc_gen_001.set_ctx('R');
391: END IF;
392: insert into IGS_PR_STDNT_PR_CK (
393: PERSON_ID,
394: COURSE_CD,

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

414: X_LAST_UPDATED_BY,
415: X_LAST_UPDATE_LOGIN
416: );
417: IF (x_mode = 'S') THEN
418: igs_sc_gen_001.unset_ctx('R');
419: END IF;
420:
421:
422: open c;

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

431: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
432: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
433: fnd_message.set_token ('ERR_CD', SQLCODE);
434: igs_ge_msg_stack.add;
435: igs_sc_gen_001.unset_ctx('R');
436: app_exception.raise_exception;
437: ELSE
438: igs_sc_gen_001.unset_ctx('R');
439: RAISE;

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

434: igs_ge_msg_stack.add;
435: igs_sc_gen_001.unset_ctx('R');
436: app_exception.raise_exception;
437: ELSE
438: igs_sc_gen_001.unset_ctx('R');
439: RAISE;
440: END IF;
441:
442: end INSERT_ROW;

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

530: ) ;
531:
532:
533: IF (x_mode = 'S') THEN
534: igs_sc_gen_001.set_ctx('R');
535: END IF;
536: update IGS_PR_STDNT_PR_CK set
537: S_PRG_CHECK_TYPE = NEW_REFERENCES.S_PRG_CHECK_TYPE,
538: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

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

541: where ROWID = X_ROWID;
542: if (sql%notfound) then
543: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
544: igs_ge_msg_stack.add;
545: igs_sc_gen_001.unset_ctx('R');
546: app_exception.raise_exception;
547: end if;
548: IF (x_mode = 'S') THEN
549: igs_sc_gen_001.unset_ctx('R');

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

545: igs_sc_gen_001.unset_ctx('R');
546: app_exception.raise_exception;
547: end if;
548: IF (x_mode = 'S') THEN
549: igs_sc_gen_001.unset_ctx('R');
550: END IF;
551:
552: EXCEPTION
553: WHEN OTHERS THEN

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

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

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

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

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

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

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

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

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

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