APPS.IGS_RE_CDT_FLD_OF_SY_PKG dependencies on IGS_SC_GEN_001

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

361: x_last_update_login => X_LAST_UPDATE_LOGIN
362: );
363:
364: IF (x_mode = 'S') THEN
365: igs_sc_gen_001.set_ctx('R');
366: END IF;
367: insert into IGS_RE_CDT_FLD_OF_SY (
368: PERSON_ID,
369: CA_SEQUENCE_NUMBER,

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

385: X_LAST_UPDATED_BY,
386: X_LAST_UPDATE_LOGIN
387: );
388: IF (x_mode = 'S') THEN
389: igs_sc_gen_001.unset_ctx('R');
390: END IF;
391:
392:
393: open c;

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

403: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
404: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
405: fnd_message.set_token ('ERR_CD', SQLCODE);
406: igs_ge_msg_stack.add;
407: igs_sc_gen_001.unset_ctx('R');
408: app_exception.raise_exception;
409: ELSE
410: igs_sc_gen_001.unset_ctx('R');
411: RAISE;

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

406: igs_ge_msg_stack.add;
407: igs_sc_gen_001.unset_ctx('R');
408: app_exception.raise_exception;
409: ELSE
410: igs_sc_gen_001.unset_ctx('R');
411: RAISE;
412: END IF;
413:
414: end INSERT_ROW;

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

493: x_last_update_login => X_LAST_UPDATE_LOGIN
494: );
495:
496: IF (x_mode = 'S') THEN
497: igs_sc_gen_001.set_ctx('R');
498: END IF;
499: update IGS_RE_CDT_FLD_OF_SY set
500: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
501: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

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

505:
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:
517: EXCEPTION

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

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

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

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

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

577: x_rowid => X_ROWID
578: );
579:
580: IF (x_mode = 'S') THEN
581: igs_sc_gen_001.set_ctx('R');
582: END IF;
583: delete from IGS_RE_CDT_FLD_OF_SY
584: where ROWID = X_ROWID;
585:

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

585:
586: if (sql%notfound) then
587: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
588: igs_ge_msg_stack.add;
589: igs_sc_gen_001.unset_ctx('R');
590: app_exception.raise_exception;
591: end if;
592: IF (x_mode = 'S') THEN
593: igs_sc_gen_001.unset_ctx('R');

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

589: igs_sc_gen_001.unset_ctx('R');
590: app_exception.raise_exception;
591: end if;
592: IF (x_mode = 'S') THEN
593: igs_sc_gen_001.unset_ctx('R');
594: END IF;
595:
596:
597: end DELETE_ROW;