DBA Data[Home] [Help]

APPS.FUN_TRX_PVT_W dependencies on FUN_TRX_PVT

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 4: procedure rosetta_table_copy_in_p5(t out nocopy fun_trx_pvt.batch_tbl_type, a0 JTF_NUMBER_TABLE

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
7: , a3 JTF_NUMBER_TABLE
8: , a4 JTF_NUMBER_TABLE

Line 55: procedure rosetta_table_copy_out_p5(t fun_trx_pvt.batch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

51: end loop;
52: end if;
53: end if;
54: end rosetta_table_copy_in_p5;
55: procedure rosetta_table_copy_out_p5(t fun_trx_pvt.batch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
56: , a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_NUMBER_TABLE
59: , a4 out nocopy JTF_NUMBER_TABLE

Line 159: procedure rosetta_table_copy_in_p6(t out nocopy fun_trx_pvt.trx_tbl_type, a0 JTF_NUMBER_TABLE

155: end if;
156: end if;
157: end rosetta_table_copy_out_p5;
158:
159: procedure rosetta_table_copy_in_p6(t out nocopy fun_trx_pvt.trx_tbl_type, a0 JTF_NUMBER_TABLE
160: , a1 JTF_NUMBER_TABLE
161: , a2 JTF_NUMBER_TABLE
162: , a3 JTF_NUMBER_TABLE
163: , a4 JTF_NUMBER_TABLE

Line 220: procedure rosetta_table_copy_out_p6(t fun_trx_pvt.trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

216: end loop;
217: end if;
218: end if;
219: end rosetta_table_copy_in_p6;
220: procedure rosetta_table_copy_out_p6(t fun_trx_pvt.trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
221: , a1 out nocopy JTF_NUMBER_TABLE
222: , a2 out nocopy JTF_NUMBER_TABLE
223: , a3 out nocopy JTF_NUMBER_TABLE
224: , a4 out nocopy JTF_NUMBER_TABLE

Line 349: procedure rosetta_table_copy_in_p7(t out nocopy fun_trx_pvt.line_tbl_type, a0 JTF_NUMBER_TABLE

345: end if;
346: end if;
347: end rosetta_table_copy_out_p6;
348:
349: procedure rosetta_table_copy_in_p7(t out nocopy fun_trx_pvt.line_tbl_type, a0 JTF_NUMBER_TABLE
350: , a1 JTF_NUMBER_TABLE
351: , a2 JTF_NUMBER_TABLE
352: , a3 JTF_VARCHAR2_TABLE_100
353: , a4 JTF_NUMBER_TABLE

Line 382: procedure rosetta_table_copy_out_p7(t fun_trx_pvt.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

378: end loop;
379: end if;
380: end if;
381: end rosetta_table_copy_in_p7;
382: procedure rosetta_table_copy_out_p7(t fun_trx_pvt.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
383: , a1 out nocopy JTF_NUMBER_TABLE
384: , a2 out nocopy JTF_NUMBER_TABLE
385: , a3 out nocopy JTF_VARCHAR2_TABLE_100
386: , a4 out nocopy JTF_NUMBER_TABLE

Line 441: procedure rosetta_table_copy_in_p8(t out nocopy fun_trx_pvt.init_dist_tbl_type, a0 JTF_NUMBER_TABLE

437: end if;
438: end if;
439: end rosetta_table_copy_out_p7;
440:
441: procedure rosetta_table_copy_in_p8(t out nocopy fun_trx_pvt.init_dist_tbl_type, a0 JTF_NUMBER_TABLE
442: , a1 JTF_NUMBER_TABLE
443: , a2 JTF_NUMBER_TABLE
444: , a3 JTF_NUMBER_TABLE
445: , a4 JTF_NUMBER_TABLE

Line 472: procedure rosetta_table_copy_out_p8(t fun_trx_pvt.init_dist_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

468: end loop;
469: end if;
470: end if;
471: end rosetta_table_copy_in_p8;
472: procedure rosetta_table_copy_out_p8(t fun_trx_pvt.init_dist_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
473: , a1 out nocopy JTF_NUMBER_TABLE
474: , a2 out nocopy JTF_NUMBER_TABLE
475: , a3 out nocopy JTF_NUMBER_TABLE
476: , a4 out nocopy JTF_NUMBER_TABLE

Line 526: procedure rosetta_table_copy_in_p9(t out nocopy fun_trx_pvt.dist_line_tbl_type, a0 JTF_NUMBER_TABLE

522: end if;
523: end if;
524: end rosetta_table_copy_out_p8;
525:
526: procedure rosetta_table_copy_in_p9(t out nocopy fun_trx_pvt.dist_line_tbl_type, a0 JTF_NUMBER_TABLE
527: , a1 JTF_NUMBER_TABLE
528: , a2 JTF_NUMBER_TABLE
529: , a3 JTF_NUMBER_TABLE
530: , a4 JTF_NUMBER_TABLE

Line 567: procedure rosetta_table_copy_out_p9(t fun_trx_pvt.dist_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

563: end loop;
564: end if;
565: end if;
566: end rosetta_table_copy_in_p9;
567: procedure rosetta_table_copy_out_p9(t fun_trx_pvt.dist_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
568: , a1 out nocopy JTF_NUMBER_TABLE
569: , a2 out nocopy JTF_NUMBER_TABLE
570: , a3 out nocopy JTF_NUMBER_TABLE
571: , a4 out nocopy JTF_NUMBER_TABLE

Line 646: procedure rosetta_table_copy_in_p10(t out nocopy fun_trx_pvt.number_type, a0 JTF_NUMBER_TABLE) as

642: end if;
643: end if;
644: end rosetta_table_copy_out_p9;
645:
646: procedure rosetta_table_copy_in_p10(t out nocopy fun_trx_pvt.number_type, a0 JTF_NUMBER_TABLE) as
647: ddindx binary_integer; indx binary_integer;
648: begin
649: if a0 is not null and a0.count > 0 then
650: if a0.count > 0 then

Line 664: procedure rosetta_table_copy_out_p10(t fun_trx_pvt.number_type, a0 out nocopy JTF_NUMBER_TABLE) as

660: end loop;
661: end if;
662: end if;
663: end rosetta_table_copy_in_p10;
664: procedure rosetta_table_copy_out_p10(t fun_trx_pvt.number_type, a0 out nocopy JTF_NUMBER_TABLE) as
665: ddindx binary_integer; indx binary_integer;
666: begin
667: if t is null or t.count = 0 then
668: a0 := JTF_NUMBER_TABLE();

Line 755: ddp_batch_rec fun_trx_pvt.batch_rec_type;

751: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
752: )
753:
754: as
755: ddp_batch_rec fun_trx_pvt.batch_rec_type;
756: ddp_trx_tbl fun_trx_pvt.trx_tbl_type;
757: ddp_init_dist_tbl fun_trx_pvt.init_dist_tbl_type;
758: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
759: ddindx binary_integer; indx binary_integer;

Line 756: ddp_trx_tbl fun_trx_pvt.trx_tbl_type;

752: )
753:
754: as
755: ddp_batch_rec fun_trx_pvt.batch_rec_type;
756: ddp_trx_tbl fun_trx_pvt.trx_tbl_type;
757: ddp_init_dist_tbl fun_trx_pvt.init_dist_tbl_type;
758: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
759: ddindx binary_integer; indx binary_integer;
760: begin

Line 757: ddp_init_dist_tbl fun_trx_pvt.init_dist_tbl_type;

753:
754: as
755: ddp_batch_rec fun_trx_pvt.batch_rec_type;
756: ddp_trx_tbl fun_trx_pvt.trx_tbl_type;
757: ddp_init_dist_tbl fun_trx_pvt.init_dist_tbl_type;
758: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
759: ddindx binary_integer; indx binary_integer;
760: begin
761:

Line 758: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;

754: as
755: ddp_batch_rec fun_trx_pvt.batch_rec_type;
756: ddp_trx_tbl fun_trx_pvt.trx_tbl_type;
757: ddp_init_dist_tbl fun_trx_pvt.init_dist_tbl_type;
758: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
759: ddindx binary_integer; indx binary_integer;
760: begin
761:
762: -- copy data to the local IN or IN-OUT args, if any

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 836: fun_trx_pvt.init_batch_validate(p_api_version,

832: , p10_a11
833: );
834:
835: -- here's the delegated call to the old PL/SQL routine
836: fun_trx_pvt.init_batch_validate(p_api_version,
837: p_init_msg_list,
838: p_validation_level,
839: x_return_status,
840: x_msg_count,

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 969: ddp_trx_rec fun_trx_pvt.trx_rec_type;

965: , p_exchange_rate_type VARCHAR2
966: )
967:
968: as
969: ddp_trx_rec fun_trx_pvt.trx_rec_type;
970: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
971: ddindx binary_integer; indx binary_integer;
972: begin
973:

Line 970: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;

966: )
967:
968: as
969: ddp_trx_rec fun_trx_pvt.trx_rec_type;
970: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
971: ddindx binary_integer; indx binary_integer;
972: begin
973:
974: -- copy data to the local IN or IN-OUT args, if any

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 1022: fun_trx_pvt.init_trx_validate(p_api_version,

1018:
1019:
1020:
1021: -- here's the delegated call to the old PL/SQL routine
1022: fun_trx_pvt.init_trx_validate(p_api_version,
1023: p_init_msg_list,
1024: p_validation_level,
1025: x_return_status,
1026: x_msg_count,

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 1101: ddp_init_dist_rec fun_trx_pvt.init_dist_rec_type;

1097: , p8_a6 in out nocopy VARCHAR2
1098: )
1099:
1100: as
1101: ddp_init_dist_rec fun_trx_pvt.init_dist_rec_type;
1102: ddindx binary_integer; indx binary_integer;
1103: begin
1104:
1105: -- copy data to the local IN or IN-OUT args, if any

Line 1123: fun_trx_pvt.init_dist_validate(p_api_version,

1119: ddp_init_dist_rec.amount_dr := p8_a5;
1120: ddp_init_dist_rec.description := p8_a6;
1121:
1122: -- here's the delegated call to the old PL/SQL routine
1123: fun_trx_pvt.init_dist_validate(p_api_version,
1124: p_init_msg_list,
1125: p_validation_level,
1126: p_le_id,
1127: p_ledger_id,

Line 1174: ddp_dist_line_rec fun_trx_pvt.dist_line_rec_type;

1170: , p8_a11 in out nocopy VARCHAR2
1171: )
1172:
1173: as
1174: ddp_dist_line_rec fun_trx_pvt.dist_line_rec_type;
1175: ddindx binary_integer; indx binary_integer;
1176: begin
1177:
1178: -- copy data to the local IN or IN-OUT args, if any

Line 1201: fun_trx_pvt.init_ic_dist_validate(p_api_version,

1197: ddp_dist_line_rec.ccid := p8_a10;
1198: ddp_dist_line_rec.trx_number := p8_a11;
1199:
1200: -- here's the delegated call to the old PL/SQL routine
1201: fun_trx_pvt.init_ic_dist_validate(p_api_version,
1202: p_init_msg_list,
1203: p_validation_level,
1204: p_le_id,
1205: p_ledger_id,

Line 1300: ddp_batch_rec fun_trx_pvt.batch_rec_type;

1296: , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1297: )
1298:
1299: as
1300: ddp_batch_rec fun_trx_pvt.batch_rec_type;
1301: ddp_trx_tbl fun_trx_pvt.trx_tbl_type;
1302: ddp_init_dist_tbl fun_trx_pvt.init_dist_tbl_type;
1303: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
1304: ddindx binary_integer; indx binary_integer;

Line 1301: ddp_trx_tbl fun_trx_pvt.trx_tbl_type;

1297: )
1298:
1299: as
1300: ddp_batch_rec fun_trx_pvt.batch_rec_type;
1301: ddp_trx_tbl fun_trx_pvt.trx_tbl_type;
1302: ddp_init_dist_tbl fun_trx_pvt.init_dist_tbl_type;
1303: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
1304: ddindx binary_integer; indx binary_integer;
1305: begin

Line 1302: ddp_init_dist_tbl fun_trx_pvt.init_dist_tbl_type;

1298:
1299: as
1300: ddp_batch_rec fun_trx_pvt.batch_rec_type;
1301: ddp_trx_tbl fun_trx_pvt.trx_tbl_type;
1302: ddp_init_dist_tbl fun_trx_pvt.init_dist_tbl_type;
1303: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
1304: ddindx binary_integer; indx binary_integer;
1305: begin
1306:

Line 1303: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;

1299: as
1300: ddp_batch_rec fun_trx_pvt.batch_rec_type;
1301: ddp_trx_tbl fun_trx_pvt.trx_tbl_type;
1302: ddp_init_dist_tbl fun_trx_pvt.init_dist_tbl_type;
1303: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
1304: ddindx binary_integer; indx binary_integer;
1305: begin
1306:
1307: -- copy data to the local IN or IN-OUT args, if any

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 1379: fun_trx_pvt.init_generate_distributions(p_api_version,

1375: , p8_a11
1376: );
1377:
1378: -- here's the delegated call to the old PL/SQL routine
1379: fun_trx_pvt.init_generate_distributions(p_api_version,
1380: p_init_msg_list,
1381: x_return_status,
1382: x_msg_count,
1383: x_msg_data,

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 1476: ddp_trx_tbl_id fun_trx_pvt.number_type;

1472: , x_reversed_batch_id in out nocopy NUMBER
1473: )
1474:
1475: as
1476: ddp_trx_tbl_id fun_trx_pvt.number_type;
1477: ddindx binary_integer; indx binary_integer;
1478: begin
1479:
1480: -- copy data to the local IN or IN-OUT args, if any

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 1495: fun_trx_pvt.create_reverse_trx(p_api_version,

1491:
1492:
1493:
1494: -- here's the delegated call to the old PL/SQL routine
1495: fun_trx_pvt.create_reverse_trx(p_api_version,
1496: p_init_msg_list,
1497: p_commit,
1498: p_validation_level,
1499: ddp_trx_tbl_id,

Line 1582: ddp_batch_rec fun_trx_pvt.batch_rec_type;

1578: , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1579: )
1580:
1581: as
1582: ddp_batch_rec fun_trx_pvt.batch_rec_type;
1583: ddp_trx_rec fun_trx_pvt.trx_rec_type;
1584: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
1585: ddindx binary_integer; indx binary_integer;
1586: begin

Line 1583: ddp_trx_rec fun_trx_pvt.trx_rec_type;

1579: )
1580:
1581: as
1582: ddp_batch_rec fun_trx_pvt.batch_rec_type;
1583: ddp_trx_rec fun_trx_pvt.trx_rec_type;
1584: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
1585: ddindx binary_integer; indx binary_integer;
1586: begin
1587:

Line 1584: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;

1580:
1581: as
1582: ddp_batch_rec fun_trx_pvt.batch_rec_type;
1583: ddp_trx_rec fun_trx_pvt.trx_rec_type;
1584: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
1585: ddindx binary_integer; indx binary_integer;
1586: begin
1587:
1588: -- copy data to the local IN or IN-OUT args, if any

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 1651: fun_trx_pvt.recipient_validate(p_api_version,

1647: , p8_a11
1648: );
1649:
1650: -- here's the delegated call to the old PL/SQL routine
1651: fun_trx_pvt.recipient_validate(p_api_version,
1652: p_init_msg_list,
1653: p_validation_level,
1654: x_return_status,
1655: x_msg_count,

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 1784: ddp_batch_rec fun_trx_pvt.batch_rec_type;

1780: , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1781: )
1782:
1783: as
1784: ddp_batch_rec fun_trx_pvt.batch_rec_type;
1785: ddp_trx_rec fun_trx_pvt.trx_rec_type;
1786: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
1787: ddindx binary_integer; indx binary_integer;
1788: l_count Number;

Line 1785: ddp_trx_rec fun_trx_pvt.trx_rec_type;

1781: )
1782:
1783: as
1784: ddp_batch_rec fun_trx_pvt.batch_rec_type;
1785: ddp_trx_rec fun_trx_pvt.trx_rec_type;
1786: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
1787: ddindx binary_integer; indx binary_integer;
1788: l_count Number;
1789: r_count Number;

Line 1786: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;

1782:
1783: as
1784: ddp_batch_rec fun_trx_pvt.batch_rec_type;
1785: ddp_trx_rec fun_trx_pvt.trx_rec_type;
1786: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
1787: ddindx binary_integer; indx binary_integer;
1788: l_count Number;
1789: r_count Number;
1790: l_index NUMBER;

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 1854: --fun_trx_pvt.IS_MODIFIED(p_api_version,

1850: , p8_a11
1851: );
1852:
1853: -- here's the delegated call to the old PL/SQL routine
1854: --fun_trx_pvt.IS_MODIFIED(p_api_version,
1855: --p_init_msg_list,
1856: --p_validation_level,
1857: --x_return_status,
1858: --x_msg_count,

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 2047: ddp_batch_rec fun_trx_pvt.batch_rec_type;

2043: , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
2044: )
2045:
2046: as
2047: ddp_batch_rec fun_trx_pvt.batch_rec_type;
2048: ddp_trx_rec fun_trx_pvt.trx_rec_type;
2049: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
2050: ddindx binary_integer; indx binary_integer;
2051: l_count Number;

Line 2048: ddp_trx_rec fun_trx_pvt.trx_rec_type;

2044: )
2045:
2046: as
2047: ddp_batch_rec fun_trx_pvt.batch_rec_type;
2048: ddp_trx_rec fun_trx_pvt.trx_rec_type;
2049: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
2050: ddindx binary_integer; indx binary_integer;
2051: l_count Number;
2052: r_count Number;

Line 2049: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;

2045:
2046: as
2047: ddp_batch_rec fun_trx_pvt.batch_rec_type;
2048: ddp_trx_rec fun_trx_pvt.trx_rec_type;
2049: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
2050: ddindx binary_integer; indx binary_integer;
2051: l_count Number;
2052: r_count Number;
2053: l_index NUMBER;

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 2293: ddp_batch_rec fun_trx_pvt.batch_rec_type;

2289: , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
2290: )
2291:
2292: as
2293: ddp_batch_rec fun_trx_pvt.batch_rec_type;
2294: ddp_trx_rec fun_trx_pvt.trx_rec_type;
2295: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
2296: ddindx binary_integer; indx binary_integer;
2297: begin

Line 2294: ddp_trx_rec fun_trx_pvt.trx_rec_type;

2290: )
2291:
2292: as
2293: ddp_batch_rec fun_trx_pvt.batch_rec_type;
2294: ddp_trx_rec fun_trx_pvt.trx_rec_type;
2295: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
2296: ddindx binary_integer; indx binary_integer;
2297: begin
2298:

Line 2295: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;

2291:
2292: as
2293: ddp_batch_rec fun_trx_pvt.batch_rec_type;
2294: ddp_trx_rec fun_trx_pvt.trx_rec_type;
2295: ddp_dist_lines_tbl fun_trx_pvt.dist_line_tbl_type;
2296: ddindx binary_integer; indx binary_integer;
2297: begin
2298:
2299: -- copy data to the local IN or IN-OUT args, if any

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 2362: fun_trx_pvt.ini_recipient_validate(p_api_version,

2358: , p8_a11
2359: );
2360:
2361: -- here's the delegated call to the old PL/SQL routine
2362: fun_trx_pvt.ini_recipient_validate(p_api_version,
2363: p_init_msg_list,
2364: p_validation_level,
2365: x_return_status,
2366: x_msg_count,

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;