eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_GEN_007 dependencies on IGS_PE_STD_TODO_REF

Line 853: igs_pe_std_todo_ref str,

849: uc.unit_mode,
850: st.todo_dt,
851: sua.uoo_id
852: FROM igs_pe_std_todo st,
853: igs_pe_std_todo_ref str,
854: igs_en_su_attempt_all sua,
855: igs_as_unit_class uc,
856: igs_ca_inst_rel cir
857: WHERE ((NVL (p_person_id, 9999999999) = 9999999999)

Line 1040: -- Logically delete the IGS_PE_STD_TODO_REF table and determine if it was the

1036: END IF;
1037: END IF;
1038: IF v_delete_todo = TRUE THEN
1039: --
1040: -- Logically delete the IGS_PE_STD_TODO_REF table and determine if it was the
1041: -- last IGS_PE_STD_TODO_REF item for the IGS_PE_STD_TODO entry. If so, then
1042: -- logically delete the IGS_PE_STD_TODO entry.
1043: -- If a lock occurs on the item, rollback the whole event for
1044: -- this todo item. (Will also need a commit so that it can be restartable.)

Line 1041: -- last IGS_PE_STD_TODO_REF item for the IGS_PE_STD_TODO entry. If so, then

1037: END IF;
1038: IF v_delete_todo = TRUE THEN
1039: --
1040: -- Logically delete the IGS_PE_STD_TODO_REF table and determine if it was the
1041: -- last IGS_PE_STD_TODO_REF item for the IGS_PE_STD_TODO entry. If so, then
1042: -- logically delete the IGS_PE_STD_TODO entry.
1043: -- If a lock occurs on the item, rollback the whole event for
1044: -- this todo item. (Will also need a commit so that it can be restartable.)
1045: --

Line 1901: SELECT igs_pe_std_todo_ref_rf_num_s.NEXTVAL

1897: DECLARE
1898: l_val NUMBER;
1899: lv_rowid VARCHAR2 (25);
1900: BEGIN
1901: SELECT igs_pe_std_todo_ref_rf_num_s.NEXTVAL
1902: INTO l_val
1903: FROM DUAL;
1904: igs_pe_std_todo_ref_pkg.insert_row (
1905: x_rowid => lv_rowid,

Line 1904: igs_pe_std_todo_ref_pkg.insert_row (

1900: BEGIN
1901: SELECT igs_pe_std_todo_ref_rf_num_s.NEXTVAL
1902: INTO l_val
1903: FROM DUAL;
1904: igs_pe_std_todo_ref_pkg.insert_row (
1905: x_rowid => lv_rowid,
1906: x_person_id => p_person_id,
1907: x_s_student_todo_type => v_s_student_todo_type,
1908: x_sequence_number => v_return_val,