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.

[Home] [Help]

APPS.IGS_DA_TRNS_IMP dependencies on IGS_DA_RQST

Line 43: p_batch_id IN igs_da_rqst.batch_id%TYPE,

39: write_log (p_msg, 'igs.plsql.igs_da_trns_imp.adv_stnd_import');
40: END write_message;
41:
42: PROCEDURE notify_error (
43: p_batch_id IN igs_da_rqst.batch_id%TYPE,
44: p_person_id IN hz_parties.party_id%TYPE,
45: p_program_code IN igs_av_lgcy_unt_int.program_cd%TYPE,
46: p_msg IN VARCHAR2
47: )

Line 66: UPDATE igs_da_rqst

62: END IF;
63:
64: IF v_report_text IS NOT NULL
65: THEN
66: UPDATE igs_da_rqst
67: SET request_status = 'COMPLETE_ERROR'
68: WHERE batch_id = p_batch_id;
69:
70: UPDATE igs_da_req_stdnts

Line 1617: p_batch_id igs_da_rqst.batch_id%TYPE

1613: /********************************************************************
1614: Create Advanced Standing Record
1615: ********************************************************************/
1616: FUNCTION get_adv_stnd_granting_status (
1617: p_batch_id igs_da_rqst.batch_id%TYPE
1618: )
1619: RETURN igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE
1620: IS
1621: CURSOR c_ftr_val

Line 1657: p_batch_id IN igs_da_rqst.batch_id%TYPE,

