APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGF_SL_LI_DLOR_INTS

Line 5: p_import_status_type_1 igf_sl_li_dlor_ints.import_status_type%TYPE,

1: PACKAGE BODY IGF_SL_DL_LI_IMP_PKG AS
2: /* $Header: IGFSL20B.pls 120.6 2006/09/07 13:20:52 bvisvana ship $ */
3: CURSOR c_interface (cp_batch_id NUMBER,
4: cp_alternate_code VARCHAR2,
5: p_import_status_type_1 igf_sl_li_dlor_ints.import_status_type%TYPE,
6: p_import_status_type_2 igf_sl_li_dlor_ints.import_status_type%TYPE
7: ) IS
8: SELECT rowid,
9: batch_num batch_num ,

Line 6: p_import_status_type_2 igf_sl_li_dlor_ints.import_status_type%TYPE

2: /* $Header: IGFSL20B.pls 120.6 2006/09/07 13:20:52 bvisvana ship $ */
3: CURSOR c_interface (cp_batch_id NUMBER,
4: cp_alternate_code VARCHAR2,
5: p_import_status_type_1 igf_sl_li_dlor_ints.import_status_type%TYPE,
6: p_import_status_type_2 igf_sl_li_dlor_ints.import_status_type%TYPE
7: ) IS
8: SELECT rowid,
9: batch_num batch_num ,
10: TRIM(ci_alternate_code) ci_alternate_code ,

Line 57: FROM igf_sl_li_dlor_ints dlint

53: transaction_num transaction_num,
54: TRIM(atd_entity_id_txt) atd_entity_id_txt,
55: TRIM(rep_entity_id_txt) rep_entity_id_txt,
56: credit_status credit_status
57: FROM igf_sl_li_dlor_ints dlint
58: WHERE dlint.batch_num = cp_batch_id
59: AND dlint.ci_alternate_code = cp_alternate_code
60: AND (dlint.import_status_type = p_import_status_type_1 OR dlint.import_status_type = p_import_status_type_2);
61:

Line 3839: UPDATE igf_sl_li_dlor_ints

3835: OR p_d_status = FALSE THEN
3836: l_error_flag := FALSE;
3837: -- update the legacy interface table column import_status to 'E'
3838: l_debug_str := l_debug_str || 'Before update of interface table : status E ';
3839: UPDATE igf_sl_li_dlor_ints
3840: SET import_status_type = 'E',
3841: last_update_date = SYSDATE,
3842: last_update_login = fnd_global.login_id,
3843: request_id = fnd_global.conc_request_id,

Line 3867: FROM igf_sl_li_dlor_ints

3863:
3864: l_debug_str := l_debug_str || ' Before deleting orig interface table record ';
3865:
3866: DELETE
3867: FROM igf_sl_li_dlor_ints
3868: WHERE ROWID = l_interface.ROWID;
3869:
3870: l_debug_str := l_debug_str || ' After deleting orig interface table record ';
3871:

Line 3875: UPDATE igf_sl_li_dlor_ints

3871:
3872: ELSE
3873: -- update the legacy interface table column import_status to 'I'
3874: l_debug_str := l_debug_str || ' Before update of interface table : status I ';
3875: UPDATE igf_sl_li_dlor_ints
3876: SET import_status_type = 'I',
3877: last_update_date = SYSDATE,
3878: last_update_login = fnd_global.login_id,
3879: request_id = fnd_global.conc_request_id,