DBA Data[Home] [Help]

APPS.IGS_HE_UT_PRS_CALCS_PKG dependencies on IGS_SC_GEN_001

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

281: x_last_update_login => x_last_update_login
282: );
283:
284: IF (x_mode = 'S') THEN
285: igs_sc_gen_001.set_ctx('R');
286: END IF;
287: INSERT INTO igs_he_ut_prs_calcs (
288: tariff_calc_type_cd,
289: person_id,

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

303: x_last_updated_by,
304: x_last_update_login
305: ) RETURNING ROWID INTO x_rowid;
306: IF (x_mode = 'S') THEN
307: igs_sc_gen_001.unset_ctx('R');
308: END IF;
309:
310:
311: l_rowid := NULL;

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

316: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
317: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
318: fnd_message.set_token ('ERR_CD', SQLCODE);
319: igs_ge_msg_stack.add;
320: igs_sc_gen_001.unset_ctx('R');
321: app_exception.raise_exception;
322: ELSE
323: igs_sc_gen_001.unset_ctx('R');
324: RAISE;

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

319: igs_ge_msg_stack.add;
320: igs_sc_gen_001.unset_ctx('R');
321: app_exception.raise_exception;
322: ELSE
323: igs_sc_gen_001.unset_ctx('R');
324: RAISE;
325: END IF;
326: END insert_row;
327:

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

433: x_last_update_login => x_last_update_login
434: );
435:
436: IF (x_mode = 'S') THEN
437: igs_sc_gen_001.set_ctx('R');
438: END IF;
439: UPDATE igs_he_ut_prs_calcs
440: SET
441: calc_date = new_references.calc_date,

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

446:
447: IF (SQL%NOTFOUND) THEN
448: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
449: igs_ge_msg_stack.add;
450: igs_sc_gen_001.unset_ctx('R');
451: app_exception.raise_exception;
452: END IF;
453: IF (x_mode = 'S') THEN
454: igs_sc_gen_001.unset_ctx('R');

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

450: igs_sc_gen_001.unset_ctx('R');
451: app_exception.raise_exception;
452: END IF;
453: IF (x_mode = 'S') THEN
454: igs_sc_gen_001.unset_ctx('R');
455: END IF;
456:
457:
458: l_rowid := NULL;

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

462: IF (SQLCODE = (-28115)) THEN
463: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
464: fnd_message.set_token ('ERR_CD', SQLCODE);
465: igs_ge_msg_stack.add;
466: igs_sc_gen_001.unset_ctx('R');
467: app_exception.raise_exception;
468: ELSE
469: igs_sc_gen_001.unset_ctx('R');
470: RAISE;

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

465: igs_ge_msg_stack.add;
466: igs_sc_gen_001.unset_ctx('R');
467: app_exception.raise_exception;
468: ELSE
469: igs_sc_gen_001.unset_ctx('R');
470: RAISE;
471: END IF;
472:
473: END update_row;

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

544: x_rowid => x_rowid
545: );
546:
547: IF (x_mode = 'S') THEN
548: igs_sc_gen_001.set_ctx('R');
549: END IF;
550: DELETE FROM igs_he_ut_prs_calcs
551: WHERE rowid = x_rowid;
552:

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

552:
553: IF (SQL%NOTFOUND) THEN
554: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
555: igs_ge_msg_stack.add;
556: igs_sc_gen_001.unset_ctx('R');
557: app_exception.raise_exception;
558: END IF;
559: IF (x_mode = 'S') THEN
560: igs_sc_gen_001.unset_ctx('R');

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

556: igs_sc_gen_001.unset_ctx('R');
557: app_exception.raise_exception;
558: END IF;
559: IF (x_mode = 'S') THEN
560: igs_sc_gen_001.unset_ctx('R');
561: END IF;
562:
563:
564: l_rowid := NULL;