1653: write_message('ERROR ' || sqlerrm);
1654: END get_adv_stnd_granting_status;
1655:
1656: FUNCTION validate_parameters (
1657: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1658: p_person_id IN igs_da_rqst.person_id%TYPE,
1659: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1660: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1661: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit

Line 1658: p_person_id IN igs_da_rqst.person_id%TYPE,

1654: END get_adv_stnd_granting_status;
1655:
1656: FUNCTION validate_parameters (
1657: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1658: p_person_id IN igs_da_rqst.person_id%TYPE,
1659: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1660: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1661: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1662: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE

Line 1748: p_batch_id IN igs_da_rqst.batch_id%TYPE,

1744: write_message('ERROR ' || sqlerrm);
1745: END validate_parameters;
1746:
1747: FUNCTION derive_unit_data (
1748: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1749: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1750: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1751: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
1752: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,

Line 1888: p_batch_id IN igs_da_rqst.batch_id%TYPE,

1884:
1885: END derive_unit_data;
1886:
1887: FUNCTION validate_adv_std_db_cons (
1888: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1889: p_person_id IN igs_pe_person.person_id%TYPE,
1890: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1891: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1892: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit

Line 1947: p_batch_id IN igs_da_rqst.batch_id%TYPE,

1943:
1944: END validate_adv_std_db_cons;
1945:
1946: FUNCTION validate_adv_stnd (
1947: p_batch_id IN igs_da_rqst.batch_id%TYPE,
1948: p_person_id IN igs_pe_person.person_id%TYPE,
1949: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
1950: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1951: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit

Line 2181: p_batch_id IN igs_da_rqst.batch_id%TYPE,

2177:
2178: END validate_adv_stnd;
2179:
2180: FUNCTION validate_std_unt_db_cons (
2181: p_batch_id IN igs_da_rqst.batch_id%TYPE,
2182: p_person_number IN igs_av_lgcy_unt_int.person_number%TYPE,
2183: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
2184: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
2185: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,

Line 2324: p_batch_id IN igs_da_rqst.batch_id%TYPE,

2320: p_person_id IN igs_pe_person.person_id%TYPE,
2321: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
2322: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2323: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
2324: p_batch_id IN igs_da_rqst.batch_id%TYPE,
2325: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
2326: )
2327: RETURN BOOLEAN
2328: IS

Line 2509: p_batch_id igs_da_rqst.batch_id%TYPE,

2505: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2506: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
2507: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
2508: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
2509: p_batch_id igs_da_rqst.batch_id%TYPE,
2510: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
2511: )
2512: RETURN BOOLEAN
2513: IS

Line 2613: p_batch_id IN igs_da_rqst.batch_id%TYPE,

2609:
2610: END create_post_unit;
2611:
2612: PROCEDURE create_adv_stnd_unit (
2613: p_batch_id IN igs_da_rqst.batch_id%TYPE,
2614: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2615: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
2616: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
2617: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,

Line 2686: FROM igs_da_rqst dr, fnd_user fdu

2682:
2683: CURSOR c_requestor
2684: IS
2685: SELECT dr.requestor_id
2686: FROM igs_da_rqst dr, fnd_user fdu
2687: WHERE dr.batch_id = p_batch_id
2688: AND dr.requestor_id = fdu.person_party_id;
2689:
2690: CURSOR c_adv_stnd_unt (

Line 3304: p_batch_id IN igs_da_rqst.batch_id%TYPE,

3300: );
3301: END create_adv_stnd_unit;
3302:
3303: PROCEDURE create_or_get_batch_id (
3304: p_batch_id IN igs_da_rqst.batch_id%TYPE,
3305: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
3306: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
3307: p_program_code IN igs_av_lgcy_unt_int.program_cd%TYPE,
3308: transaction_sub_type IN VARCHAR2,

Line 3309: p_out_batch_id OUT NOCOPY igs_da_rqst.batch_id%TYPE

3305: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
3306: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
3307: p_program_code IN igs_av_lgcy_unt_int.program_cd%TYPE,
3308: transaction_sub_type IN VARCHAR2,
3309: p_out_batch_id OUT NOCOPY igs_da_rqst.batch_id%TYPE
3310: )
3311: IS
3312: CURSOR c_template
3313: IS

Line 3328: FROM igs_da_rqst

3324:
3325: CURSOR c_requestor
3326: IS
3327: SELECT requestor_id
3328: FROM igs_da_rqst
3329: WHERE batch_id = p_batch_id;
3330:
3331: CURSOR c_stdnts_batch (p_person_id hz_parties.party_id%TYPE)
3332: IS

Line 3347: l_batch_id igs_da_rqst.batch_id%TYPE;

3343: WHERE fnd_user.customer_id = hz_parties.party_id
3344: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
3345:
3346: l_request_type_id igs_da_cnfg_req_typ.request_type_id%TYPE;
3347: l_batch_id igs_da_rqst.batch_id%TYPE;
3348: l_person_id hz_parties.party_id%TYPE;
3349: l_requestor_person_id hz_parties.party_id%TYPE;
3350: l_person_number hz_parties.party_number%TYPE;
3351: v_dummy VARCHAR2 (1);

Line 3448: write_message ('* INSERT INTO IGS_DA_RQST *');

3444: );
3445: END IF;
3446:
3447: write_message ('create_or_get_batch_id : Creating new request');
3448: write_message ('***** INSERT INTO IGS_DA_RQST *****');
3449: igs_da_rqst_pkg.insert_row (x_rowid => v_dummy_rowid,
3450: x_batch_id => l_batch_id,
3451: x_request_type_id => l_request_type_id,
3452: x_request_mode => 'MULTI',

Line 3449: igs_da_rqst_pkg.insert_row (x_rowid => v_dummy_rowid,

3445: END IF;
3446:
3447: write_message ('create_or_get_batch_id : Creating new request');
3448: write_message ('***** INSERT INTO IGS_DA_RQST *****');
3449: igs_da_rqst_pkg.insert_row (x_rowid => v_dummy_rowid,
3450: x_batch_id => l_batch_id,
3451: x_request_type_id => l_request_type_id,
3452: x_request_mode => 'MULTI',
3453: x_program_comparison_type => 'DP',

Line 3554: PROCEDURE complete_import_process (p_batch_id IN igs_da_rqst.batch_id%TYPE)

3550: );
3551: write_message('ERROR ' || sqlerrm);
3552: END create_or_get_batch_id;
3553:
3554: PROCEDURE complete_import_process (p_batch_id IN igs_da_rqst.batch_id%TYPE)
3555: AS
3556: BEGIN
3557: ecx_debug.push ('IGS_DA_TRNS_IMP.COMPLETE_IMPORT_PROCESS');
3558: write_message ( 'Entered complete_import_process p_batch_id='