DBA Data[Home] [Help]

APPS.IGS_HE_EN_SUSA_CC_PKG dependencies on IGS_SC_GEN_001

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

339: x_last_update_login => x_last_update_login
340: );
341:
342: IF (x_mode = 'S') THEN
343: igs_sc_gen_001.set_ctx('R');
344: END IF;
345: INSERT INTO igs_he_en_susa_cc (
346: he_susa_cc_id,
347: person_id,

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

371: x_last_updated_by,
372: x_last_update_login
373: ) RETURNING ROWID, he_susa_cc_id INTO x_rowid, x_he_susa_cc_id;
374: IF (x_mode = 'S') THEN
375: igs_sc_gen_001.unset_ctx('R');
376: END IF;
377:
378:
379: l_rowid := NULL;

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

384: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
385: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
386: fnd_message.set_token ('ERR_CD', SQLCODE);
387: igs_ge_msg_stack.add;
388: igs_sc_gen_001.unset_ctx('R');
389: app_exception.raise_exception;
390: ELSE
391: igs_sc_gen_001.unset_ctx('R');
392: RAISE;

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

387: igs_ge_msg_stack.add;
388: igs_sc_gen_001.unset_ctx('R');
389: app_exception.raise_exception;
390: ELSE
391: igs_sc_gen_001.unset_ctx('R');
392: RAISE;
393: END IF;
394: END insert_row;
395:

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

528: x_last_update_login => x_last_update_login
529: );
530:
531: IF (x_mode = 'S') THEN
532: igs_sc_gen_001.set_ctx('R');
533: END IF;
534: UPDATE igs_he_en_susa_cc
535: SET
536: person_id = new_references.person_id,

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

547:
548: IF (SQL%NOTFOUND) THEN
549: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
550: igs_ge_msg_stack.add;
551: igs_sc_gen_001.unset_ctx('R');
552: app_exception.raise_exception;
553: END IF;
554: IF (x_mode = 'S') THEN
555: igs_sc_gen_001.unset_ctx('R');

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

551: igs_sc_gen_001.unset_ctx('R');
552: app_exception.raise_exception;
553: END IF;
554: IF (x_mode = 'S') THEN
555: igs_sc_gen_001.unset_ctx('R');
556: END IF;
557:
558:
559: l_rowid := NULL;

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

563: IF (SQLCODE = (-28115)) THEN
564: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
565: fnd_message.set_token ('ERR_CD', SQLCODE);
566: igs_ge_msg_stack.add;
567: igs_sc_gen_001.unset_ctx('R');
568: app_exception.raise_exception;
569: ELSE
570: igs_sc_gen_001.unset_ctx('R');
571: RAISE;

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

566: igs_ge_msg_stack.add;
567: igs_sc_gen_001.unset_ctx('R');
568: app_exception.raise_exception;
569: ELSE
570: igs_sc_gen_001.unset_ctx('R');
571: RAISE;
572: END IF;
573:
574: END update_row;

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

659: x_rowid => x_rowid
660: );
661:
662: IF (x_mode = 'S') THEN
663: igs_sc_gen_001.set_ctx('R');
664: END IF;
665: DELETE FROM igs_he_en_susa_cc
666: WHERE rowid = x_rowid;
667:

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

667:
668: IF (SQL%NOTFOUND) THEN
669: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
670: igs_ge_msg_stack.add;
671: igs_sc_gen_001.unset_ctx('R');
672: app_exception.raise_exception;
673: END IF;
674: IF (x_mode = 'S') THEN
675: igs_sc_gen_001.unset_ctx('R');

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

671: igs_sc_gen_001.unset_ctx('R');
672: app_exception.raise_exception;
673: END IF;
674: IF (x_mode = 'S') THEN
675: igs_sc_gen_001.unset_ctx('R');
676: END IF;
677:
678:
679: l_rowid := NULL;