DBA Data[Home] [Help]

APPS.IGS_AD_HZ_EMP_DTL_PKG dependencies on IGS_SC_GEN_001

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

330: x_last_update_login => x_last_update_login
331: );
332:
333: IF (x_mode = 'S') THEN
334: igs_sc_gen_001.set_ctx('R');
335: END IF;
336: INSERT INTO igs_ad_hz_emp_dtl (
337: hz_emp_dtl_id,
338: employment_history_id,

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

362: x_last_updated_by,
363: x_last_update_login
364: )RETURNING HZ_EMP_DTL_ID INTO X_HZ_EMP_DTL_ID;
365: IF (x_mode = 'S') THEN
366: igs_sc_gen_001.unset_ctx('R');
367: END IF;
368:
369:
370: OPEN c;

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

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

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

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

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

521: x_last_update_login => x_last_update_login
522: );
523:
524: IF (x_mode = 'S') THEN
525: igs_sc_gen_001.set_ctx('R');
526: END IF;
527: UPDATE igs_ad_hz_emp_dtl
528: SET
529: hz_emp_dtl_id = new_references.hz_emp_dtl_id,

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

541:
542: IF (SQL%NOTFOUND) THEN
543: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
544: igs_ge_msg_stack.add;
545: igs_sc_gen_001.unset_ctx('R');
546: app_exception.raise_exception;
547: END IF;
548: IF (x_mode = 'S') THEN
549: igs_sc_gen_001.unset_ctx('R');

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

545: igs_sc_gen_001.unset_ctx('R');
546: app_exception.raise_exception;
547: END IF;
548: IF (x_mode = 'S') THEN
549: igs_sc_gen_001.unset_ctx('R');
550: END IF;
551:
552:
553:

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

556: IF (SQLCODE = (-28115)) THEN
557: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
558: fnd_message.set_token ('ERR_CD', SQLCODE);
559: igs_ge_msg_stack.add;
560: igs_sc_gen_001.unset_ctx('R');
561: app_exception.raise_exception;
562: ELSE
563: igs_sc_gen_001.unset_ctx('R');
564: RAISE;

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

559: igs_ge_msg_stack.add;
560: igs_sc_gen_001.unset_ctx('R');
561: app_exception.raise_exception;
562: ELSE
563: igs_sc_gen_001.unset_ctx('R');
564: RAISE;
565: END IF;
566: END update_row;
567:

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

653: x_rowid => x_rowid
654: );
655:
656: IF (x_mode = 'S') THEN
657: igs_sc_gen_001.set_ctx('R');
658: END IF;
659: DELETE FROM igs_ad_hz_emp_dtl
660: WHERE rowid = x_rowid;
661:

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

661:
662: IF (SQL%NOTFOUND) THEN
663: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
664: igs_ge_msg_stack.add;
665: igs_sc_gen_001.unset_ctx('R');
666: app_exception.raise_exception;
667: END IF;
668: IF (x_mode = 'S') THEN
669: igs_sc_gen_001.unset_ctx('R');

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

665: igs_sc_gen_001.unset_ctx('R');
666: app_exception.raise_exception;
667: END IF;
668: IF (x_mode = 'S') THEN
669: igs_sc_gen_001.unset_ctx('R');
670: END IF;
671:
672: */
673: null;