DBA Data[Home] [Help]

APPS.IGS_PE_EV_FORM_STAT_PKG dependencies on IGS_SC_GEN_001

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

510: x_last_update_login => x_last_update_login
511: );
512:
513: IF (x_mode = 'S') THEN
514: igs_sc_gen_001.set_ctx('R');
515: END IF;
516: INSERT INTO igs_pe_ev_form_stat (
517: ev_form_stat_id,
518: ev_form_id,

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

544: x_last_updated_by,
545: x_last_update_login
546: ) RETURNING ROWID, ev_form_stat_id INTO x_rowid, x_ev_form_stat_id;
547: IF (x_mode = 'S') THEN
548: igs_sc_gen_001.unset_ctx('R');
549: END IF;
550:
551:
552: afterrowinsertupdate(p_insert => TRUE, p_update => FALSE);

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

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

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

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

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

705: x_last_update_login => x_last_update_login
706: );
707:
708: IF (x_mode = 'S') THEN
709: igs_sc_gen_001.set_ctx('R');
710: END IF;
711: UPDATE igs_pe_ev_form_stat
712: SET
713: ev_form_id = new_references.ev_form_id,

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

725:
726: IF (SQL%NOTFOUND) THEN
727: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
728: igs_ge_msg_stack.add;
729: igs_sc_gen_001.unset_ctx('R');
730: app_exception.raise_exception;
731: END IF;
732: IF (x_mode = 'S') THEN
733: igs_sc_gen_001.unset_ctx('R');

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

729: igs_sc_gen_001.unset_ctx('R');
730: app_exception.raise_exception;
731: END IF;
732: IF (x_mode = 'S') THEN
733: igs_sc_gen_001.unset_ctx('R');
734: END IF;
735:
736:
737:

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

740: IF (SQLCODE = (-28115)) THEN
741: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
742: fnd_message.set_token ('ERR_CD', SQLCODE);
743: igs_ge_msg_stack.add;
744: igs_sc_gen_001.unset_ctx('R');
745: app_exception.raise_exception;
746: ELSE
747: igs_sc_gen_001.unset_ctx('R');
748: RAISE;

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

743: igs_ge_msg_stack.add;
744: igs_sc_gen_001.unset_ctx('R');
745: app_exception.raise_exception;
746: ELSE
747: igs_sc_gen_001.unset_ctx('R');
748: RAISE;
749: END IF;
750: END update_row;
751:

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

838: x_rowid => x_rowid
839: );
840:
841: IF (x_mode = 'S') THEN
842: igs_sc_gen_001.set_ctx('R');
843: END IF;
844: DELETE FROM igs_pe_ev_form_stat
845: WHERE rowid = x_rowid;
846:

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

846:
847: IF (SQL%NOTFOUND) THEN
848: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
849: igs_ge_msg_stack.add;
850: igs_sc_gen_001.unset_ctx('R');
851: app_exception.raise_exception;
852: END IF;
853: IF (x_mode = 'S') THEN
854: igs_sc_gen_001.unset_ctx('R');

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

850: igs_sc_gen_001.unset_ctx('R');
851: app_exception.raise_exception;
852: END IF;
853: IF (x_mode = 'S') THEN
854: igs_sc_gen_001.unset_ctx('R');
855: END IF;
856:
857:
858: END delete_row;