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.OZF_CLAIM_ACCRUAL_PVT_W dependencies on OZF_CLAIM_ACCRUAL_PVT

Line 1: package body ozf_claim_accrual_pvt_w as

1: package body ozf_claim_accrual_pvt_w as
2: /* $Header: ozfwcacb.pls 120.5 2006/08/11 08:04:46 azahmed noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy ozf_claim_accrual_pvt.line_util_tbl_type, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ozf_claim_accrual_pvt.line_util_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE

Line 85: procedure rosetta_table_copy_out_p1(t ozf_claim_accrual_pvt.line_util_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

81: end loop;
82: end if;
83: end if;
84: end rosetta_table_copy_in_p1;
85: procedure rosetta_table_copy_out_p1(t ozf_claim_accrual_pvt.line_util_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_DATE_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_DATE_TABLE

Line 234: procedure rosetta_table_copy_in_p4(t out nocopy ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 JTF_NUMBER_TABLE

230: end if;
231: end if;
232: end rosetta_table_copy_out_p1;
233:
234: procedure rosetta_table_copy_in_p4(t out nocopy ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 JTF_NUMBER_TABLE
235: , a1 JTF_NUMBER_TABLE
236: , a2 JTF_VARCHAR2_TABLE_100
237: , a3 JTF_VARCHAR2_TABLE_300
238: , a4 JTF_DATE_TABLE

Line 269: procedure rosetta_table_copy_out_p4(t ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

265: end loop;
266: end if;
267: end if;
268: end rosetta_table_copy_in_p4;
269: procedure rosetta_table_copy_out_p4(t ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
270: , a1 out nocopy JTF_NUMBER_TABLE
271: , a2 out nocopy JTF_VARCHAR2_TABLE_100
272: , a3 out nocopy JTF_VARCHAR2_TABLE_300
273: , a4 out nocopy JTF_DATE_TABLE

Line 333: procedure rosetta_table_copy_in_p6(t out nocopy ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 JTF_NUMBER_TABLE

329: end if;
330: end if;
331: end rosetta_table_copy_out_p4;
332:
333: procedure rosetta_table_copy_in_p6(t out nocopy ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 JTF_NUMBER_TABLE
334: , a1 JTF_NUMBER_TABLE
335: ) as
336: ddindx binary_integer; indx binary_integer;
337: begin

Line 354: procedure rosetta_table_copy_out_p6(t ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

350: end loop;
351: end if;
352: end if;
353: end rosetta_table_copy_in_p6;
354: procedure rosetta_table_copy_out_p6(t ozf_claim_accrual_pvt.offer_earning_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_NUMBER_TABLE
356: ) as
357: ddindx binary_integer; indx binary_integer;
358: begin

Line 432: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

428: , x_utiz_sql_stmt out nocopy VARCHAR2
429: )
430:
431: as
432: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
433: ddindx binary_integer; indx binary_integer;
434: begin
435:
436: -- copy data to the local IN or IN-OUT args, if any

Line 490: ozf_claim_accrual_pvt.get_utiz_sql_stmt(p_api_version,

486:
487:
488:
489: -- here's the delegated call to the old PL/SQL routine
490: ozf_claim_accrual_pvt.get_utiz_sql_stmt(p_api_version,
491: p_init_msg_list,
492: p_commit,
493: p_validation_level,
494: x_return_status,

Line 553: ddp_line_util_tbl ozf_claim_accrual_pvt.line_util_tbl_type;

549: , x_error_index out nocopy NUMBER
550: )
551:
552: as
553: ddp_line_util_tbl ozf_claim_accrual_pvt.line_util_tbl_type;
554: ddindx binary_integer; indx binary_integer;
555: begin
556:
557: -- copy data to the local IN or IN-OUT args, if any

Line 565: ozf_claim_accrual_pvt_w.rosetta_table_copy_in_p1(ddp_line_util_tbl, p7_a0

561:
562:
563:
564:
565: ozf_claim_accrual_pvt_w.rosetta_table_copy_in_p1(ddp_line_util_tbl, p7_a0
566: , p7_a1
567: , p7_a2
568: , p7_a3
569: , p7_a4

Line 596: ozf_claim_accrual_pvt.create_line_util_tbl(p_api_version,

592:
593:
594:
595: -- here's the delegated call to the old PL/SQL routine
596: ozf_claim_accrual_pvt.create_line_util_tbl(p_api_version,
597: p_init_msg_list,
598: p_commit,
599: p_validation_level,
600: x_return_status,

Line 657: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;

653: , x_line_util_id out nocopy NUMBER
654: )
655:
656: as
657: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;
658: ddindx binary_integer; indx binary_integer;
659: begin
660:
661: -- copy data to the local IN or IN-OUT args, if any

Line 699: ozf_claim_accrual_pvt.create_line_util(p_api_version,

695:
696:
697:
698: -- here's the delegated call to the old PL/SQL routine
699: ozf_claim_accrual_pvt.create_line_util(p_api_version,
700: p_init_msg_list,
701: p_commit,
702: p_validation_level,
703: x_return_status,

Line 760: ddp_line_util_tbl ozf_claim_accrual_pvt.line_util_tbl_type;

756: , x_error_index out nocopy NUMBER
757: )
758:
759: as
760: ddp_line_util_tbl ozf_claim_accrual_pvt.line_util_tbl_type;
761: ddindx binary_integer; indx binary_integer;
762: begin
763:
764: -- copy data to the local IN or IN-OUT args, if any

Line 772: ozf_claim_accrual_pvt_w.rosetta_table_copy_in_p1(ddp_line_util_tbl, p7_a0

768:
769:
770:
771:
772: ozf_claim_accrual_pvt_w.rosetta_table_copy_in_p1(ddp_line_util_tbl, p7_a0
773: , p7_a1
774: , p7_a2
775: , p7_a3
776: , p7_a4

Line 803: ozf_claim_accrual_pvt.update_line_util_tbl(p_api_version,

799:
800:
801:
802: -- here's the delegated call to the old PL/SQL routine
803: ozf_claim_accrual_pvt.update_line_util_tbl(p_api_version,
804: p_init_msg_list,
805: p_commit,
806: p_validation_level,
807: x_return_status,

Line 864: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;

860: , x_object_version out nocopy NUMBER
861: )
862:
863: as
864: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;
865: ddindx binary_integer; indx binary_integer;
866: begin
867:
868: -- copy data to the local IN or IN-OUT args, if any

Line 906: ozf_claim_accrual_pvt.update_line_util(p_api_version,

902:
903:
904:
905: -- here's the delegated call to the old PL/SQL routine
906: ozf_claim_accrual_pvt.update_line_util(p_api_version,
907: p_init_msg_list,
908: p_commit,
909: p_validation_level,
910: x_return_status,

Line 967: ddp_line_util_tbl ozf_claim_accrual_pvt.line_util_tbl_type;

963: , x_error_index out nocopy NUMBER
964: )
965:
966: as
967: ddp_line_util_tbl ozf_claim_accrual_pvt.line_util_tbl_type;
968: ddindx binary_integer; indx binary_integer;
969: begin
970:
971: -- copy data to the local IN or IN-OUT args, if any

Line 979: ozf_claim_accrual_pvt_w.rosetta_table_copy_in_p1(ddp_line_util_tbl, p7_a0

975:
976:
977:
978:
979: ozf_claim_accrual_pvt_w.rosetta_table_copy_in_p1(ddp_line_util_tbl, p7_a0
980: , p7_a1
981: , p7_a2
982: , p7_a3
983: , p7_a4

Line 1010: ozf_claim_accrual_pvt.delete_line_util_tbl(p_api_version,

1006:
1007:
1008:
1009: -- here's the delegated call to the old PL/SQL routine
1010: ozf_claim_accrual_pvt.delete_line_util_tbl(p_api_version,
1011: p_init_msg_list,
1012: p_commit,
1013: p_validation_level,
1014: x_return_status,

Line 1062: ddx_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;

1058: , p0_a25 out nocopy VARCHAR2
1059: )
1060:
1061: as
1062: ddx_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;
1063: ddindx binary_integer; indx binary_integer;
1064: begin
1065:
1066: -- copy data to the local IN or IN-OUT args, if any

Line 1069: ozf_claim_accrual_pvt.init_line_util_rec(ddx_line_util_rec);

1065:
1066: -- copy data to the local IN or IN-OUT args, if any
1067:
1068: -- here's the delegated call to the old PL/SQL routine
1069: ozf_claim_accrual_pvt.init_line_util_rec(ddx_line_util_rec);
1070:
1071: -- copy data back from the local variables to OUT or IN-OUT args, if any
1072: p0_a0 := ddx_line_util_rec.claim_line_util_id;
1073: p0_a1 := ddx_line_util_rec.object_version_number;

Line 1155: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;

1151: , p1_a25 out nocopy VARCHAR2
1152: )
1153:
1154: as
1155: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;
1156: ddx_complete_rec ozf_claim_accrual_pvt.line_util_rec_type;
1157: ddindx binary_integer; indx binary_integer;
1158: begin
1159:

Line 1156: ddx_complete_rec ozf_claim_accrual_pvt.line_util_rec_type;

1152: )
1153:
1154: as
1155: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;
1156: ddx_complete_rec ozf_claim_accrual_pvt.line_util_rec_type;
1157: ddindx binary_integer; indx binary_integer;
1158: begin
1159:
1160: -- copy data to the local IN or IN-OUT args, if any

Line 1190: ozf_claim_accrual_pvt.complete_line_util_rec(ddp_line_util_rec,

1186: ddp_line_util_rec.update_from_tbl_flag := p0_a25;
1187:
1188:
1189: -- here's the delegated call to the old PL/SQL routine
1190: ozf_claim_accrual_pvt.complete_line_util_rec(ddp_line_util_rec,
1191: ddx_complete_rec);
1192:
1193: -- copy data back from the local variables to OUT or IN-OUT args, if any
1194:

Line 1270: ddp_fund_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

1266: , p_mode VARCHAR2
1267: )
1268:
1269: as
1270: ddp_fund_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
1271: ddindx binary_integer; indx binary_integer;
1272: begin
1273:
1274: -- copy data to the local IN or IN-OUT args, if any

Line 1326: ozf_claim_accrual_pvt.create_group_line_util(p_api_version,

1322: ddp_fund_util_flt.utiz_currency_code := p7_a35;
1323:
1324:
1325: -- here's the delegated call to the old PL/SQL routine
1326: ozf_claim_accrual_pvt.create_group_line_util(p_api_version,
1327: p_init_msg_list,
1328: p_commit,
1329: p_validation_level,
1330: x_return_status,

Line 1395: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

1391: , p_mode VARCHAR2
1392: )
1393:
1394: as
1395: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
1396: ddindx binary_integer; indx binary_integer;
1397: begin
1398:
1399: -- copy data to the local IN or IN-OUT args, if any

Line 1452: ozf_claim_accrual_pvt.update_group_line_util(p_api_version,

1448: ddp_funds_util_flt.utiz_currency_code := p8_a35;
1449:
1450:
1451: -- here's the delegated call to the old PL/SQL routine
1452: ozf_claim_accrual_pvt.update_group_line_util(p_api_version,
1453: p_init_msg_list,
1454: p_commit,
1455: p_validation_level,
1456: x_return_status,

Line 1522: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

1518: , p_mode VARCHAR2
1519: )
1520:
1521: as
1522: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
1523: ddindx binary_integer; indx binary_integer;
1524: begin
1525:
1526: -- copy data to the local IN or IN-OUT args, if any

Line 1578: ozf_claim_accrual_pvt.delete_group_line_util(p_api_version,

1574: ddp_funds_util_flt.utiz_currency_code := p7_a35;
1575:
1576:
1577: -- here's the delegated call to the old PL/SQL routine
1578: ozf_claim_accrual_pvt.delete_group_line_util(p_api_version,
1579: p_init_msg_list,
1580: p_commit,
1581: p_validation_level,
1582: x_return_status,

Line 1646: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

1642: , p8_a35 VARCHAR2
1643: )
1644:
1645: as
1646: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
1647: ddindx binary_integer; indx binary_integer;
1648: begin
1649:
1650: -- copy data to the local IN or IN-OUT args, if any

Line 1702: ozf_claim_accrual_pvt.asso_accruals_to_claim(p_api_version,

1698: ddp_funds_util_flt.offer_payment_method := p8_a34;
1699: ddp_funds_util_flt.utiz_currency_code := p8_a35;
1700:
1701: -- here's the delegated call to the old PL/SQL routine
1702: ozf_claim_accrual_pvt.asso_accruals_to_claim(p_api_version,
1703: p_init_msg_list,
1704: p_commit,
1705: p_validation_level,
1706: x_return_status,

Line 1912: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

1908: )
1909:
1910: as
1911: ddp_claim_rec ozf_claim_pvt.claim_rec_type;
1912: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
1913: ddindx binary_integer; indx binary_integer;
1914: begin
1915:
1916: -- copy data to the local IN or IN-OUT args, if any

Line 2110: ozf_claim_accrual_pvt.create_claim_for_accruals(p_api_version,

2106: ddp_funds_util_flt.utiz_currency_code := p8_a35;
2107:
2108:
2109: -- here's the delegated call to the old PL/SQL routine
2110: ozf_claim_accrual_pvt.create_claim_for_accruals(p_api_version,
2111: p_init_msg_list,
2112: p_commit,
2113: p_validation_level,
2114: x_return_status,

Line 2322: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

2318: )
2319:
2320: as
2321: ddp_claim_rec ozf_claim_pvt.claim_rec_type;
2322: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
2323: ddindx binary_integer; indx binary_integer;
2324: begin
2325:
2326: -- copy data to the local IN or IN-OUT args, if any

Line 2520: ozf_claim_accrual_pvt.pay_claim_for_accruals(p_api_version,

2516: ddp_funds_util_flt.utiz_currency_code := p8_a35;
2517:
2518:
2519: -- here's the delegated call to the old PL/SQL routine
2520: ozf_claim_accrual_pvt.pay_claim_for_accruals(p_api_version,
2521: p_init_msg_list,
2522: p_commit,
2523: p_validation_level,
2524: x_return_status,

Line 2560: ddx_offer_perf_tbl ozf_claim_accrual_pvt.offer_performance_tbl_type;

2556: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
2557: )
2558:
2559: as
2560: ddx_offer_perf_tbl ozf_claim_accrual_pvt.offer_performance_tbl_type;
2561: ddindx binary_integer; indx binary_integer;
2562: begin
2563:
2564: -- copy data to the local IN or IN-OUT args, if any

Line 2572: ozf_claim_accrual_pvt.check_offer_performance(p_cust_account_id,

2568:
2569:
2570:
2571: -- here's the delegated call to the old PL/SQL routine
2572: ozf_claim_accrual_pvt.check_offer_performance(p_cust_account_id,
2573: p_offer_id,
2574: p_resale_flag,
2575: p_check_all_flag,
2576: x_performance_flag,

Line 2585: ozf_claim_accrual_pvt_w.rosetta_table_copy_out_p4(ddx_offer_perf_tbl, p5_a0

2581:
2582:
2583:
2584:
2585: ozf_claim_accrual_pvt_w.rosetta_table_copy_out_p4(ddx_offer_perf_tbl, p5_a0
2586: , p5_a1
2587: , p5_a2
2588: , p5_a3
2589: , p5_a4

Line 2610: ddx_offer_perf_tbl ozf_claim_accrual_pvt.offer_performance_tbl_type;

2606: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100
2607: )
2608:
2609: as
2610: ddx_offer_perf_tbl ozf_claim_accrual_pvt.offer_performance_tbl_type;
2611: ddindx binary_integer; indx binary_integer;
2612: begin
2613:
2614: -- copy data to the local IN or IN-OUT args, if any

Line 2618: ozf_claim_accrual_pvt.check_offer_performance_tbl(p_claim_id,

2614: -- copy data to the local IN or IN-OUT args, if any
2615:
2616:
2617: -- here's the delegated call to the old PL/SQL routine
2618: ozf_claim_accrual_pvt.check_offer_performance_tbl(p_claim_id,
2619: ddx_offer_perf_tbl);
2620:
2621: -- copy data back from the local variables to OUT or IN-OUT args, if any
2622:

Line 2623: ozf_claim_accrual_pvt_w.rosetta_table_copy_out_p4(ddx_offer_perf_tbl, p1_a0

2619: ddx_offer_perf_tbl);
2620:
2621: -- copy data back from the local variables to OUT or IN-OUT args, if any
2622:
2623: ozf_claim_accrual_pvt_w.rosetta_table_copy_out_p4(ddx_offer_perf_tbl, p1_a0
2624: , p1_a1
2625: , p1_a2
2626: , p1_a3
2627: , p1_a4

Line 2641: ddx_offer_earn_tbl ozf_claim_accrual_pvt.offer_earning_tbl_type;

2637: , p1_a1 out nocopy JTF_NUMBER_TABLE
2638: )
2639:
2640: as
2641: ddx_offer_earn_tbl ozf_claim_accrual_pvt.offer_earning_tbl_type;
2642: ddindx binary_integer; indx binary_integer;
2643: begin
2644:
2645: -- copy data to the local IN or IN-OUT args, if any

Line 2649: ozf_claim_accrual_pvt.check_offer_earning_tbl(p_claim_id,

2645: -- copy data to the local IN or IN-OUT args, if any
2646:
2647:
2648: -- here's the delegated call to the old PL/SQL routine
2649: ozf_claim_accrual_pvt.check_offer_earning_tbl(p_claim_id,
2650: ddx_offer_earn_tbl);
2651:
2652: -- copy data back from the local variables to OUT or IN-OUT args, if any
2653:

Line 2654: ozf_claim_accrual_pvt_w.rosetta_table_copy_out_p6(ddx_offer_earn_tbl, p1_a0

2650: ddx_offer_earn_tbl);
2651:
2652: -- copy data back from the local variables to OUT or IN-OUT args, if any
2653:
2654: ozf_claim_accrual_pvt_w.rosetta_table_copy_out_p6(ddx_offer_earn_tbl, p1_a0
2655: , p1_a1
2656: );
2657: end;
2658:

Line 2688: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;

2684: , p0_a25 VARCHAR2
2685: ) return number
2686:
2687: as
2688: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;
2689: ddindx binary_integer; indx binary_integer;
2690: ddrosetta_retval number;
2691: begin
2692:

Line 2722: ddrosetta_retval := ozf_claim_accrual_pvt.calculate_fxgl_amount(ddp_line_util_rec);

2718: ddp_line_util_rec.utilized_acctd_amount := p0_a24;
2719: ddp_line_util_rec.update_from_tbl_flag := p0_a25;
2720:
2721: -- here's the delegated call to the old PL/SQL routine
2722: ddrosetta_retval := ozf_claim_accrual_pvt.calculate_fxgl_amount(ddp_line_util_rec);
2723:
2724: -- copy data back from the local variables to OUT or IN-OUT args, if any
2725:
2726: return ddrosetta_retval;

Line 2729: end ozf_claim_accrual_pvt_w;

2725:
2726: return ddrosetta_retval;
2727: end;
2728:
2729: end ozf_claim_accrual_pvt_w;