APPS.FUN_OPEN_INTERFACE_PKG dependencies on FUN_INTERFACE_HEADERS

Line 291: l_recipient_id_per_name fun_interface_headers.recipient_id%type;

287: p_to_le_id IN OUT NOCOPY NUMBER
288:
289: ) IS
290:
291: l_recipient_id_per_name fun_interface_headers.recipient_id%type;
292: l_To_Le_id_per_name fun_interface_headers.to_le_id%type;
293: l_To_Le_id_per_recipient_id fun_interface_headers.to_le_id%type;
294: l_To_Ledger_id_per_le fun_interface_headers.to_ledger_id%type;
295:

Line 292: l_To_Le_id_per_name fun_interface_headers.to_le_id%type;

288:
289: ) IS
290:
291: l_recipient_id_per_name fun_interface_headers.recipient_id%type;
292: l_To_Le_id_per_name fun_interface_headers.to_le_id%type;
293: l_To_Le_id_per_recipient_id fun_interface_headers.to_le_id%type;
294: l_To_Ledger_id_per_le fun_interface_headers.to_ledger_id%type;
295:
296: Cursor c_reci_id_per_name(l_recipient_name IN VARCHAR2) IS

Line 293: l_To_Le_id_per_recipient_id fun_interface_headers.to_le_id%type;

289: ) IS
290:
291: l_recipient_id_per_name fun_interface_headers.recipient_id%type;
292: l_To_Le_id_per_name fun_interface_headers.to_le_id%type;
293: l_To_Le_id_per_recipient_id fun_interface_headers.to_le_id%type;
294: l_To_Ledger_id_per_le fun_interface_headers.to_ledger_id%type;
295:
296: Cursor c_reci_id_per_name(l_recipient_name IN VARCHAR2) IS
297: SELECT p.party_id

Line 294: l_To_Ledger_id_per_le fun_interface_headers.to_ledger_id%type;

290:
291: l_recipient_id_per_name fun_interface_headers.recipient_id%type;
292: l_To_Le_id_per_name fun_interface_headers.to_le_id%type;
293: l_To_Le_id_per_recipient_id fun_interface_headers.to_le_id%type;
294: l_To_Ledger_id_per_le fun_interface_headers.to_ledger_id%type;
295:
296: Cursor c_reci_id_per_name(l_recipient_name IN VARCHAR2) IS
297: SELECT p.party_id
298: FROM hz_parties p

Line 453: Select * from fun_interface_headers

449: WHERE source = p_source
450: AND group_id = p_group_id;
451:
452: Cursor c_head(l_batch_id IN NUMBER) is
453: Select * from fun_interface_headers
454: Where batch_id = l_batch_id;
455:
456: Cursor c_dist_lines(l_trx_id IN NUMBER) is
457: Select * from fun_interface_dist_lines

Line 470: Curr_head fun_interface_headers%rowtype;

466: from fun_trx_types_vl
467: where trx_type_id = c_trx_type_id;
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);

Line 637: FROM fun_interface_headers

633:
634: --calculate running total for batch from headers
635: SELECT nvl(sum(init_amount_dr),0), nvl(sum(init_amount_cr),0)
636: INTO l_running_total_dr, l_running_total_cr
637: FROM fun_interface_headers
638: WHERE batch_id = curr_batch.batch_id;
639:
640: l_batch_rec.running_total_dr := l_running_total_dr;
641: l_batch_rec.running_total_cr := l_running_total_cr;

Line 991: Trx_id in (select trx_id from fun_interface_headers where

987:
988: BEGIN
989:
990: Delete from fun_interface_dist_lines 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

Line 999: Delete from fun_interface_headers where

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
1000: Batch_id in (select batch_id from fun_interface_batches where
1001: source = p_source and group_id = p_group_id and import_status_code = 'A');
1002:
1003: Delete from fun_interface_batches where