APPS.FUN_OPEN_INTERFACE_PKG dependencies on FUN_INTERFACE_BATCHDISTS

Line 459: Select * from fun_interface_batchdists

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

Line 470: Curr_batch_dist fun_interface_batchdists%rowtype;

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

Line 1060: Delete from fun_interface_batchdists where

1056: Trx_id in (select trx_id from fun_interface_headers where
1057: batch_id in (select batch_id from fun_interface_batches where
1058: source = p_source and group_id = p_group_id and import_status_code = 'A')) ;
1059:
1060: Delete from fun_interface_batchdists where
1061: batch_id in (select batch_id from fun_interface_batches where
1062: source = p_source and group_id = p_group_id and import_status_code = 'A');
1063:
1064: Delete from fun_interface_headers where

Line 1103: DELETE FROM fun_interface_batchdists

1099: FROM fun_interface_headers
1100: WHERE batch_id = p_batch_id)
1101: ;
1102:
1103: DELETE FROM fun_interface_batchdists
1104: WHERE batch_id = p_batch_id;
1105:
1106: DELETE FROM fun_interface_headers
1107: WHERE batch_id = p_batch_id;