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.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_SL_LI_ORIG_INTS

Line 125: p_import_status_type_1 igf_sl_li_orig_ints.import_status_type%TYPE,

121: g_rel_version VARCHAR2(30);
122:
123: CURSOR c_interface (cp_batch_id NUMBER,
124: cp_alternate_code VARCHAR2,
125: p_import_status_type_1 igf_sl_li_orig_ints.import_status_type%TYPE,
126: p_import_status_type_2 igf_sl_li_orig_ints.import_status_type%TYPE
127: )
128: IS
129: SELECT

Line 126: p_import_status_type_2 igf_sl_li_orig_ints.import_status_type%TYPE

122:
123: CURSOR c_interface (cp_batch_id NUMBER,
124: cp_alternate_code VARCHAR2,
125: p_import_status_type_1 igf_sl_li_orig_ints.import_status_type%TYPE,
126: p_import_status_type_2 igf_sl_li_orig_ints.import_status_type%TYPE
127: )
128: IS
129: SELECT
130: ROWID,

Line 325: igf_sl_li_orig_ints clint

321: TRIM(clint.cs2_suffix_txt) cs2_suffix_txt,
322: TRUNC(clint.cs2_years_at_address_txt) cs2_years_at_address_txt,
323: TRIM(clint.esign_src_typ_cd) esign_src_typ_cd -- FA 161 - CL 4
324: FROM
325: igf_sl_li_orig_ints clint
326: WHERE
327: clint.batch_num = cp_batch_id AND
328: clint.ci_alternate_code = cp_alternate_code AND
329: (clint.import_status_type = p_import_status_type_1 OR clint.import_status_type = p_import_status_type_2)

Line 1376: p_ssn_txt igf_sl_li_orig_ints.cs1_ssn_txt%TYPE,

