APPS.IGS_PR_STDNT_PR_PS_PKG dependencies on IGS_SC_GEN_001

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

302: x_last_updated_by => X_last_updated_by ,
303: x_last_update_login =>x_last_update_login
304: ) ;
305: IF (x_mode = 'S') THEN
306: igs_sc_gen_001.set_ctx('R');
307: END IF;
308: insert into IGS_PR_STDNT_PR_PS (
309: PERSON_ID,
310: SPO_COURSE_CD,

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

326: X_LAST_UPDATED_BY,
327: X_LAST_UPDATE_LOGIN
328: );
329: IF (x_mode = 'S') THEN
330: igs_sc_gen_001.unset_ctx('R');
331: END IF;
332:
333:
334: open c;

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

343: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
344: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
345: fnd_message.set_token ('ERR_CD', SQLCODE);
346: igs_ge_msg_stack.add;
347: igs_sc_gen_001.unset_ctx('R');
348: app_exception.raise_exception;
349: ELSE
350: igs_sc_gen_001.unset_ctx('R');
351: RAISE;

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

346: igs_ge_msg_stack.add;
347: igs_sc_gen_001.unset_ctx('R');
348: app_exception.raise_exception;
349: ELSE
350: igs_sc_gen_001.unset_ctx('R');
351: RAISE;
352: END IF;
353:
354: end INSERT_ROW;

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

413: p_action => 'DELETE',
414: x_rowid => X_ROWID
415: );
416: IF (x_mode = 'S') THEN
417: igs_sc_gen_001.set_ctx('R');
418: END IF;
419: delete from IGS_PR_STDNT_PR_PS
420: where ROWID = X_ROWID;
421: if (sql%notfound) then

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

420: where ROWID = X_ROWID;
421: if (sql%notfound) then
422: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
423: igs_ge_msg_stack.add;
424: igs_sc_gen_001.unset_ctx('R');
425: app_exception.raise_exception;
426: end if;
427: IF (x_mode = 'S') THEN
428: igs_sc_gen_001.unset_ctx('R');

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

424: igs_sc_gen_001.unset_ctx('R');
425: app_exception.raise_exception;
426: end if;
427: IF (x_mode = 'S') THEN
428: igs_sc_gen_001.unset_ctx('R');
429: END IF;
430:
431: end DELETE_ROW;
432: