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

Line 852: FROM igs_pe_std_todo st,

848: sua.unit_class,
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

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 956: -- (ie. no IGS_PE_STD_TODO item created). (assp_ins_suaai_todo altered).

952: v_new_student := FALSE;
953: END IF;
954: --
955: -- Items are no longer deleted when the status is altered from ENROLLED
956: -- (ie. no IGS_PE_STD_TODO item created). (assp_ins_suaai_todo altered).
957: -- Hence, need to perform the processing associated with a change
958: -- as it is possible that if the student unit attempt was altered in status,
959: -- then while in the altered status e.g., INVALID, the unit offering option
960: -- was changed. Hence, when becoming enrolled, need to check if any

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 1042: -- logically delete the IGS_PE_STD_TODO entry.

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: --
1046: IF igs_ge_gen_003.genp_upd_str_lgc_del (

Line 1866: -- This routine will create a IGS_PE_STD_TODO entry for students who:

1862: p_uoo_id IN NUMBER
1863: ) IS
1864: gv_other_detail VARCHAR2 (255);
1865: BEGIN -- assp_ins_suaai_todo
1866: -- This routine will create a IGS_PE_STD_TODO entry for students who:
1867: -- 1. have just enrolled
1868: -- 2. had their location and class details changed
1869: DECLARE
1870: cst_enrolled CONSTANT igs_en_su_attempt.unit_attempt_status%TYPE := 'ENROLLED';

Line 1881: -- If so, then create a IGS_PE_STD_TODO record

1877: v_todo_flag BOOLEAN;
1878: BEGIN
1879: v_todo_flag := FALSE;
1880: -- Check to see if inserting or updating the record to an ENROLLED status.
1881: -- If so, then create a IGS_PE_STD_TODO record
1882: IF (p_new_unit_attempt_status = cst_enrolled
1883: AND NVL (p_old_unit_attempt_status, 'NULL') NOT IN (cst_enrolled, cst_completed)
1884: ) THEN
1885: v_s_student_todo_type := cst_ass_insert;

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,