eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_OPEN_INTERFACE_PKG dependencies on FUN_INTERFACE_BATCHES

Line 42: l_initiator_id_per_name fun_interface_batches.initiator_id%type;

38: p_trx_type_id IN OUT NOCOPY NUMBER,
39: p_trx_type_code IN OUT NOCOPY VARCHAR2
40: ) IS
41:
42: l_initiator_id_per_name fun_interface_batches.initiator_id%type;
43: l_From_Le_id_per_name fun_interface_batches.from_le_id%type;
44: l_From_Le_id_per_initiator_id fun_interface_batches.from_le_id%type;
45: l_Trx_type_id_per_name fun_interface_batches.trx_type_id%type;
46: l_Trx_type_id_per_code fun_interface_batches.trx_type_id%type;

Line 43: l_From_Le_id_per_name fun_interface_batches.from_le_id%type;

39: p_trx_type_code IN OUT NOCOPY VARCHAR2
40: ) IS
41:
42: l_initiator_id_per_name fun_interface_batches.initiator_id%type;
43: l_From_Le_id_per_name fun_interface_batches.from_le_id%type;
44: l_From_Le_id_per_initiator_id fun_interface_batches.from_le_id%type;
45: l_Trx_type_id_per_name fun_interface_batches.trx_type_id%type;
46: l_Trx_type_id_per_code fun_interface_batches.trx_type_id%type;
47: l_From_Ledger_id_per_le fun_interface_batches.from_ledger_id%type;

Line 44: l_From_Le_id_per_initiator_id fun_interface_batches.from_le_id%type;

40: ) IS
41:
42: l_initiator_id_per_name fun_interface_batches.initiator_id%type;
43: l_From_Le_id_per_name fun_interface_batches.from_le_id%type;
44: l_From_Le_id_per_initiator_id fun_interface_batches.from_le_id%type;
45: l_Trx_type_id_per_name fun_interface_batches.trx_type_id%type;
46: l_Trx_type_id_per_code fun_interface_batches.trx_type_id%type;
47: l_From_Ledger_id_per_le fun_interface_batches.from_ledger_id%type;
48:

Line 45: l_Trx_type_id_per_name fun_interface_batches.trx_type_id%type;

41:
42: l_initiator_id_per_name fun_interface_batches.initiator_id%type;
43: l_From_Le_id_per_name fun_interface_batches.from_le_id%type;
44: l_From_Le_id_per_initiator_id fun_interface_batches.from_le_id%type;
45: l_Trx_type_id_per_name fun_interface_batches.trx_type_id%type;
46: l_Trx_type_id_per_code fun_interface_batches.trx_type_id%type;
47: l_From_Ledger_id_per_le fun_interface_batches.from_ledger_id%type;
48:
49: Cursor c_Init_id_per_name(l_initiator_name IN VARCHAR2) IS

Line 46: l_Trx_type_id_per_code fun_interface_batches.trx_type_id%type;

42: l_initiator_id_per_name fun_interface_batches.initiator_id%type;
43: l_From_Le_id_per_name fun_interface_batches.from_le_id%type;
44: l_From_Le_id_per_initiator_id fun_interface_batches.from_le_id%type;
45: l_Trx_type_id_per_name fun_interface_batches.trx_type_id%type;
46: l_Trx_type_id_per_code fun_interface_batches.trx_type_id%type;
47: l_From_Ledger_id_per_le fun_interface_batches.from_ledger_id%type;
48:
49: Cursor c_Init_id_per_name(l_initiator_name IN VARCHAR2) IS
50: SELECT p.party_id

Line 47: l_From_Ledger_id_per_le fun_interface_batches.from_ledger_id%type;

43: l_From_Le_id_per_name fun_interface_batches.from_le_id%type;
44: l_From_Le_id_per_initiator_id fun_interface_batches.from_le_id%type;
45: l_Trx_type_id_per_name fun_interface_batches.trx_type_id%type;
46: l_Trx_type_id_per_code fun_interface_batches.trx_type_id%type;
47: l_From_Ledger_id_per_le fun_interface_batches.from_ledger_id%type;
48:
49: Cursor c_Init_id_per_name(l_initiator_name IN VARCHAR2) IS
50: SELECT p.party_id
51: FROM hz_parties p

Line 467: Curr_batch fun_interface_batches%rowtype;

463: Select allow_invoicing_flag
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:

Line 549: from fun_interface_batches ftb

545: -- Bug: 7595873
546: /* Delete any rejections from previous failed imports*/
547: Delete from fun_interface_rejections ftr
548: where ftr.batch_id in(select ftb.batch_id
549: from fun_interface_batches ftb
550: where ftb.source = p_source
551: and ftb.group_id = p_group_id);
552:
553:

