DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT_W dependencies on OKL_GENERATE_ACCRUALS_PVT

Line 1: package body okl_generate_accruals_pvt_w as

1: package body okl_generate_accruals_pvt_w as
2: /* $Header: OKLEACRB.pls 120.14.12010000.7 2009/12/16 09:31:58 rpillay 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 25: procedure rosetta_table_copy_in_p4(t out nocopy okl_generate_accruals_pvt.stream_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p4(t out nocopy okl_generate_accruals_pvt.stream_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_200
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE

Line 54: procedure rosetta_table_copy_out_p4(t okl_generate_accruals_pvt.stream_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

50: end loop;
51: end if;
52: end if;
53: end rosetta_table_copy_in_p4;
54: procedure rosetta_table_copy_out_p4(t okl_generate_accruals_pvt.stream_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_VARCHAR2_TABLE_200
56: , a2 out nocopy JTF_NUMBER_TABLE
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_NUMBER_TABLE

Line 103: procedure rosetta_table_copy_in_p5(t out nocopy okl_generate_accruals_pvt.acceleration_tbl_type, a0 JTF_NUMBER_TABLE

99: end if;
100: end if;
101: end rosetta_table_copy_out_p4;
102:
103: procedure rosetta_table_copy_in_p5(t out nocopy okl_generate_accruals_pvt.acceleration_tbl_type, a0 JTF_NUMBER_TABLE
104: , a1 JTF_NUMBER_TABLE
105: , a2 JTF_NUMBER_TABLE
106: , a3 JTF_DATE_TABLE
107: , a4 JTF_DATE_TABLE

Line 136: procedure rosetta_table_copy_out_p5(t okl_generate_accruals_pvt.acceleration_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

132: end loop;
133: end if;
134: end if;
135: end rosetta_table_copy_in_p5;
136: procedure rosetta_table_copy_out_p5(t okl_generate_accruals_pvt.acceleration_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
137: , a1 out nocopy JTF_NUMBER_TABLE
138: , a2 out nocopy JTF_NUMBER_TABLE
139: , a3 out nocopy JTF_DATE_TABLE
140: , a4 out nocopy JTF_DATE_TABLE

Line 218: ddrosetta_retval := okl_generate_accruals_pvt.submit_accruals(x_return_status,

214: ddp_accrual_date := rosetta_g_miss_date_in_map(p_accrual_date);
215:
216:
217: -- here's the delegated call to the old PL/SQL routine
218: ddrosetta_retval := okl_generate_accruals_pvt.submit_accruals(x_return_status,
219: x_msg_count,
220: x_msg_data,
221: p_api_version,
222: ddp_accrual_date,

Line 250: ddx_stream_tbl okl_generate_accruals_pvt.stream_tbl_type;

246: , p_accrual_rule_yn VARCHAR2
247: )
248:
249: as
250: ddx_stream_tbl okl_generate_accruals_pvt.stream_tbl_type;
251: ddp_ctr_start_date date;
252: ddp_period_end_date date;
253: ddindx binary_integer; indx binary_integer;
254: begin

Line 267: okl_generate_accruals_pvt.get_accrual_streams(x_return_status,

263: ddp_period_end_date := rosetta_g_miss_date_in_map(p_period_end_date);
264:
265:
266: -- here's the delegated call to the old PL/SQL routine
267: okl_generate_accruals_pvt.get_accrual_streams(x_return_status,
268: ddx_stream_tbl,
269: p_khr_id,
270: p_product_id,
271: ddp_ctr_start_date,

Line 277: okl_generate_accruals_pvt_w.rosetta_table_copy_out_p4(ddx_stream_tbl, p1_a0

273: p_accrual_rule_yn);
274:
275: -- copy data back from the local variables to OUT or IN-OUT args, if any
276:
277: okl_generate_accruals_pvt_w.rosetta_table_copy_out_p4(ddx_stream_tbl, p1_a0
278: , p1_a1
279: , p1_a2
280: , p1_a3
281: , p1_a4

Line 306: ddrosetta_retval := okl_generate_accruals_pvt.check_date_accrued_till(p_khr_id,

302:
303: ddp_date := rosetta_g_miss_date_in_map(p_date);
304:
305: -- here's the delegated call to the old PL/SQL routine
306: ddrosetta_retval := okl_generate_accruals_pvt.check_date_accrued_till(p_khr_id,
307: ddp_date);
308:
309: -- copy data back from the local variables to OUT or IN-OUT args, if any
310:

Line 502: ddp_catchup_rec okl_generate_accruals_pvt.accrual_rec_type;

498: , p2_a26 DATE := fnd_api.g_miss_date
499: )
500:
501: as
502: ddp_catchup_rec okl_generate_accruals_pvt.accrual_rec_type;
503: ddx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
504: ddx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
505: ddindx binary_integer; indx binary_integer;
506: begin

Line 545: okl_generate_accruals_pvt.catchup_accruals(p_api_version,

541:
542:
543:
544: -- here's the delegated call to the old PL/SQL routine
545: okl_generate_accruals_pvt.catchup_accruals(p_api_version,
546: p_init_msg_list,
547: ddp_catchup_rec,
548: x_return_status,
549: x_msg_count,

Line 905: ddp_reverse_rec okl_generate_accruals_pvt.accrual_rec_type;

901: , p2_a26 DATE := fnd_api.g_miss_date
902: )
903:
904: as
905: ddp_reverse_rec okl_generate_accruals_pvt.accrual_rec_type;
906: ddx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
907: ddx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
908: ddindx binary_integer; indx binary_integer;
909: begin

Line 948: okl_generate_accruals_pvt.reverse_accruals(p_api_version,

944:
945:
946:
947: -- here's the delegated call to the old PL/SQL routine
948: okl_generate_accruals_pvt.reverse_accruals(p_api_version,
949: p_init_msg_list,
950: ddp_reverse_rec,
951: x_return_status,
952: x_msg_count,

Line 1159: okl_generate_accruals_pvt.reverse_accruals(p_api_version,

1155: ddp_reverse_to := rosetta_g_miss_date_in_map(p_reverse_to);
1156:
1157:
1158: -- here's the delegated call to the old PL/SQL routine
1159: okl_generate_accruals_pvt.reverse_accruals(p_api_version,
1160: p_init_msg_list,
1161: x_return_status,
1162: x_msg_count,
1163: x_msg_data,

Line 1210: okl_generate_accruals_pvt.reverse_all_accruals(p_api_version,

1206:
1207:
1208:
1209: -- here's the delegated call to the old PL/SQL routine
1210: okl_generate_accruals_pvt.reverse_all_accruals(p_api_version,
1211: p_init_msg_list,
1212: p_khr_id,
1213: ddp_reverse_date,
1214: p_description,

Line 1568: ddp_reverse_rec okl_generate_accruals_pvt.accrual_rec_type;

1564: , p2_a26 DATE := fnd_api.g_miss_date
1565: )
1566:
1567: as
1568: ddp_reverse_rec okl_generate_accruals_pvt.accrual_rec_type;
1569: ddx_rev_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
1570: ddx_rev_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
1571: ddx_memo_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
1572: ddx_memo_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;

Line 1615: okl_generate_accruals_pvt.reverse_accruals(p_api_version,

1611:
1612:
1613:
1614: -- here's the delegated call to the old PL/SQL routine
1615: okl_generate_accruals_pvt.reverse_accruals(p_api_version,
1616: p_init_msg_list,
1617: ddp_reverse_rec,
1618: x_return_status,
1619: x_msg_count,

Line 1965: ddp_acceleration_rec okl_generate_accruals_pvt.acceleration_rec_type;

1961: , x_trx_number out nocopy VARCHAR2
1962: )
1963:
1964: as
1965: ddp_acceleration_rec okl_generate_accruals_pvt.acceleration_rec_type;
1966: ddindx binary_integer; indx binary_integer;
1967: begin
1968:
1969: -- copy data to the local IN or IN-OUT args, if any

Line 1986: okl_generate_accruals_pvt.accelerate_accruals(p_api_version,

1982: ddp_acceleration_rec.accelerate_from_date := rosetta_g_miss_date_in_map(p5_a7);
1983: ddp_acceleration_rec.trx_number := p5_a8;
1984:
1985: -- here's the delegated call to the old PL/SQL routine
1986: okl_generate_accruals_pvt.accelerate_accruals(p_api_version,
1987: p_init_msg_list,
1988: x_return_status,
1989: x_msg_count,
1990: x_msg_data,

Line 2025: ddp_accrual_rec okl_generate_accruals_pvt.adjust_accrual_rec_type;

2021: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
2022: )
2023:
2024: as
2025: ddp_accrual_rec okl_generate_accruals_pvt.adjust_accrual_rec_type;
2026: ddp_stream_tbl okl_generate_accruals_pvt.stream_tbl_type;
2027: ddindx binary_integer; indx binary_integer;
2028: begin
2029:

Line 2026: ddp_stream_tbl okl_generate_accruals_pvt.stream_tbl_type;

2022: )
2023:
2024: as
2025: ddp_accrual_rec okl_generate_accruals_pvt.adjust_accrual_rec_type;
2026: ddp_stream_tbl okl_generate_accruals_pvt.stream_tbl_type;
2027: ddindx binary_integer; indx binary_integer;
2028: begin
2029:
2030: -- copy data to the local IN or IN-OUT args, if any

Line 2043: okl_generate_accruals_pvt_w.rosetta_table_copy_in_p4(ddp_stream_tbl, p7_a0

2039: ddp_accrual_rec.description := p6_a2;
2040: ddp_accrual_rec.source_trx_id := rosetta_g_miss_num_map(p6_a3);
2041: ddp_accrual_rec.source_trx_type := p6_a4;
2042:
2043: okl_generate_accruals_pvt_w.rosetta_table_copy_in_p4(ddp_stream_tbl, p7_a0
2044: , p7_a1
2045: , p7_a2
2046: , p7_a3
2047: , p7_a4

Line 2052: okl_generate_accruals_pvt.adjust_accruals(p_api_version,

2048: , p7_a5
2049: );
2050:
2051: -- here's the delegated call to the old PL/SQL routine
2052: okl_generate_accruals_pvt.adjust_accruals(p_api_version,
2053: p_init_msg_list,
2054: x_return_status,
2055: x_msg_count,
2056: x_msg_data,

Line 2085: ddp_accrual_rec okl_generate_accruals_pvt.adjust_accrual_rec_type;

2081: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2082: )
2083:
2084: as
2085: ddp_accrual_rec okl_generate_accruals_pvt.adjust_accrual_rec_type;
2086: ddindx binary_integer; indx binary_integer;
2087: begin
2088:
2089: -- copy data to the local IN or IN-OUT args, if any

Line 2102: okl_generate_accruals_pvt.generate_accruals(p_api_version,

2098: ddp_accrual_rec.source_trx_id := rosetta_g_miss_num_map(p5_a3);
2099: ddp_accrual_rec.source_trx_type := p5_a4;
2100:
2101: -- here's the delegated call to the old PL/SQL routine
2102: okl_generate_accruals_pvt.generate_accruals(p_api_version,
2103: p_init_msg_list,
2104: x_return_status,
2105: x_msg_count,
2106: x_msg_data,

Line 2117: end okl_generate_accruals_pvt_w;

2113:
2114:
2115: end;
2116:
2117: end okl_generate_accruals_pvt_w;