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_EN_GEN_012 dependencies on IGS_GE_GEN_003

Line 1762: Igs_Ge_Gen_003.genp_ins_log(cst_sca_lapse,

1758: v_trm_or_tch_end_date := v_teachload_rec.end_dt;
1759: END IF;
1760: CLOSE c_teachload;
1761:
1762: Igs_Ge_Gen_003.genp_ins_log(cst_sca_lapse,
1763: p_acad_cal_type || ',' ||
1764: TO_CHAR(p_acad_sequence_number) || ',' ||
1765: TO_CHAR(v_ci_rec.start_dt,'DD/MM/YYYY') || ',' ||
1766: TO_CHAR(v_ci_rec.end_dt,'DD/MM/YYYY') || ',' ||

Line 1951: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

1947: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;
1948:
1949: l_rowid VARCHAR2(25);
1950: l_pk NUMBER(15);
1951: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
1952:
1953: BEGIN
1954: -- fetching person_type_code for system_type of 'FORMER_STUDENT'
1955: OPEN c_former_stdnt;

Line 2074: Igs_Ge_Gen_003.genp_ins_log_entry(cst_sca_lapse,

2070: -- Write log entry indicating future enrolled IGS_PS_UNIT attempts
2071: -- were found - typically the student will be intermittent
2072: -- or the like.
2073:
2074: Igs_Ge_Gen_003.genp_ins_log_entry(cst_sca_lapse,
2075: v_log_creation_dt,
2076: v_sca_crv_rec.person_id || ',' ||
2077: v_sca_crv_rec.course_cd || ',' ||
2078: v_last_teaching,

Line 2302: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

2298: WHERE course_cd = c_ps_att_rec.COURSE_CD
2299: AND person_id = c_ps_att_rec.PERSON_ID;
2300: l_rowid VARCHAR2(25);
2301: l_pk NUMBER(15);
2302: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
2303: BEGIN
2304:
2305:
2306:

Line 2359: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

2355: X_EMPLMNT_CATEGORY_CODE => null);
2356: END;-- End for Update Process
2357: ELSE -- If Cursor%NOTFOUND
2358: DECLARE
2359: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
2360: BEGIN
2361: Igs_Pe_Typ_Instances_Pkg.insert_row(
2362: X_ROWID =>l_rowid,
2363: X_PERSON_ID => c_ps_att_rec.PERSON_ID,

Line 2426: IGS_GE_GEN_003.set_org_id(p_org_id);

2422: gv_other_detail VARCHAR2(255);
2423:
2424: BEGIN
2425: retcode := 0;
2426: IGS_GE_GEN_003.set_org_id(p_org_id);
2427: DECLARE
2428: v_creation_dt DATE;
2429: v_updates_done NUMBER;
2430: v_message_name VARCHAR2(30);

Line 2735: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

2731: WHERE course_cd = c_enps_att_rec.COURSE_CD
2732: AND person_id = c_enps_att_rec.PERSON_ID;
2733: l_rowid VARCHAR2(25);
2734: l_pk NUMBER(15);
2735: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
2736:
2737: BEGIN
2738:
2739:

Line 2792: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

2788: ELSE -- If Cursor%NOTFOUND
2789:
2790: DECLARE
2791:
2792: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
2793: BEGIN
2794: Igs_Pe_Typ_Instances_Pkg.insert_row(
2795: X_ROWID =>l_rowid,
2796: X_PERSON_ID => c_enps_att_rec.PERSON_ID,

Line 2877: Igs_Ge_Gen_003.genp_ins_log(

2873: -- on a nightly basis to pick up statuses which
2874: -- should be re-calculated.
2875: -- Create a system log on the database
2876:
2877: Igs_Ge_Gen_003.genp_ins_log(
2878: 'SCA-ST-UPD',
2879: NULL,
2880: v_creation_dt);
2881: -- commit the changes made

Line 2910: Igs_Ge_Gen_003.genp_ins_log_entry(

2906: v_log_text := FND_MESSAGE.GET;
2907: FND_FILE.PUT_LINE(FND_FILE.LOG,v_log_text);
2908:
2909:
2910: Igs_Ge_Gen_003.genp_ins_log_entry(
2911: 'SCA-ST-UPD',
2912: v_creation_dt,
2913: 'INTERMIT',
2914: NULL,

Line 2962: Igs_Ge_Gen_003.genp_ins_log_entry(

2958: FND_MESSAGE.SET_TOKEN('UPDTDONE',TO_CHAR(v_updates_done));
2959: v_log_text := FND_MESSAGE.GET;
2960: FND_FILE.PUT_LINE(FND_FILE.LOG,v_log_text);
2961:
2962: Igs_Ge_Gen_003.genp_ins_log_entry(
2963: 'SCA-ST-UPD',
2964: v_creation_dt,
2965: 'NONINTERMIT',
2966: NULL,

Line 2994: Igs_Ge_Gen_003.genp_ins_log_entry(

2990: FND_MESSAGE.SET_TOKEN('UPDTDONE',TO_CHAR(v_updates_done));
2991: v_log_text := FND_MESSAGE.GET;
2992: FND_FILE.PUT_LINE(FND_FILE.LOG,v_log_text);
2993:
2994: Igs_Ge_Gen_003.genp_ins_log_entry(
2995: 'SCA-ST-UPD',
2996: v_creation_dt,
2997: 'INACTIVE',
2998: NULL,

Line 3025: Igs_Ge_Gen_003.genp_ins_log_entry(

3021: FND_MESSAGE.SET_TOKEN('UPDTDONE',TO_CHAR(v_updates_done));
3022: v_log_text := FND_MESSAGE.GET;
3023: FND_FILE.PUT_LINE(FND_FILE.LOG,v_log_text);
3024:
3025: Igs_Ge_Gen_003.genp_ins_log_entry(
3026: 'SCA-ST-UPD',
3027: v_creation_dt,
3028: 'ENROLLED',
3029: NULL,

Line 3049: Igs_Ge_Gen_003.genp_ins_log_entry(

3045: v_sca_future.commencement_dt,
3046: v_sca_future.discontinued_dt,
3047: v_sca_future.discontinuation_reason_cd,
3048: v_message_name) = FALSE) THEN
3049: Igs_Ge_Gen_003.genp_ins_log_entry(
3050: 'SCA-ST-UPD',
3051: v_creation_dt,
3052: 'DISCONT|' ||
3053: TO_CHAR(v_sca_future.person_id) ||'|'||

Line 3060: Igs_Ge_Gen_003.genp_ins_log_entry(

3056: v_sca_future.discontinuation_reason_cd,
3057: v_message_name,
3058: NULL);
3059: ELSE
3060: Igs_Ge_Gen_003.genp_ins_log_entry(
3061: 'SCA-ST-UPD',
3062: v_creation_dt,
3063: 'DISCONT|' ||
3064: TO_CHAR(v_sca_future.person_id) ||'|'||

Line 3224: Igs_Ge_Gen_003.genp_ins_log_entry(

3220: ) = TRUE THEN
3221: v_validation_error := FALSE;
3222: IF (v_sua_sca_rec.enrolled_cutoff_date IS NOT NULL AND
3223: SYSDATE > v_sua_sca_rec.enrolled_cutoff_date) THEN
3224: Igs_Ge_Gen_003.genp_ins_log_entry(
3225: p_s_log_type,
3226: p_creation_dt,
3227: cst_unit
3228: ||','||cst_attdate

Line 3253: Igs_Ge_Gen_003.genp_ins_log_entry (

3249: v_sua_sca_rec.unit_class,
3250: v_sua_sca_rec.enrolled_dt,
3251: v_fail_type,
3252: v_message_name) = FALSE THEN
3253: Igs_Ge_Gen_003.genp_ins_log_entry (
3254: p_s_log_type,
3255: p_creation_dt,
3256: cst_unit
3257: ||','||cst_attvalid

Line 3361: Igs_Ge_Gen_003.genp_ins_log_entry (

3357: x_core_indicator_code => c_assu_rec.core_indicator_code
3358: );
3359: END LOOP;
3360: END;
3361: Igs_Ge_Gen_003.genp_ins_log_entry (
3362: p_s_log_type,
3363: p_creation_dt,
3364: cst_unit
3365: ||','||cst_changed

Line 3517: Igs_Ge_Gen_003.genp_ins_log_entry(

3513: lv_rule_failed
3514: ) = FALSE THEN
3515: IF (v_sua_rec.invalid_cutoff_date IS NOT NULL AND
3516: SYSDATE > v_sua_rec.invalid_cutoff_date) THEN
3517: Igs_Ge_Gen_003.genp_ins_log_entry(
3518: p_s_log_type,
3519: p_creation_dt,
3520: cst_unit
3521: ||','||cst_attdate

Line 3632: Igs_Ge_Gen_003.genp_ins_log_entry (

3628: X_CORE_INDICATOR_CODE => c_suatt_rec.core_indicator_code
3629: );
3630: END LOOP;
3631: END;
3632: Igs_Ge_Gen_003.genp_ins_log_entry (
3633: p_s_log_type,
3634: p_creation_dt,
3635: cst_unit
3636: ||','||cst_changed