1372: END set_message_and_flag;
1373:
1374:
1375: PROCEDURE validate_alt_loan_cosigner (p_cosigner_number NUMBER,
1376: p_ssn_txt igf_sl_li_orig_ints.cs1_ssn_txt%TYPE,
1377: p_citizenship_status igf_sl_li_orig_ints.cs1_citizenship_status%TYPE,
1378: p_state_txt igf_sl_li_orig_ints.cs1_state_txt%TYPE,
1379: p_drv_license_state_txt igf_sl_li_orig_ints.cs1_drv_license_state_txt%TYPE,
1380: p_signature_code_txt igf_sl_li_orig_ints.cs1_signature_code_txt%TYPE,

Line 1377: p_citizenship_status igf_sl_li_orig_ints.cs1_citizenship_status%TYPE,

1373:
1374:
1375: PROCEDURE validate_alt_loan_cosigner (p_cosigner_number NUMBER,
1376: p_ssn_txt igf_sl_li_orig_ints.cs1_ssn_txt%TYPE,
1377: p_citizenship_status igf_sl_li_orig_ints.cs1_citizenship_status%TYPE,
1378: p_state_txt igf_sl_li_orig_ints.cs1_state_txt%TYPE,
1379: p_drv_license_state_txt igf_sl_li_orig_ints.cs1_drv_license_state_txt%TYPE,
1380: p_signature_code_txt igf_sl_li_orig_ints.cs1_signature_code_txt%TYPE,
1381: p_credit_auth_code_txt igf_sl_li_orig_ints.cs1_credit_auth_code_txt%TYPE,

Line 1378: p_state_txt igf_sl_li_orig_ints.cs1_state_txt%TYPE,

1374:
1375: PROCEDURE validate_alt_loan_cosigner (p_cosigner_number NUMBER,
1376: p_ssn_txt igf_sl_li_orig_ints.cs1_ssn_txt%TYPE,
1377: p_citizenship_status igf_sl_li_orig_ints.cs1_citizenship_status%TYPE,
1378: p_state_txt igf_sl_li_orig_ints.cs1_state_txt%TYPE,
1379: p_drv_license_state_txt igf_sl_li_orig_ints.cs1_drv_license_state_txt%TYPE,
1380: p_signature_code_txt igf_sl_li_orig_ints.cs1_signature_code_txt%TYPE,
1381: p_credit_auth_code_txt igf_sl_li_orig_ints.cs1_credit_auth_code_txt%TYPE,
1382: p_elect_sig_ind_code_txt igf_sl_li_orig_ints.cs1_elect_sig_ind_code_txt%TYPE,

Line 1379: p_drv_license_state_txt igf_sl_li_orig_ints.cs1_drv_license_state_txt%TYPE,

1375: PROCEDURE validate_alt_loan_cosigner (p_cosigner_number NUMBER,
1376: p_ssn_txt igf_sl_li_orig_ints.cs1_ssn_txt%TYPE,
1377: p_citizenship_status igf_sl_li_orig_ints.cs1_citizenship_status%TYPE,
1378: p_state_txt igf_sl_li_orig_ints.cs1_state_txt%TYPE,
1379: p_drv_license_state_txt igf_sl_li_orig_ints.cs1_drv_license_state_txt%TYPE,
1380: p_signature_code_txt igf_sl_li_orig_ints.cs1_signature_code_txt%TYPE,
1381: p_credit_auth_code_txt igf_sl_li_orig_ints.cs1_credit_auth_code_txt%TYPE,
1382: p_elect_sig_ind_code_txt igf_sl_li_orig_ints.cs1_elect_sig_ind_code_txt%TYPE,
1383: p_rel_to_student_flag igf_sl_li_orig_ints.cs1_rel_to_student_flag%TYPE

Line 1380: p_signature_code_txt igf_sl_li_orig_ints.cs1_signature_code_txt%TYPE,

1376: p_ssn_txt igf_sl_li_orig_ints.cs1_ssn_txt%TYPE,
1377: p_citizenship_status igf_sl_li_orig_ints.cs1_citizenship_status%TYPE,
1378: p_state_txt igf_sl_li_orig_ints.cs1_state_txt%TYPE,
1379: p_drv_license_state_txt igf_sl_li_orig_ints.cs1_drv_license_state_txt%TYPE,
1380: p_signature_code_txt igf_sl_li_orig_ints.cs1_signature_code_txt%TYPE,
1381: p_credit_auth_code_txt igf_sl_li_orig_ints.cs1_credit_auth_code_txt%TYPE,
1382: p_elect_sig_ind_code_txt igf_sl_li_orig_ints.cs1_elect_sig_ind_code_txt%TYPE,
1383: p_rel_to_student_flag igf_sl_li_orig_ints.cs1_rel_to_student_flag%TYPE
1384: ) AS

Line 1381: p_credit_auth_code_txt igf_sl_li_orig_ints.cs1_credit_auth_code_txt%TYPE,

1377: p_citizenship_status igf_sl_li_orig_ints.cs1_citizenship_status%TYPE,
1378: p_state_txt igf_sl_li_orig_ints.cs1_state_txt%TYPE,
1379: p_drv_license_state_txt igf_sl_li_orig_ints.cs1_drv_license_state_txt%TYPE,
1380: p_signature_code_txt igf_sl_li_orig_ints.cs1_signature_code_txt%TYPE,
1381: p_credit_auth_code_txt igf_sl_li_orig_ints.cs1_credit_auth_code_txt%TYPE,
1382: p_elect_sig_ind_code_txt igf_sl_li_orig_ints.cs1_elect_sig_ind_code_txt%TYPE,
1383: p_rel_to_student_flag igf_sl_li_orig_ints.cs1_rel_to_student_flag%TYPE
1384: ) AS
1385: --

Line 1382: p_elect_sig_ind_code_txt igf_sl_li_orig_ints.cs1_elect_sig_ind_code_txt%TYPE,

1378: p_state_txt igf_sl_li_orig_ints.cs1_state_txt%TYPE,
1379: p_drv_license_state_txt igf_sl_li_orig_ints.cs1_drv_license_state_txt%TYPE,
1380: p_signature_code_txt igf_sl_li_orig_ints.cs1_signature_code_txt%TYPE,
1381: p_credit_auth_code_txt igf_sl_li_orig_ints.cs1_credit_auth_code_txt%TYPE,
1382: p_elect_sig_ind_code_txt igf_sl_li_orig_ints.cs1_elect_sig_ind_code_txt%TYPE,
1383: p_rel_to_student_flag igf_sl_li_orig_ints.cs1_rel_to_student_flag%TYPE
1384: ) AS
1385: --
1386: --

Line 1383: p_rel_to_student_flag igf_sl_li_orig_ints.cs1_rel_to_student_flag%TYPE

1379: p_drv_license_state_txt igf_sl_li_orig_ints.cs1_drv_license_state_txt%TYPE,
1380: p_signature_code_txt igf_sl_li_orig_ints.cs1_signature_code_txt%TYPE,
1381: p_credit_auth_code_txt igf_sl_li_orig_ints.cs1_credit_auth_code_txt%TYPE,
1382: p_elect_sig_ind_code_txt igf_sl_li_orig_ints.cs1_elect_sig_ind_code_txt%TYPE,
1383: p_rel_to_student_flag igf_sl_li_orig_ints.cs1_rel_to_student_flag%TYPE
1384: ) AS
1385: --
1386: --
1387: -- This procedure is used to validate the cosigner data

Line 5607: igf_sl_li_orig_ints

5603: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before update of interface table : status E');
5605: END IF;
5606: UPDATE
5607: igf_sl_li_orig_ints
5608: SET
5609: import_status_type = 'E',
5610: last_update_date = SYSDATE,
5611: last_update_login = fnd_global.login_id,

Line 5649: igf_sl_li_orig_ints

5645: END IF;
5646:
5647: DELETE
5648: FROM
5649: igf_sl_li_orig_ints
5650: WHERE
5651: ROWID = l_interface.ROWID;
5652:
5653: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 5667: igf_sl_li_orig_ints

5663: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before update of interface table : status I');
5664: END IF;
5665:
5666: UPDATE
5667: igf_sl_li_orig_ints
5668: SET
5669: import_status_type = 'I',
5670: last_update_date = SYSDATE,
5671: last_update_login = fnd_global.login_id,