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 451: Select * from fun_interface_headers

447:
448:
449:
450: Cursor c_head(l_batch_id IN NUMBER) is
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

Line 468: Curr_head fun_interface_headers%rowtype;

464: from fun_trx_types_vl
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);

Line 697: FROM fun_interface_headers

693:
694: --calculate running total for batch from headers
695: SELECT nvl(sum(init_amount_dr),0), nvl(sum(init_amount_cr),0)
696: INTO l_running_total_dr, l_running_total_cr
697: FROM fun_interface_headers
698: WHERE batch_id = curr_batch.batch_id;
699:
700: l_batch_rec.running_total_dr := l_running_total_dr;
701: l_batch_rec.running_total_cr := l_running_total_cr;

Line 1056: Trx_id in (select trx_id from fun_interface_headers where

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:
1060: Delete from fun_interface_batchdists where

Line 1064: Delete from fun_interface_headers where

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
1065: Batch_id in (select batch_id from fun_interface_batches where
1066: source = p_source and group_id = p_group_id and import_status_code = 'A');
1067:
1068: Delete from fun_interface_batches where

Line 1099: FROM fun_interface_headers

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)
1101: ;
1102:
1103: DELETE FROM fun_interface_batchdists

Line 1106: DELETE FROM fun_interface_headers

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;
1108:
1109: DELETE FROM fun_interface_batches
1110: WHERE batch_id = p_batch_id

Line 1317: FUN_INTERFACE_HEADERS FIH,

1313: FIH.RECIPIENT_NAME RECIPIENT_NAME,
1314: DECODE(FIH.INIT_AMOUNT_CR,NULL,0,FIH.INIT_AMOUNT_CR) INIT_AMOUNT_CR,
1315: DECODE(FIH.INIT_AMOUNT_DR,NULL,0,FIH.INIT_AMOUNT_DR) INIT_AMOUNT_DR
1316: FROM FUN_INTERFACE_BATCHES FIB,
1317: FUN_INTERFACE_HEADERS FIH,
1318: HZ_PARTIES HZP,
1319: FND_GRANTS FG,
1320: FND_OBJECT_INSTANCE_SETS FOIS,
1321: HZ_RELATIONSHIPS HZR,