DBA Data[Home] [Help]

APPS.FUN_TRX_PVT_W dependencies on FUN_TRX_PVT_W

Line 1: package body fun_trx_pvt_w as

1: package body fun_trx_pvt_w as
2: /* $Header: fun_trx_pvt_w_b.pls 120.9 2011/12/16 02:29:44 srampure ship $ */
3: l_ccid numarray;
4: procedure rosetta_table_copy_in_p5(t out nocopy fun_trx_pvt.batch_tbl_type, a0 JTF_NUMBER_TABLE
5: , a1 JTF_VARCHAR2_TABLE_100

Line 2: /* $Header: fun_trx_pvt_w_b.pls 120.9 2011/12/16 02:29:44 srampure ship $ */

1: package body fun_trx_pvt_w as
2: /* $Header: fun_trx_pvt_w_b.pls 120.9 2011/12/16 02:29:44 srampure ship $ */
3: l_ccid numarray;
4: procedure rosetta_table_copy_in_p5(t out nocopy fun_trx_pvt.batch_tbl_type, a0 JTF_NUMBER_TABLE
5: , a1 JTF_VARCHAR2_TABLE_100
6: , a2 JTF_NUMBER_TABLE

Line 788: fun_trx_pvt_w.rosetta_table_copy_in_p6(ddp_trx_tbl, p8_a0

784: ddp_batch_rec.reject_allowed := p7_a14;
785: ddp_batch_rec.from_recurring_batch := p7_a15;
786: ddp_batch_rec.automatic_proration_flag := p7_a16;
787:
788: fun_trx_pvt_w.rosetta_table_copy_in_p6(ddp_trx_tbl, p8_a0
789: , p8_a1
790: , p8_a2
791: , p8_a3
792: , p8_a4

Line 812: fun_trx_pvt_w.rosetta_table_copy_in_p8(ddp_init_dist_tbl, p9_a0

808: , p8_a20
809: , p8_a21
810: );
811:
812: fun_trx_pvt_w.rosetta_table_copy_in_p8(ddp_init_dist_tbl, p9_a0
813: , p9_a1
814: , p9_a2
815: , p9_a3
816: , p9_a4

Line 821: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p10_a0

817: , p9_a5
818: , p9_a6
819: );
820:
821: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p10_a0
822: , p10_a1
823: , p10_a2
824: , p10_a3
825: , p10_a4

Line 874: fun_trx_pvt_w.rosetta_table_copy_out_p6(ddp_trx_tbl, p8_a0

870: p7_a14 := ddp_batch_rec.reject_allowed;
871: p7_a15 := ddp_batch_rec.from_recurring_batch;
872: p7_a16 := ddp_batch_rec.automatic_proration_flag;
873:
874: fun_trx_pvt_w.rosetta_table_copy_out_p6(ddp_trx_tbl, p8_a0
875: , p8_a1
876: , p8_a2
877: , p8_a3
878: , p8_a4

Line 898: fun_trx_pvt_w.rosetta_table_copy_out_p8(ddp_init_dist_tbl, p9_a0

894: , p8_a20
895: , p8_a21
896: );
897:
898: fun_trx_pvt_w.rosetta_table_copy_out_p8(ddp_init_dist_tbl, p9_a0
899: , p9_a1
900: , p9_a2
901: , p9_a3
902: , p9_a4

Line 907: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p10_a0

903: , p9_a5
904: , p9_a6
905: );
906:
907: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p10_a0
908: , p10_a1
909: , p10_a2
910: , p10_a3
911: , p10_a4

Line 1004: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p7_a0

1000: ddp_trx_rec.recipient_instance := p6_a19;
1001: ddp_trx_rec.automatic_proration_flag := p6_a20;
1002: ddp_trx_rec.trx_number := p6_a21;
1003:
1004: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p7_a0
1005: , p7_a1
1006: , p7_a2
1007: , p7_a3
1008: , p7_a4

Line 1065: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p7_a0

1061: p6_a19 := ddp_trx_rec.recipient_instance;
1062: p6_a20 := ddp_trx_rec.automatic_proration_flag;
1063: p6_a21 := ddp_trx_rec.trx_number;
1064:
1065: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p7_a0
1066: , p7_a1
1067: , p7_a2
1068: , p7_a3
1069: , p7_a4

Line 1331: fun_trx_pvt_w.rosetta_table_copy_in_p6(ddp_trx_tbl, p6_a0

1327: ddp_batch_rec.reject_allowed := p5_a14;
1328: ddp_batch_rec.from_recurring_batch := p5_a15;
1329: ddp_batch_rec.automatic_proration_flag := p5_a16;
1330:
1331: fun_trx_pvt_w.rosetta_table_copy_in_p6(ddp_trx_tbl, p6_a0
1332: , p6_a1
1333: , p6_a2
1334: , p6_a3
1335: , p6_a4

Line 1355: fun_trx_pvt_w.rosetta_table_copy_in_p8(ddp_init_dist_tbl, p7_a0

1351: , p6_a20
1352: , p6_a21
1353: );
1354:
1355: fun_trx_pvt_w.rosetta_table_copy_in_p8(ddp_init_dist_tbl, p7_a0
1356: , p7_a1
1357: , p7_a2
1358: , p7_a3
1359: , p7_a4

Line 1364: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p8_a0

1360: , p7_a5
1361: , p7_a6
1362: );
1363:
1364: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p8_a0
1365: , p8_a1
1366: , p8_a2
1367: , p8_a3
1368: , p8_a4

Line 1413: fun_trx_pvt_w.rosetta_table_copy_out_p6(ddp_trx_tbl, p6_a0

1409: p5_a14 := ddp_batch_rec.reject_allowed;
1410: p5_a15 := ddp_batch_rec.from_recurring_batch;
1411: p5_a16 := ddp_batch_rec.automatic_proration_flag;
1412:
1413: fun_trx_pvt_w.rosetta_table_copy_out_p6(ddp_trx_tbl, p6_a0
1414: , p6_a1
1415: , p6_a2
1416: , p6_a3
1417: , p6_a4

Line 1437: fun_trx_pvt_w.rosetta_table_copy_out_p8(ddp_init_dist_tbl, p7_a0

1433: , p6_a20
1434: , p6_a21
1435: );
1436:
1437: fun_trx_pvt_w.rosetta_table_copy_out_p8(ddp_init_dist_tbl, p7_a0
1438: , p7_a1
1439: , p7_a2
1440: , p7_a3
1441: , p7_a4

Line 1446: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p8_a0

1442: , p7_a5
1443: , p7_a6
1444: );
1445:
1446: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p8_a0
1447: , p8_a1
1448: , p8_a2
1449: , p8_a3
1450: , p8_a4

Line 1485: fun_trx_pvt_w.rosetta_table_copy_in_p10(ddp_trx_tbl_id, p_trx_tbl_id);

1481:
1482:
1483:
1484:
1485: fun_trx_pvt_w.rosetta_table_copy_in_p10(ddp_trx_tbl_id, p_trx_tbl_id);
1486:
1487:
1488:
1489:

Line 1636: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p8_a0

1632: ddp_trx_rec.recipient_instance := p7_a19;
1633: ddp_trx_rec.automatic_proration_flag := p7_a20;
1634: ddp_trx_rec.trx_number := p7_a21;
1635:
1636: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p8_a0
1637: , p8_a1
1638: , p8_a2
1639: , p8_a3
1640: , p8_a4

Line 1709: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p8_a0

1705: p7_a19 := ddp_trx_rec.recipient_instance;
1706: p7_a20 := ddp_trx_rec.automatic_proration_flag;
1707: p7_a21 := ddp_trx_rec.trx_number;
1708:
1709: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p8_a0
1710: , p8_a1
1711: , p8_a2
1712: , p8_a3
1713: , p8_a4

Line 1839: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p8_a0

1835: ddp_trx_rec.recipient_instance := p7_a19;
1836: ddp_trx_rec.automatic_proration_flag := p7_a20;
1837: ddp_trx_rec.trx_number := p7_a21;
1838:
1839: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p8_a0
1840: , p8_a1
1841: , p8_a2
1842: , p8_a3
1843: , p8_a4

Line 1957: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p8_a0

1953: p7_a19 := ddp_trx_rec.recipient_instance;
1954: p7_a20 := ddp_trx_rec.automatic_proration_flag;
1955: p7_a21 := ddp_trx_rec.trx_number;
1956:
1957: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p8_a0
1958: , p8_a1
1959: , p8_a2
1960: , p8_a3
1961: , p8_a4

Line 2110: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p8_a0

2106: ddp_trx_rec.recipient_instance := p7_a19;
2107: ddp_trx_rec.automatic_proration_flag := p7_a20;
2108: ddp_trx_rec.trx_number := p7_a21;
2109:
2110: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p8_a0
2111: , p8_a1
2112: , p8_a2
2113: , p8_a3
2114: , p8_a4

Line 2156: AND 'N' = fun_trx_pvt_w.isOldDistId(dist_id);

2152: and PARTY_TYPE_FLAG='R'
2153: and DIST_TYPE_FLAG='L'
2154: and (AMOUNT_CR=ddp_dist_lines_tbl(i).amount_cr
2155: OR AMOUNT_DR=ddp_dist_lines_tbl(i).amount_dr )
2156: AND 'N' = fun_trx_pvt_w.isOldDistId(dist_id);
2157: --and DIST_ID NOT IN (l_ccid(i-1));
2158: EXCEPTION
2159: WHEN NO_DATA_FOUND THEN
2160: x_return_status :='Y';

Line 2216: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p8_a0

2212: p7_a19 := ddp_trx_rec.recipient_instance;
2213: p7_a20 := ddp_trx_rec.automatic_proration_flag;
2214: p7_a21 := ddp_trx_rec.trx_number;
2215:
2216: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p8_a0
2217: , p8_a1
2218: , p8_a2
2219: , p8_a3
2220: , p8_a4

Line 2347: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p8_a0

2343: ddp_trx_rec.recipient_instance := p7_a19;
2344: ddp_trx_rec.automatic_proration_flag := p7_a20;
2345: ddp_trx_rec.trx_number := p7_a21;
2346:
2347: fun_trx_pvt_w.rosetta_table_copy_in_p9(ddp_dist_lines_tbl, p8_a0
2348: , p8_a1
2349: , p8_a2
2350: , p8_a3
2351: , p8_a4

Line 2420: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p8_a0

2416: p7_a19 := ddp_trx_rec.recipient_instance;
2417: p7_a20 := ddp_trx_rec.automatic_proration_flag;
2418: p7_a21 := ddp_trx_rec.trx_number;
2419:
2420: fun_trx_pvt_w.rosetta_table_copy_out_p9(ddp_dist_lines_tbl, p8_a0
2421: , p8_a1
2422: , p8_a2
2423: , p8_a3
2424: , p8_a4

Line 2434: end fun_trx_pvt_w;

2430: , p8_a10
2431: , p8_a11
2432: );
2433: end;
2434: end fun_trx_pvt_w;