APPS.IGS_AV_STD_UNT_BASIS_PKG dependencies on IGS_SC_GEN_001

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

350: x_last_update_login=>X_LAST_UPDATE_LOGIN,
351: x_org_id=>igs_ge_gen_003.get_org_id
352: );
353: IF (x_mode = 'S') THEN
354: igs_sc_gen_001.set_ctx('R');
355: END IF;
356: insert into IGS_AV_STD_UNT_BASIS_ALL (
357: AV_STND_UNIT_ID,
358: BASIS_COURSE_TYPE,

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

376: X_LAST_UPDATE_LOGIN,
377: NEW_REFERENCES.ORG_ID
378: );
379: IF (x_mode = 'S') THEN
380: igs_sc_gen_001.unset_ctx('R');
381: END IF;
382:
383:
384: open c;

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

394: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
395: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
396: fnd_message.set_token ('ERR_CD', SQLCODE);
397: igs_ge_msg_stack.add;
398: igs_sc_gen_001.unset_ctx('R');
399: app_exception.raise_exception;
400: ELSE
401: igs_sc_gen_001.unset_ctx('R');
402: RAISE;

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

397: igs_ge_msg_stack.add;
398: igs_sc_gen_001.unset_ctx('R');
399: app_exception.raise_exception;
400: ELSE
401: igs_sc_gen_001.unset_ctx('R');
402: RAISE;
403: END IF;
404:
405: end INSERT_ROW;

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

492: x_last_updated_by=>X_LAST_UPDATED_BY,
493: x_last_update_login=>X_LAST_UPDATE_LOGIN
494: );
495: IF (x_mode = 'S') THEN
496: igs_sc_gen_001.set_ctx('R');
497: END IF;
498: update IGS_AV_STD_UNT_BASIS_ALL set
499: BASIS_COURSE_TYPE = NEW_REFERENCES.BASIS_COURSE_TYPE,
500: BASIS_YEAR = NEW_REFERENCES.BASIS_YEAR,

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

505: where ROWID = X_ROWID ;
506: if (sql%notfound) then
507: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
508: igs_ge_msg_stack.add;
509: igs_sc_gen_001.unset_ctx('R');
510: app_exception.raise_exception;
511: end if;
512: IF (x_mode = 'S') THEN
513: igs_sc_gen_001.unset_ctx('R');

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

509: igs_sc_gen_001.unset_ctx('R');
510: app_exception.raise_exception;
511: end if;
512: IF (x_mode = 'S') THEN
513: igs_sc_gen_001.unset_ctx('R');
514: END IF;
515:
516: EXCEPTION
517: WHEN OTHERS THEN

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

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

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

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

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

573: x_rowid => X_ROWID
574: );
575:
576: IF (x_mode = 'S') THEN
577: igs_sc_gen_001.set_ctx('R');
578: END IF;
579: delete from IGS_AV_STD_UNT_BASIS_ALL
580: where ROWID = X_ROWID ;
581: if (sql%notfound) then

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

580: where ROWID = X_ROWID ;
581: if (sql%notfound) then
582: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
583: igs_ge_msg_stack.add;
584: igs_sc_gen_001.unset_ctx('R');
585: app_exception.raise_exception;
586: end if;
587: IF (x_mode = 'S') THEN
588: igs_sc_gen_001.unset_ctx('R');

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

584: igs_sc_gen_001.unset_ctx('R');
585: app_exception.raise_exception;
586: end if;
587: IF (x_mode = 'S') THEN
588: igs_sc_gen_001.unset_ctx('R');
589: END IF;
590:
591:
592: end DELETE_ROW;