APPS.FUN_OPEN_INTERFACE_PKG dependencies on FUN_INTERFACE_DIST_LINES

Line 455: Select * from fun_interface_dist_lines

451: Select * from fun_interface_headers
452: Where batch_id = l_batch_id;
453:
454: Cursor c_dist_lines(l_trx_id IN NUMBER) is
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

Line 469: Curr_dist_line fun_interface_dist_lines%rowtype;

465: where trx_type_id = c_trx_type_id;
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:

Line 1055: Delete from fun_interface_dist_lines where

1051: l_count number;
1052:
1053: BEGIN
1054:
1055: Delete from fun_interface_dist_lines 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:

Line 1096: DELETE FROM fun_interface_dist_lines

1092: PROCEDURE purge_interface_tables(p_batch_id IN NUMBER) IS
1093:
1094: BEGIN
1095: -- porcedure called to purge the rejected Data only.
1096: DELETE FROM fun_interface_dist_lines
1097: WHERE trx_id IN
1098: (SELECT trx_id
1099: FROM fun_interface_headers
1100: WHERE batch_id = p_batch_id)