APPS.IGS_EN_GEN_009 dependencies on IGS_GE_GEN_003

Line 855: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

851: v_ci_start_dt DATE;
852: v_ci_end_dt DATE;
853: v_core_only VARCHAR2(1);
854: cst_core_only VARCHAR2(10) := 'CORE_ONLY';
855: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
856: --smaddali added this cursor for YOP-EN dld
857: CURSOR c_sua (
858: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
859: SELECT 'x'

Line 1047: IGS_GE_GEN_003.genp_ins_log_entry(

1043: ROLLBACK TO sp_pos;
1044: IF p_log_creation_dt IS NOT NULL THEN
1045: -- If the log creation date is set then log the HECS error
1046: -- This is if the pre-enrolment is being performed in batch.
1047: IGS_GE_GEN_003.genp_ins_log_entry(
1048: cst_pre_enrol,
1049: p_log_creation_dt,
1050: cst_major || ',' ||
1051: TO_CHAR(p_person_id) || ',' ||

Line 1084: IGS_GE_GEN_003.genp_ins_log_entry(

1080: IF v_aci_rec.start_dt > v_ci2_rec.start_dt THEN
1081: IF p_log_creation_dt IS NOT NULL THEN
1082: -- If the log creation date is set then log the HECS error
1083: -- This is if the pre-enrolment is being performed in batch.
1084: IGS_GE_GEN_003.genp_ins_log_entry(
1085: cst_pre_enrol,
1086: p_log_creation_dt,
1087: cst_major || ',' ||
1088: TO_CHAR(p_person_id) || ',' ||

Line 1113: IGS_GE_GEN_003.genp_ins_log_entry(

1109: ROLLBACK TO sp_pos;
1110: IF p_log_creation_dt IS NOT NULL THEN
1111: -- If the log creation date is set then log the HECS error
1112: -- This is if the pre-enrolment is being performed in batch.
1113: IGS_GE_GEN_003.genp_ins_log_entry(
1114: cst_pre_enrol,
1115: p_log_creation_dt,
1116: cst_major || ',' ||
1117: TO_CHAR(p_person_id) || ',' ||

Line 1205: IGS_GE_GEN_003.genp_ins_log_entry(

1201: v_uoo_id) THEN
1202: IF p_log_creation_dt IS NOT NULL THEN
1203: -- If the log creation date is set then log the HECS error
1204: -- This is if the pre-enrolment is being performed in batch.
1205: IGS_GE_GEN_003.genp_ins_log_entry(
1206: cst_pre_enrol,
1207: p_log_creation_dt,
1208: cst_minor || ',' ||
1209: TO_CHAR(p_person_id) || ',' ||

Line 1511: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

1507: v_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
1508: v_attendance_percentage_new IGS_RE_CDT_ATT_HIST.attendance_percentage%TYPE;
1509: v_cah_sequence_number IGS_RE_CDT_ATT_HIST.sequence_number%TYPE;
1510:
1511: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
1512:
1513: CURSOR c_ca IS
1514: SELECT ca.sequence_number,
1515: ca.attendance_percentage

Line 2045: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

2041: END IF;
2042:
2043: DECLARE
2044: l_rowid VARCHAR2(25);
2045: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
2046: BEGIN
2047: -- ADD_ROW is used instead of INSERT_ROW, so that the history record is updated in
2048: -- case more than one history record is created within a second. More than one record
2049: -- are being created while recursive update_row of ps att table is performed.