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_GE_S_LOG

Line 170: cp_creation_dt igs_ge_s_log_entry.creation_dt%TYPE,

166: AND creation_dt = cp_creation_dt
167: FOR UPDATE OF tracking_id NOWAIT;
168: --
169: CURSOR c_sle (
170: cp_creation_dt igs_ge_s_log_entry.creation_dt%TYPE,
171: cp_key igs_ge_s_log_entry.KEY%TYPE,
172: cp_text igs_ge_s_log_entry.text%TYPE
173: ) IS
174: SELECT 'x'

Line 171: cp_key igs_ge_s_log_entry.KEY%TYPE,

167: FOR UPDATE OF tracking_id NOWAIT;
168: --
169: CURSOR c_sle (
170: cp_creation_dt igs_ge_s_log_entry.creation_dt%TYPE,
171: cp_key igs_ge_s_log_entry.KEY%TYPE,
172: cp_text igs_ge_s_log_entry.text%TYPE
173: ) IS
174: SELECT 'x'
175: FROM igs_ge_s_log_entry

Line 172: cp_text igs_ge_s_log_entry.text%TYPE

168: --
169: CURSOR c_sle (
170: cp_creation_dt igs_ge_s_log_entry.creation_dt%TYPE,
171: cp_key igs_ge_s_log_entry.KEY%TYPE,
172: cp_text igs_ge_s_log_entry.text%TYPE
173: ) IS
174: SELECT 'x'
175: FROM igs_ge_s_log_entry
176: WHERE s_log_type = 'ASS3610'

Line 175: FROM igs_ge_s_log_entry

171: cp_key igs_ge_s_log_entry.KEY%TYPE,
172: cp_text igs_ge_s_log_entry.text%TYPE
173: ) IS
174: SELECT 'x'
175: FROM igs_ge_s_log_entry
176: WHERE s_log_type = 'ASS3610'
177: AND creation_dt = cp_creation_dt
178: AND KEY = cp_key
179: AND text = cp_text;

Line 253: -- Insert into the IGS_GE_S_LOG_ENTRY table

249: || v_uai_location_cd;
250: IF (gv_log_created = FALSE) THEN
251: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt);
252: gv_log_created := TRUE;
253: -- Insert into the IGS_GE_S_LOG_ENTRY table
254: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'NO_DUE_DT', NULL, v_record);
255: ELSE
256: -- Only insert if a log entry not already exists.
257: OPEN c_sle (v_log_dt, 'NO_DUE_DT', v_record);

Line 299: -- Insert into the IGS_GE_S_LOG_ENTRY table.

295: || v_uai_location_cd;
296: IF gv_log_created = FALSE THEN
297: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY
298: gv_log_created := TRUE;
299: -- Insert into the IGS_GE_S_LOG_ENTRY table.
300: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'EARLY_DUE_DT', NULL, v_record);
301: ELSE
302: -- Check to see if a log entry already exists for this
303: -- assessment item indicating that the due date is earlier

Line 373: -- Insert into the IGS_GE_S_LOG_ENTRY table.

369: || v_uai_location_cd;
370: IF gv_log_created = FALSE THEN
371: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY
372: gv_log_created := TRUE;
373: -- Insert into the IGS_GE_S_LOG_ENTRY table.
374: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'TRI_ERROR', v_message_name, v_record);
375: ELSE
376: -- Check to see if a log entry already exists for
377: -- this assessment item indicating that the due date

Line 487: -- Insert into the IGS_GE_S_LOG_ENTRY table.

483: || v_uai_location_cd;
484: IF gv_log_created = FALSE THEN
485: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY
486: gv_log_created := TRUE;
487: -- Insert into the IGS_GE_S_LOG_ENTRY table.
488: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'STEP_DUE_DT', v_message_name, v_record);
489: ELSE
490: -- Check to see if a log entry already exists for this
491: -- assessment item indicating that the due date is

Line 605: -- Insert into the IGS_GE_S_LOG_ENTRY table.

601: IF gv_log_created = FALSE THEN
602: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY
603: gv_log_created := TRUE;
604: END IF;
605: -- Insert into the IGS_GE_S_LOG_ENTRY table.
606: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'SUAAI_LOCK', NULL, v_record);
607: WHEN OTHERS THEN
608: RAISE;
609: END; -- sub block

Line 827: v_sle_key igs_ge_s_log_entry.KEY%TYPE;

