DBA Data[Home] [Help]

APPS.IGS_HE_UT_PRS_DTLS_PKG dependencies on IGS_SC_GEN_001

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

313: x_last_update_login => x_last_update_login
314: );
315:
316: IF (x_mode = 'S') THEN
317: igs_sc_gen_001.set_ctx('R');
318: END IF;
319: INSERT INTO igs_he_ut_prs_dtls (
320: tariff_calc_type_cd,
321: person_id,

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

339: x_last_updated_by,
340: x_last_update_login
341: ) RETURNING ROWID INTO x_rowid;
342: IF (x_mode = 'S') THEN
343: igs_sc_gen_001.unset_ctx('R');
344: END IF;
345:
346:
347: l_rowid := NULL;

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

352: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
353: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
354: fnd_message.set_token ('ERR_CD', SQLCODE);
355: igs_ge_msg_stack.add;
356: igs_sc_gen_001.unset_ctx('R');
357: app_exception.raise_exception;
358: ELSE
359: igs_sc_gen_001.unset_ctx('R');
360: RAISE;

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

355: igs_ge_msg_stack.add;
356: igs_sc_gen_001.unset_ctx('R');
357: app_exception.raise_exception;
358: ELSE
359: igs_sc_gen_001.unset_ctx('R');
360: RAISE;
361: END IF;
362: END insert_row;
363:

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

477: x_last_update_login => x_last_update_login
478: );
479:
480: IF (x_mode = 'S') THEN
481: igs_sc_gen_001.set_ctx('R');
482: END IF;
483: UPDATE igs_he_ut_prs_dtls
484: SET
485: number_of_qual = new_references.number_of_qual,

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

491:
492: IF (SQL%NOTFOUND) THEN
493: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
494: igs_ge_msg_stack.add;
495: igs_sc_gen_001.unset_ctx('R');
496: app_exception.raise_exception;
497: END IF;
498: IF (x_mode = 'S') THEN
499: igs_sc_gen_001.unset_ctx('R');

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

495: igs_sc_gen_001.unset_ctx('R');
496: app_exception.raise_exception;
497: END IF;
498: IF (x_mode = 'S') THEN
499: igs_sc_gen_001.unset_ctx('R');
500: END IF;
501:
502:
503: l_rowid := NULL;

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

507: IF (SQLCODE = (-28115)) THEN
508: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
509: fnd_message.set_token ('ERR_CD', SQLCODE);
510: igs_ge_msg_stack.add;
511: igs_sc_gen_001.unset_ctx('R');
512: app_exception.raise_exception;
513: ELSE
514: igs_sc_gen_001.unset_ctx('R');
515: RAISE;

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

510: igs_ge_msg_stack.add;
511: igs_sc_gen_001.unset_ctx('R');
512: app_exception.raise_exception;
513: ELSE
514: igs_sc_gen_001.unset_ctx('R');
515: RAISE;
516: END IF;
517:
518: END update_row;

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

596: x_rowid => x_rowid
597: );
598:
599: IF (x_mode = 'S') THEN
600: igs_sc_gen_001.set_ctx('R');
601: END IF;
602: DELETE FROM igs_he_ut_prs_dtls
603: WHERE rowid = x_rowid;
604:

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

604:
605: IF (SQL%NOTFOUND) THEN
606: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
607: igs_ge_msg_stack.add;
608: igs_sc_gen_001.unset_ctx('R');
609: app_exception.raise_exception;
610: END IF;
611: IF (x_mode = 'S') THEN
612: igs_sc_gen_001.unset_ctx('R');

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

608: igs_sc_gen_001.unset_ctx('R');
609: app_exception.raise_exception;
610: END IF;
611: IF (x_mode = 'S') THEN
612: igs_sc_gen_001.unset_ctx('R');
613: END IF;
614:
615:
616: l_rowid := NULL;