Line 586: SELECT * FROM fun_interface_batches

582: l_batch_count := 0;
583:
584: Print('Main Package ~~~'|| 'Fetch Batches');
585: FOR curr_batch in (
586: SELECT * FROM fun_interface_batches
587: WHERE source = p_source
588: AND group_id = p_group_id
589: AND batch_id = NVL(p_batch_id,batch_id)
590: AND batch_id IN(SELECT DISTINCT fib.batch_id

Line 591: FROM fun_interface_batches fib,

587: WHERE source = p_source
588: AND group_id = p_group_id
589: AND batch_id = NVL(p_batch_id,batch_id)
590: AND batch_id IN(SELECT DISTINCT fib.batch_id
591: FROM fun_interface_batches fib,
592: hz_parties hzp,
593: fnd_grants fg,
594: fnd_object_instance_sets fois,
595: hz_relationships hzr,

Line 726: Update fun_interface_batches

722: p_trx_type_name => curr_batch.trx_type_name,
723: p_trx_type_code => l_batch_rec.trx_type_code
724: );
725: Print('Main Package ~~~'||' Update the missing Attributes for a Batch in interface tables');
726: Update fun_interface_batches
727: set initiator_id=l_batch_rec.initiator_id,
728: from_le_id=l_batch_rec.from_le_id,
729: from_ledger_id=l_batch_rec.from_ledger_id,
730: trx_type_id=l_batch_rec.trx_type_id,

Line 950: UPDATE fun_interface_batches set import_status_code = Overall_Status

946: Overall_Status := 'R';
947: end if; ---- Overall Status is Accepted
948:
949: /*Set Import_status_code of Batch with Overall Status; */
950: UPDATE fun_interface_batches set import_status_code = Overall_Status
951: Where batch_id = curr_batch.batch_id;
952:
953: l_trx_tbl.delete;
954: l_init_dist_tbl.delete;

Line 1057: batch_id in (select batch_id from fun_interface_batches where

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
1061: batch_id in (select batch_id from fun_interface_batches where

Line 1061: batch_id in (select batch_id from fun_interface_batches 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
1065: Batch_id in (select batch_id from fun_interface_batches where

Line 1065: Batch_id in (select batch_id from fun_interface_batches 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
1069: source = p_source and group_id = p_group_id

Line 1068: Delete from fun_interface_batches where

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
1069: source = p_source and group_id = p_group_id
1070: and import_status_code = 'A';
1071:
1072: -- Bug: 7595873

Line 1076: from fun_interface_batches ftb

1072: -- Bug: 7595873
1073: select count(*) into l_count
1074: from fun_interface_rejections ftr
1075: where ftr.batch_id in(select ftb.batch_id
1076: from fun_interface_batches ftb
1077: where ftb.source = p_source
1078: and ftb.group_id = p_group_id);
1079:
1080: if l_count = 0 then

Line 1109: DELETE FROM fun_interface_batches

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
1111: AND import_status_code = 'R';
1112:
1113: DELETE FROM fun_interface_rejections

Line 1270: FROM fun_interface_batches

1266:
1267: --grouping by group_id
1268: FOR rec IN
1269: (SELECT DISTINCT group_id
1270: FROM fun_interface_batches
1271: WHERE source = p_source
1272: AND(decode(p_group_id, NULL, 1, group_id)) =(decode(p_group_id, NULL, 1, p_group_id))
1273: AND import_status_code = 'R')
1274: LOOP

Line 1283: FROM fun_interface_batches

1279:
1280: --grouping by the currency_code
1281: FOR rec2 IN
1282: (SELECT DISTINCT currency_code
1283: FROM fun_interface_batches
1284: WHERE group_id = rec.group_id
1285: AND import_status_code = 'R')
1286: LOOP
1287: put_starttag('CURRENCY_CODE_RECORD');

Line 1294: FROM fun_interface_batches

1290:
1291: --grouping by the Legal Entity Name
1292: FOR rec3 IN
1293: (SELECT DISTINCT from_le_name
1294: FROM fun_interface_batches
1295: WHERE group_id = rec.group_id
1296: AND currency_code = rec2.currency_code
1297: AND import_status_code = 'R')
1298: LOOP

Line 1316: FROM FUN_INTERFACE_BATCHES FIB,

1312: FIB.BATCH_DATE BATCH_DATE,
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,

Line 1371: FROM fun_interface_batches fib,

1367:
1368: --selecting teh batches to be purged.
1369: FOR rec4 IN
1370: (SELECT DISTINCT fib.batch_id
1371: FROM fun_interface_batches fib,
1372: hz_parties hzp,
1373: fnd_grants fg,
1374: fnd_object_instance_sets fois,
1375: hz_relationships hzr,