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.11.12020000.2 2012/07/10 09:10:16 ninarasi ship $ */
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_p5(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_p5(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_p5(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_p5;
269: procedure rosetta_table_copy_out_p5(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_p7(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_p5;
332:
333: procedure rosetta_table_copy_in_p7(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_p7(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_p7;
354: procedure rosetta_table_copy_out_p7(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 445: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

441: , x_utiz_sql_stmt out nocopy VARCHAR2
442: )
443:
444: as
445: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
446: ddpx_currency_rec ozf_claim_accrual_pvt.currency_rec_type;
447: ddindx binary_integer; indx binary_integer;
448: begin
449:

Line 446: ddpx_currency_rec ozf_claim_accrual_pvt.currency_rec_type;

442: )
443:
444: as
445: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
446: ddpx_currency_rec ozf_claim_accrual_pvt.currency_rec_type;
447: ddindx binary_integer; indx binary_integer;
448: begin
449:
450: -- copy data to the local IN or IN-OUT args, if any

Line 518: ozf_claim_accrual_pvt.get_utiz_sql_stmt(p_api_version,

514:
515:
516:
517: -- here's the delegated call to the old PL/SQL routine
518: ozf_claim_accrual_pvt.get_utiz_sql_stmt(p_api_version,
519: p_init_msg_list,
520: p_commit,
521: p_validation_level,
522: x_return_status,

Line 589: ddp_line_util_tbl ozf_claim_accrual_pvt.line_util_tbl_type;

585: , x_error_index out nocopy NUMBER
586: )
587:
588: as
589: ddp_line_util_tbl ozf_claim_accrual_pvt.line_util_tbl_type;
590: ddindx binary_integer; indx binary_integer;
591: begin
592:
593: -- copy data to the local IN or IN-OUT args, if any

Line 601: ozf_claim_accrual_pvt_w.rosetta_table_copy_in_p1(ddp_line_util_tbl, p7_a0

597:
598:
599:
600:
601: ozf_claim_accrual_pvt_w.rosetta_table_copy_in_p1(ddp_line_util_tbl, p7_a0
602: , p7_a1
603: , p7_a2
604: , p7_a3
605: , p7_a4

Line 632: ozf_claim_accrual_pvt.update_line_util_tbl(p_api_version,

628:
629:
630:
631: -- here's the delegated call to the old PL/SQL routine
632: ozf_claim_accrual_pvt.update_line_util_tbl(p_api_version,
633: p_init_msg_list,
634: p_commit,
635: p_validation_level,
636: x_return_status,

Line 693: ddp_line_util_tbl ozf_claim_accrual_pvt.line_util_tbl_type;

689: , x_error_index out nocopy NUMBER
690: )
691:
692: as
693: ddp_line_util_tbl ozf_claim_accrual_pvt.line_util_tbl_type;
694: ddindx binary_integer; indx binary_integer;
695: begin
696:
697: -- copy data to the local IN or IN-OUT args, if any

Line 705: ozf_claim_accrual_pvt_w.rosetta_table_copy_in_p1(ddp_line_util_tbl, p7_a0

701:
702:
703:
704:
705: ozf_claim_accrual_pvt_w.rosetta_table_copy_in_p1(ddp_line_util_tbl, p7_a0
706: , p7_a1
707: , p7_a2
708: , p7_a3
709: , p7_a4

Line 736: ozf_claim_accrual_pvt.delete_line_util_tbl(p_api_version,

732:
733:
734:
735: -- here's the delegated call to the old PL/SQL routine
736: ozf_claim_accrual_pvt.delete_line_util_tbl(p_api_version,
737: p_init_msg_list,
738: p_commit,
739: p_validation_level,
740: x_return_status,

Line 788: ddx_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;

784: , p0_a25 out nocopy VARCHAR2
785: )
786:
787: as
788: ddx_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;
789: ddindx binary_integer; indx binary_integer;
790: begin
791:
792: -- copy data to the local IN or IN-OUT args, if any

Line 795: ozf_claim_accrual_pvt.init_line_util_rec(ddx_line_util_rec);

791:
792: -- copy data to the local IN or IN-OUT args, if any
793:
794: -- here's the delegated call to the old PL/SQL routine
795: ozf_claim_accrual_pvt.init_line_util_rec(ddx_line_util_rec);
796:
797: -- copy data back from the local variables to OUT or IN-OUT args, if any
798: p0_a0 := ddx_line_util_rec.claim_line_util_id;
799: p0_a1 := ddx_line_util_rec.object_version_number;

Line 881: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;

877: , p1_a25 out nocopy VARCHAR2
878: )
879:
880: as
881: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;
882: ddx_complete_rec ozf_claim_accrual_pvt.line_util_rec_type;
883: ddindx binary_integer; indx binary_integer;
884: begin
885:

Line 882: ddx_complete_rec ozf_claim_accrual_pvt.line_util_rec_type;

878: )
879:
880: as
881: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;
882: ddx_complete_rec ozf_claim_accrual_pvt.line_util_rec_type;
883: ddindx binary_integer; indx binary_integer;
884: begin
885:
886: -- copy data to the local IN or IN-OUT args, if any

Line 916: ozf_claim_accrual_pvt.complete_line_util_rec(ddp_line_util_rec,

912: ddp_line_util_rec.update_from_tbl_flag := p0_a25;
913:
914:
915: -- here's the delegated call to the old PL/SQL routine
916: ozf_claim_accrual_pvt.complete_line_util_rec(ddp_line_util_rec,
917: ddx_complete_rec);
918:
919: -- copy data back from the local variables to OUT or IN-OUT args, if any
920:

Line 1004: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

1000: , p_mode VARCHAR2
1001: )
1002:
1003: as
1004: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
1005: ddindx binary_integer; indx binary_integer;
1006: begin
1007:
1008: -- copy data to the local IN or IN-OUT args, if any

Line 1068: ozf_claim_accrual_pvt.update_group_line_util(p_api_version,

1064: ddp_funds_util_flt.created_from := p8_a42;
1065:
1066:
1067: -- here's the delegated call to the old PL/SQL routine
1068: ozf_claim_accrual_pvt.update_group_line_util(p_api_version,
1069: p_init_msg_list,
1070: p_commit,
1071: p_validation_level,
1072: x_return_status,

Line 1145: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

1141: , p_mode VARCHAR2
1142: )
1143:
1144: as
1145: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
1146: ddindx binary_integer; indx binary_integer;
1147: begin
1148:
1149: -- copy data to the local IN or IN-OUT args, if any

Line 1208: ozf_claim_accrual_pvt.delete_group_line_util(p_api_version,

1204: ddp_funds_util_flt.created_from := p7_a42;
1205:
1206:
1207: -- here's the delegated call to the old PL/SQL routine
1208: ozf_claim_accrual_pvt.delete_group_line_util(p_api_version,
1209: p_init_msg_list,
1210: p_commit,
1211: p_validation_level,
1212: x_return_status,

Line 1283: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

1279: , p8_a42 VARCHAR2
1280: )
1281:
1282: as
1283: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
1284: ddindx binary_integer; indx binary_integer;
1285: begin
1286:
1287: -- copy data to the local IN or IN-OUT args, if any

Line 1346: ozf_claim_accrual_pvt.asso_accruals_to_claim(p_api_version,

1342: ddp_funds_util_flt.claim_id := p8_a41;
1343: ddp_funds_util_flt.created_from := p8_a42;
1344:
1345: -- here's the delegated call to the old PL/SQL routine
1346: ozf_claim_accrual_pvt.asso_accruals_to_claim(p_api_version,
1347: p_init_msg_list,
1348: p_commit,
1349: p_validation_level,
1350: x_return_status,

Line 1570: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

1566: )
1567:
1568: as
1569: ddp_claim_rec ozf_claim_pvt.claim_rec_type;
1570: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
1571: ddindx binary_integer; indx binary_integer;
1572: begin
1573:
1574: -- copy data to the local IN or IN-OUT args, if any

Line 1782: ozf_claim_accrual_pvt.create_claim_for_accruals(p_api_version,

1778: ddp_funds_util_flt.created_from := p8_a42;
1779:
1780:
1781: -- here's the delegated call to the old PL/SQL routine
1782: ozf_claim_accrual_pvt.create_claim_for_accruals(p_api_version,
1783: p_init_msg_list,
1784: p_commit,
1785: p_validation_level,
1786: x_return_status,

Line 2008: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

2004: )
2005:
2006: as
2007: ddp_claim_rec ozf_claim_pvt.claim_rec_type;
2008: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
2009: ddindx binary_integer; indx binary_integer;
2010: begin
2011:
2012: -- copy data to the local IN or IN-OUT args, if any

Line 2220: ozf_claim_accrual_pvt.create_claim_existing_accruals(p_api_version,

2216: ddp_funds_util_flt.created_from := p8_a42;
2217:
2218:
2219: -- here's the delegated call to the old PL/SQL routine
2220: ozf_claim_accrual_pvt.create_claim_existing_accruals(p_api_version,
2221: p_init_msg_list,
2222: p_commit,
2223: p_validation_level,
2224: x_return_status,

Line 2447: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

2443: )
2444:
2445: as
2446: ddp_claim_rec ozf_claim_pvt.claim_rec_type;
2447: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
2448: ddindx binary_integer; indx binary_integer;
2449: begin
2450:
2451: -- copy data to the local IN or IN-OUT args, if any

Line 2660: ozf_claim_accrual_pvt.pay_claim_for_accruals(p_api_version,

2656: ddp_funds_util_flt.created_from := p9_a42;
2657:
2658:
2659: -- here's the delegated call to the old PL/SQL routine
2660: ozf_claim_accrual_pvt.pay_claim_for_accruals(p_api_version,
2661: p_init_msg_list,
2662: p_commit,
2663: p_validation_level,
2664: p_accrual_flag,

Line 2702: ddx_offer_perf_tbl ozf_claim_accrual_pvt.offer_performance_tbl_type;

2698: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
2699: )
2700:
2701: as
2702: ddx_offer_perf_tbl ozf_claim_accrual_pvt.offer_performance_tbl_type;
2703: ddindx binary_integer; indx binary_integer;
2704: begin
2705:
2706: -- copy data to the local IN or IN-OUT args, if any

Line 2714: ozf_claim_accrual_pvt.check_offer_performance(p_cust_account_id,

2710:
2711:
2712:
2713: -- here's the delegated call to the old PL/SQL routine
2714: ozf_claim_accrual_pvt.check_offer_performance(p_cust_account_id,
2715: p_offer_id,
2716: p_resale_flag,
2717: p_check_all_flag,
2718: x_performance_flag,

Line 2727: ozf_claim_accrual_pvt_w.rosetta_table_copy_out_p5(ddx_offer_perf_tbl, p5_a0

2723:
2724:
2725:
2726:
2727: ozf_claim_accrual_pvt_w.rosetta_table_copy_out_p5(ddx_offer_perf_tbl, p5_a0
2728: , p5_a1
2729: , p5_a2
2730: , p5_a3
2731: , p5_a4

Line 2752: ddx_offer_perf_tbl ozf_claim_accrual_pvt.offer_performance_tbl_type;

2748: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100
2749: )
2750:
2751: as
2752: ddx_offer_perf_tbl ozf_claim_accrual_pvt.offer_performance_tbl_type;
2753: ddindx binary_integer; indx binary_integer;
2754: begin
2755:
2756: -- copy data to the local IN or IN-OUT args, if any

Line 2760: ozf_claim_accrual_pvt.check_offer_performance_tbl(p_claim_id,

2756: -- copy data to the local IN or IN-OUT args, if any
2757:
2758:
2759: -- here's the delegated call to the old PL/SQL routine
2760: ozf_claim_accrual_pvt.check_offer_performance_tbl(p_claim_id,
2761: ddx_offer_perf_tbl);
2762:
2763: -- copy data back from the local variables to OUT or IN-OUT args, if any
2764:

Line 2765: ozf_claim_accrual_pvt_w.rosetta_table_copy_out_p5(ddx_offer_perf_tbl, p1_a0

2761: ddx_offer_perf_tbl);
2762:
2763: -- copy data back from the local variables to OUT or IN-OUT args, if any
2764:
2765: ozf_claim_accrual_pvt_w.rosetta_table_copy_out_p5(ddx_offer_perf_tbl, p1_a0
2766: , p1_a1
2767: , p1_a2
2768: , p1_a3
2769: , p1_a4

Line 2783: ddx_offer_earn_tbl ozf_claim_accrual_pvt.offer_earning_tbl_type;

2779: , p1_a1 out nocopy JTF_NUMBER_TABLE
2780: )
2781:
2782: as
2783: ddx_offer_earn_tbl ozf_claim_accrual_pvt.offer_earning_tbl_type;
2784: ddindx binary_integer; indx binary_integer;
2785: begin
2786:
2787: -- copy data to the local IN or IN-OUT args, if any

Line 2791: ozf_claim_accrual_pvt.check_offer_earning_tbl(p_claim_id,

2787: -- copy data to the local IN or IN-OUT args, if any
2788:
2789:
2790: -- here's the delegated call to the old PL/SQL routine
2791: ozf_claim_accrual_pvt.check_offer_earning_tbl(p_claim_id,
2792: ddx_offer_earn_tbl);
2793:
2794: -- copy data back from the local variables to OUT or IN-OUT args, if any
2795:

Line 2796: ozf_claim_accrual_pvt_w.rosetta_table_copy_out_p7(ddx_offer_earn_tbl, p1_a0

2792: ddx_offer_earn_tbl);
2793:
2794: -- copy data back from the local variables to OUT or IN-OUT args, if any
2795:
2796: ozf_claim_accrual_pvt_w.rosetta_table_copy_out_p7(ddx_offer_earn_tbl, p1_a0
2797: , p1_a1
2798: );
2799: end;
2800:

Line 2836: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;

2832: , p1_a5 VARCHAR2
2833: ) return number
2834:
2835: as
2836: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;
2837: ddp_currency_rec ozf_claim_accrual_pvt.currency_rec_type;
2838: ddindx binary_integer; indx binary_integer;
2839: ddrosetta_retval number;
2840: begin

Line 2837: ddp_currency_rec ozf_claim_accrual_pvt.currency_rec_type;

2833: ) return number
2834:
2835: as
2836: ddp_line_util_rec ozf_claim_accrual_pvt.line_util_rec_type;
2837: ddp_currency_rec ozf_claim_accrual_pvt.currency_rec_type;
2838: ddindx binary_integer; indx binary_integer;
2839: ddrosetta_retval number;
2840: begin
2841:

Line 2878: ddrosetta_retval := ozf_claim_accrual_pvt.calculate_fxgl_amount(ddp_line_util_rec,

2874: ddp_currency_rec.transaction_currency_code := p1_a4;
2875: ddp_currency_rec.association_currency_code := p1_a5;
2876:
2877: -- here's the delegated call to the old PL/SQL routine
2878: ddrosetta_retval := ozf_claim_accrual_pvt.calculate_fxgl_amount(ddp_line_util_rec,
2879: ddp_currency_rec);
2880:
2881: -- copy data back from the local variables to OUT or IN-OUT args, if any
2882:

Line 2942: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;

2938: , p_summary_view VARCHAR2
2939: )
2940:
2941: as
2942: ddp_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
2943: ddindx binary_integer; indx binary_integer;
2944: begin
2945:
2946: -- copy data to the local IN or IN-OUT args, if any

Line 3006: ozf_claim_accrual_pvt.accruals_association(p_api_version,

3002: ddp_funds_util_flt.created_from := p8_a42;
3003:
3004:
3005: -- here's the delegated call to the old PL/SQL routine
3006: ozf_claim_accrual_pvt.accruals_association(p_api_version,
3007: p_init_msg_list,
3008: p_commit,
3009: p_validation_level,
3010: x_return_status,

Line 3029: end ozf_claim_accrual_pvt_w;

3025:
3026:
3027: end;
3028:
3029: end ozf_claim_accrual_pvt_w;