APPS.IGS_AD_HZ_EXTRACURR_ACT_PKG dependencies on IGS_SC_GEN_001

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

350: x_last_update_login => x_last_update_login
351: );
352:
353: IF (x_mode = 'S') THEN
354: igs_sc_gen_001.set_ctx('R');
355: END IF;
356: INSERT INTO igs_ad_hz_extracurr_act (
357: hz_extracurr_act_id,
358: person_interest_id,

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

386: x_program_update_date,
387: x_program_id
388: )RETURNING HZ_EXTRACURR_ACT_ID INTO X_HZ_EXTRACURR_ACT_ID;
389: IF (x_mode = 'S') THEN
390: igs_sc_gen_001.unset_ctx('R');
391: END IF;
392:
393:
394: OPEN c;

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

405: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
406: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
407: fnd_message.set_token ('ERR_CD', SQLCODE);
408: igs_ge_msg_stack.add;
409: igs_sc_gen_001.unset_ctx('R');
410: app_exception.raise_exception;
411: ELSE
412: igs_sc_gen_001.unset_ctx('R');
413: RAISE;

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

408: igs_ge_msg_stack.add;
409: igs_sc_gen_001.unset_ctx('R');
410: app_exception.raise_exception;
411: ELSE
412: igs_sc_gen_001.unset_ctx('R');
413: RAISE;
414: END IF;
415: END insert_row;
416:

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

559: x_last_update_login => x_last_update_login
560: );
561:
562: IF (x_mode = 'S') THEN
563: igs_sc_gen_001.set_ctx('R');
564: END IF;
565: UPDATE igs_ad_hz_extracurr_act
566: SET
567: hz_extracurr_act_id = new_references.hz_extracurr_act_id,

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

581:
582: IF (SQL%NOTFOUND) THEN
583: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
584: igs_ge_msg_stack.add;
585: igs_sc_gen_001.unset_ctx('R');
586: app_exception.raise_exception;
587: END IF;
588: IF (x_mode = 'S') THEN
589: igs_sc_gen_001.unset_ctx('R');

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

585: igs_sc_gen_001.unset_ctx('R');
586: app_exception.raise_exception;
587: END IF;
588: IF (x_mode = 'S') THEN
589: igs_sc_gen_001.unset_ctx('R');
590: END IF;
591:
592:
593:

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

596: IF (SQLCODE = (-28115)) THEN
597: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
598: fnd_message.set_token ('ERR_CD', SQLCODE);
599: igs_ge_msg_stack.add;
600: igs_sc_gen_001.unset_ctx('R');
601: app_exception.raise_exception;
602: ELSE
603: igs_sc_gen_001.unset_ctx('R');
604: RAISE;

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

599: igs_ge_msg_stack.add;
600: igs_sc_gen_001.unset_ctx('R');
601: app_exception.raise_exception;
602: ELSE
603: igs_sc_gen_001.unset_ctx('R');
604: RAISE;
605: END IF;
606: END update_row;
607:

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

685: x_rowid => x_rowid
686: );
687:
688: IF (x_mode = 'S') THEN
689: igs_sc_gen_001.set_ctx('R');
690: END IF;
691: DELETE FROM igs_ad_hz_extracurr_act
692: WHERE ROWID = x_rowid;
693:

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

693:
694: IF (SQL%NOTFOUND) THEN
695: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
696: igs_ge_msg_stack.add;
697: igs_sc_gen_001.unset_ctx('R');
698: app_exception.raise_exception;
699: END IF;
700: IF (x_mode = 'S') THEN
701: igs_sc_gen_001.unset_ctx('R');

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

697: igs_sc_gen_001.unset_ctx('R');
698: app_exception.raise_exception;
699: END IF;
700: IF (x_mode = 'S') THEN
701: igs_sc_gen_001.unset_ctx('R');
702: END IF;
703:
704:
705: END delete_row;