APPS.IGS_GR_SPECIAL_AWARD_PKG dependencies on IGS_SC_GEN_001

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

366: x_org_id => igs_ge_gen_003.get_org_id
367: );
368:
369: IF (x_mode = 'S') THEN
370: igs_sc_gen_001.set_ctx('R');
371: END IF;
372: insert into IGS_GR_SPECIAL_AWARD_ALL (
373: PERSON_ID,
374: COURSE_CD,

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

396: X_LAST_UPDATE_LOGIN,
397: NEW_REFERENCES.ORG_ID
398: );
399: IF (x_mode = 'S') THEN
400: igs_sc_gen_001.unset_ctx('R');
401: END IF;
402:
403:
404: open c;

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

414: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
415: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
416: fnd_message.set_token ('ERR_CD', SQLCODE);
417: igs_ge_msg_stack.add;
418: igs_sc_gen_001.unset_ctx('R');
419: app_exception.raise_exception;
420: ELSE
421: igs_sc_gen_001.unset_ctx('R');
422: RAISE;

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

417: igs_ge_msg_stack.add;
418: igs_sc_gen_001.unset_ctx('R');
419: app_exception.raise_exception;
420: ELSE
421: igs_sc_gen_001.unset_ctx('R');
422: RAISE;
423: END IF;
424:
425: end INSERT_ROW;

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

512: x_last_update_login => X_LAST_UPDATE_LOGIN
513: );
514:
515: IF (x_mode = 'S') THEN
516: igs_sc_gen_001.set_ctx('R');
517: END IF;
518: update IGS_GR_SPECIAL_AWARD_ALL set
519: CEREMONY_ANNOUNCED_IND = NEW_REFERENCES.CEREMONY_ANNOUNCED_IND,
520: COMMENTS = NEW_REFERENCES.COMMENTS,

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

525: ;
526: if (sql%notfound) then
527: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
528: igs_ge_msg_stack.add;
529: igs_sc_gen_001.unset_ctx('R');
530: app_exception.raise_exception;
531: end if;
532: IF (x_mode = 'S') THEN
533: igs_sc_gen_001.unset_ctx('R');

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

529: igs_sc_gen_001.unset_ctx('R');
530: app_exception.raise_exception;
531: end if;
532: IF (x_mode = 'S') THEN
533: igs_sc_gen_001.unset_ctx('R');
534: END IF;
535:
536:
537: EXCEPTION

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

539: IF (SQLCODE = (-28115)) THEN
540: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
541: fnd_message.set_token ('ERR_CD', SQLCODE);
542: igs_ge_msg_stack.add;
543: igs_sc_gen_001.unset_ctx('R');
544: app_exception.raise_exception;
545: ELSE
546: igs_sc_gen_001.unset_ctx('R');
547: RAISE;

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

542: igs_ge_msg_stack.add;
543: igs_sc_gen_001.unset_ctx('R');
544: app_exception.raise_exception;
545: ELSE
546: igs_sc_gen_001.unset_ctx('R');
547: RAISE;
548: END IF;
549:
550: end UPDATE_ROW;

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

604: ) AS
605: begin
606:
607: IF (x_mode = 'S') THEN
608: igs_sc_gen_001.set_ctx('R');
609: END IF;
610: delete from IGS_GR_SPECIAL_AWARD_ALL
611: where ROWID = X_ROWID;
612: if (sql%notfound) then

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

611: where ROWID = X_ROWID;
612: if (sql%notfound) then
613: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
614: igs_ge_msg_stack.add;
615: igs_sc_gen_001.unset_ctx('R');
616: app_exception.raise_exception;
617: end if;
618: IF (x_mode = 'S') THEN
619: igs_sc_gen_001.unset_ctx('R');

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

615: igs_sc_gen_001.unset_ctx('R');
616: app_exception.raise_exception;
617: end if;
618: IF (x_mode = 'S') THEN
619: igs_sc_gen_001.unset_ctx('R');
620: END IF;
621:
622:
623: end DELETE_ROW;