APPS.IGS_AV_STD_ULVLBASIS_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_ULVLBASIS_ALL (
357: AV_STND_UNIT_LVL_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: open c;
384: fetch c into X_ROWID;

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

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

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

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

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

487: );
488:
489:
490: IF (x_mode = 'S') THEN
491: igs_sc_gen_001.set_ctx('R');
492: END IF;
493: update IGS_AV_STD_ULVLBASIS_ALL set
494: BASIS_COURSE_TYPE = NEW_REFERENCES.BASIS_COURSE_TYPE,
495: BASIS_YEAR = NEW_REFERENCES.BASIS_YEAR,

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

500: where ROWID = X_ROWID ;
501: if (sql%notfound) then
502: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
503: igs_ge_msg_stack.add;
504: igs_sc_gen_001.unset_ctx('R');
505: app_exception.raise_exception;
506: end if;
507: IF (x_mode = 'S') THEN
508: igs_sc_gen_001.unset_ctx('R');

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

504: igs_sc_gen_001.unset_ctx('R');
505: app_exception.raise_exception;
506: end if;
507: IF (x_mode = 'S') THEN
508: igs_sc_gen_001.unset_ctx('R');
509: END IF;
510:
511:
512:

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

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

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

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

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

570: p_action => 'DELETE',
571: x_rowid => X_ROWID
572: );
573: IF (x_mode = 'S') THEN
574: igs_sc_gen_001.set_ctx('R');
575: END IF;
576: delete from IGS_AV_STD_ULVLBASIS_ALL
577: where ROWID = X_ROWID ;
578: if (sql%notfound) then

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

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

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

581: igs_sc_gen_001.unset_ctx('R');
582: app_exception.raise_exception;
583: end if;
584: IF (x_mode = 'S') THEN
585: igs_sc_gen_001.unset_ctx('R');
586: END IF;
587:
588: end DELETE_ROW;
589: end IGS_AV_STD_ULVLBASIS_PKG;