DBA Data[Home] [Help]

APPS.IGS_RE_CAND_SEO_CLS_PKG dependencies on IGS_SC_GEN_001

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

379: x_last_update_login => X_LAST_UPDATE_LOGIN
380: );
381:
382: IF (x_mode = 'S') THEN
383: igs_sc_gen_001.set_ctx('R');
384: END IF;
385: insert into IGS_RE_CAND_SEO_CLS (
386: PERSON_ID,
387: CA_SEQUENCE_NUMBER,

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

403: X_LAST_UPDATED_BY,
404: X_LAST_UPDATE_LOGIN
405: );
406: IF (x_mode = 'S') THEN
407: igs_sc_gen_001.unset_ctx('R');
408: END IF;
409:
410:
411: open c;

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

420: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
421: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
422: fnd_message.set_token ('ERR_CD', SQLCODE);
423: igs_ge_msg_stack.add;
424: igs_sc_gen_001.unset_ctx('R');
425: app_exception.raise_exception;
426: ELSE
427: igs_sc_gen_001.unset_ctx('R');
428: RAISE;

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

423: igs_ge_msg_stack.add;
424: igs_sc_gen_001.unset_ctx('R');
425: app_exception.raise_exception;
426: ELSE
427: igs_sc_gen_001.unset_ctx('R');
428: RAISE;
429: END IF;
430:
431: end INSERT_ROW;

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

510: x_last_update_login => X_LAST_UPDATE_LOGIN
511: );
512:
513: IF (x_mode = 'S') THEN
514: igs_sc_gen_001.set_ctx('R');
515: END IF;
516: update IGS_RE_CAND_SEO_CLS set
517: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
518: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

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

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

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

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

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

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

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

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

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

593: x_rowid => X_ROWID
594: );
595:
596: IF (x_mode = 'S') THEN
597: igs_sc_gen_001.set_ctx('R');
598: END IF;
599: delete from IGS_RE_CAND_SEO_CLS
600: where ROWID = X_ROWID;
601: if (sql%notfound) then

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

600: where ROWID = X_ROWID;
601: if (sql%notfound) then
602: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
603: igs_ge_msg_stack.add;
604: igs_sc_gen_001.unset_ctx('R');
605: app_exception.raise_exception;
606: end if;
607: IF (x_mode = 'S') THEN
608: igs_sc_gen_001.unset_ctx('R');

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

604: igs_sc_gen_001.unset_ctx('R');
605: app_exception.raise_exception;
606: end if;
607: IF (x_mode = 'S') THEN
608: igs_sc_gen_001.unset_ctx('R');
609: END IF;
610:
611:
612: end DELETE_ROW;