APPS.FUN_OPEN_INTERFACE_PKG dependencies on FUN_INTERFACE_BATCHDISTS

Line 461: Select * from fun_interface_batchdists

457: Select * from fun_interface_dist_lines
458: Where trx_id = l_trx_id;
459:
460: Cursor c_batch_dist (l_batch_id IN NUMBER) is
461: Select * from fun_interface_batchdists
462: Where batch_id = l_batch_id;
463:
464: Cursor c_inv_flag(c_trx_type_id IN NUMBER ) IS
465: Select allow_invoicing_flag

Line 472: Curr_batch_dist fun_interface_batchdists%rowtype;

468:
469: Curr_batch fun_interface_batches%rowtype;
470: Curr_head fun_interface_headers%rowtype;
471: Curr_dist_line fun_interface_dist_lines%rowtype;
472: Curr_batch_dist fun_interface_batchdists%rowtype;
473:
474: Overall_status varchar2(1);
475:
476: l_return_status varchar2(1);

Line 995: Delete from fun_interface_batchdists where

991: Trx_id in (select trx_id from fun_interface_headers where
992: batch_id in (select batch_id from fun_interface_batches where
993: source = p_source and group_id = p_group_id and import_status_code = 'A')) ;
994:
995: Delete from fun_interface_batchdists where
996: batch_id in (select batch_id from fun_interface_batches where
997: source = p_source and group_id = p_group_id and import_status_code = 'A');
998:
999: Delete from fun_interface_headers where