823: cst_error_stdnt_todo CONSTANT VARCHAR2 (19) := 'ERROR|STUDENT_TODO|';
824: v_error_count NUMBER := 0;
825: v_warning_count NUMBER := 0;
826: v_delete_todo BOOLEAN;
827: v_sle_key igs_ge_s_log_entry.KEY%TYPE;
828: v_new_student BOOLEAN;
829: v_previous_student igs_pe_person.person_id%TYPE;
830: v_previous_unit igs_en_su_attempt.unit_cd%TYPE;
831: v_key igs_ge_s_log.KEY%TYPE;

Line 831: v_key igs_ge_s_log.KEY%TYPE;

827: v_sle_key igs_ge_s_log_entry.KEY%TYPE;
828: v_new_student BOOLEAN;
829: v_previous_student igs_pe_person.person_id%TYPE;
830: v_previous_unit igs_en_su_attempt.unit_cd%TYPE;
831: v_key igs_ge_s_log.KEY%TYPE;
832: v_message_name VARCHAR2 (30);
833: v_log_dt DATE DEFAULT NULL;
834: v_record VARCHAR2 (255);
835: v_total_count NUMBER;

Line 1186: v_session_id igs_ge_s_log.KEY%TYPE DEFAULT NULL;

1182: cst_error CONSTANT VARCHAR2 (10) := 'ERROR';
1183: cst_item CONSTANT VARCHAR2 (10) := 'ITEM';
1184: v_clear_action_dt BOOLEAN;
1185: v_record VARCHAR2 (255) DEFAULT NULL;
1186: v_session_id igs_ge_s_log.KEY%TYPE DEFAULT NULL;
1187: v_message_name VARCHAR2 (30);
1188: v_error_count NUMBER DEFAULT 0;
1189: v_warning_count NUMBER DEFAULT 0;
1190: v_total_count NUMBER DEFAULT 0;

Line 1192: v_key igs_ge_s_log_entry.KEY%TYPE DEFAULT 'MAINTAIN STUDENT UNIT ASSESSMENT ITEMS';

1188: v_error_count NUMBER DEFAULT 0;
1189: v_warning_count NUMBER DEFAULT 0;
1190: v_total_count NUMBER DEFAULT 0;
1191: v_creation_dt DATE DEFAULT NULL;
1192: v_key igs_ge_s_log_entry.KEY%TYPE DEFAULT 'MAINTAIN STUDENT UNIT ASSESSMENT ITEMS';
1193: v_sle_key igs_ge_s_log_entry.KEY%TYPE DEFAULT NULL;
1194: --
1195: -- Included one more select clause in the below cursor to select the
1196: -- assessment item set up at unit section level as a part of calculation

Line 1193: v_sle_key igs_ge_s_log_entry.KEY%TYPE DEFAULT NULL;

1189: v_warning_count NUMBER DEFAULT 0;
1190: v_total_count NUMBER DEFAULT 0;
1191: v_creation_dt DATE DEFAULT NULL;
1192: v_key igs_ge_s_log_entry.KEY%TYPE DEFAULT 'MAINTAIN STUDENT UNIT ASSESSMENT ITEMS';
1193: v_sle_key igs_ge_s_log_entry.KEY%TYPE DEFAULT NULL;
1194: --
1195: -- Included one more select clause in the below cursor to select the
1196: -- assessment item set up at unit section level as a part of calculation
1197: -- of records -1 bug n0:2162831

Line 1330: p_session_id igs_ge_s_log.KEY%TYPE,

1326: p_cal_type igs_as_unitass_item.cal_type%TYPE,
1327: p_ci_sequence_number igs_as_unitass_item.ci_sequence_number%TYPE,
1328: p_ass_id igs_as_unitass_item.ass_id%TYPE,
1329: p_sequence_number igs_as_unitass_item.sequence_number%TYPE,
1330: p_session_id igs_ge_s_log.KEY%TYPE,
1331: p_log_dt IN OUT NOCOPY DATE
1332: ) IS
1333: gv_other_detail VARCHAR2 (255);
1334: BEGIN -- asspl_prc_update_uai

Line 1445: p_session_id igs_ge_s_log.KEY%TYPE,

1441: PROCEDURE asspl_prc_upd_usec_uai (
1442: p_uoo_id igs_ps_unitass_item.uoo_id%TYPE,
1443: p_ass_id igs_ps_unitass_item.ass_id%TYPE,
1444: p_sequence_number igs_ps_unitass_item.sequence_number%TYPE,
1445: p_session_id igs_ge_s_log.KEY%TYPE,
1446: p_log_dt IN OUT NOCOPY DATE
1447: ) IS
1448: gv_other_detail VARCHAR2 (255);
1449: BEGIN -- asspl_prc_upd_usec_uai