DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_FEE_PVT_W dependencies on OKL_MAINTAIN_FEE_PVT

Line 1: package body okl_maintain_fee_pvt_w as

1: package body okl_maintain_fee_pvt_w as
2: /* $Header: OKLUFEEB.pls 120.13 2006/03/02 23:47:09 smereddy 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:

Line 22: procedure rosetta_table_copy_in_p18(t out nocopy okl_maintain_fee_pvt.fee_types_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p18(t out nocopy okl_maintain_fee_pvt.fee_types_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_200

Line 111: procedure rosetta_table_copy_out_p18(t okl_maintain_fee_pvt.fee_types_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

107: end loop;
108: end if;
109: end if;
110: end rosetta_table_copy_in_p18;
111: procedure rosetta_table_copy_out_p18(t okl_maintain_fee_pvt.fee_types_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_VARCHAR2_TABLE_300
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 310: procedure rosetta_table_copy_in_p20(t out nocopy okl_maintain_fee_pvt.passthru_dtl_tbl_type, a0 JTF_NUMBER_TABLE

306: end if;
307: end if;
308: end rosetta_table_copy_out_p18;
309:
310: procedure rosetta_table_copy_in_p20(t out nocopy okl_maintain_fee_pvt.passthru_dtl_tbl_type, a0 JTF_NUMBER_TABLE
311: , a1 JTF_NUMBER_TABLE
312: , a2 JTF_NUMBER_TABLE
313: , a3 JTF_VARCHAR2_TABLE_100
314: , a4 JTF_NUMBER_TABLE

Line 439: procedure rosetta_table_copy_out_p20(t okl_maintain_fee_pvt.passthru_dtl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

435: end loop;
436: end if;
437: end if;
438: end rosetta_table_copy_in_p20;
439: procedure rosetta_table_copy_out_p20(t okl_maintain_fee_pvt.passthru_dtl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
440: , a1 out nocopy JTF_NUMBER_TABLE
441: , a2 out nocopy JTF_NUMBER_TABLE
442: , a3 out nocopy JTF_VARCHAR2_TABLE_100
443: , a4 out nocopy JTF_NUMBER_TABLE

Line 738: procedure rosetta_table_copy_in_p22(t out nocopy okl_maintain_fee_pvt.passthru_tbl_type, a0 JTF_NUMBER_TABLE

734: end if;
735: end if;
736: end rosetta_table_copy_out_p20;
737:
738: procedure rosetta_table_copy_in_p22(t out nocopy okl_maintain_fee_pvt.passthru_tbl_type, a0 JTF_NUMBER_TABLE
739: , a1 JTF_NUMBER_TABLE
740: , a2 JTF_NUMBER_TABLE
741: , a3 JTF_NUMBER_TABLE
742: , a4 JTF_DATE_TABLE

Line 779: procedure rosetta_table_copy_out_p22(t okl_maintain_fee_pvt.passthru_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

775: end loop;
776: end if;
777: end if;
778: end rosetta_table_copy_in_p22;
779: procedure rosetta_table_copy_out_p22(t okl_maintain_fee_pvt.passthru_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
780: , a1 out nocopy JTF_NUMBER_TABLE
781: , a2 out nocopy JTF_NUMBER_TABLE
782: , a3 out nocopy JTF_NUMBER_TABLE
783: , a4 out nocopy JTF_DATE_TABLE

Line 858: procedure rosetta_table_copy_in_p24(t out nocopy okl_maintain_fee_pvt.party_tab_type, a0 JTF_NUMBER_TABLE

854: end if;
855: end if;
856: end rosetta_table_copy_out_p22;
857:
858: procedure rosetta_table_copy_in_p24(t out nocopy okl_maintain_fee_pvt.party_tab_type, a0 JTF_NUMBER_TABLE
859: , a1 JTF_VARCHAR2_TABLE_100
860: , a2 JTF_VARCHAR2_TABLE_500
861: , a3 JTF_VARCHAR2_TABLE_500
862: , a4 JTF_VARCHAR2_TABLE_500

Line 923: procedure rosetta_table_copy_out_p24(t okl_maintain_fee_pvt.party_tab_type, a0 out nocopy JTF_NUMBER_TABLE

919: end loop;
920: end if;
921: end if;
922: end rosetta_table_copy_in_p24;
923: procedure rosetta_table_copy_out_p24(t okl_maintain_fee_pvt.party_tab_type, a0 out nocopy JTF_NUMBER_TABLE
924: , a1 out nocopy JTF_VARCHAR2_TABLE_100
925: , a2 out nocopy JTF_VARCHAR2_TABLE_500
926: , a3 out nocopy JTF_VARCHAR2_TABLE_500
927: , a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 1182: ddp_passthru_dtl_rec okl_maintain_fee_pvt.passthru_dtl_rec_type;

1178: , p5_a55 NUMBER := 0-1962.0724
1179: )
1180:
1181: as
1182: ddp_passthru_dtl_rec okl_maintain_fee_pvt.passthru_dtl_rec_type;
1183: ddx_passthru_dtl_rec okl_maintain_fee_pvt.passthru_dtl_rec_type;
1184: ddindx binary_integer; indx binary_integer;
1185: begin
1186:

Line 1183: ddx_passthru_dtl_rec okl_maintain_fee_pvt.passthru_dtl_rec_type;

1179: )
1180:
1181: as
1182: ddp_passthru_dtl_rec okl_maintain_fee_pvt.passthru_dtl_rec_type;
1183: ddx_passthru_dtl_rec okl_maintain_fee_pvt.passthru_dtl_rec_type;
1184: ddindx binary_integer; indx binary_integer;
1185: begin
1186:
1187: -- copy data to the local IN or IN-OUT args, if any

Line 1252: okl_maintain_fee_pvt.create_payment_dtls(p_api_version,

1248: ddp_passthru_dtl_rec.e_processing_fee_percent := rosetta_g_miss_num_map(p5_a55);
1249:
1250:
1251: -- here's the delegated call to the old PL/SQL routine
1252: okl_maintain_fee_pvt.create_payment_dtls(p_api_version,
1253: p_init_msg_list,
1254: x_return_status,
1255: x_msg_count,
1256: x_msg_data,

Line 1357: ddp_passthru_rec okl_maintain_fee_pvt.passthru_rec_type;

1353: , p5_a11 NUMBER := 0-1962.0724
1354: )
1355:
1356: as
1357: ddp_passthru_rec okl_maintain_fee_pvt.passthru_rec_type;
1358: ddx_passthru_rec okl_maintain_fee_pvt.passthru_rec_type;
1359: ddindx binary_integer; indx binary_integer;
1360: begin
1361:

Line 1358: ddx_passthru_rec okl_maintain_fee_pvt.passthru_rec_type;

1354: )
1355:
1356: as
1357: ddp_passthru_rec okl_maintain_fee_pvt.passthru_rec_type;
1358: ddx_passthru_rec okl_maintain_fee_pvt.passthru_rec_type;
1359: ddindx binary_integer; indx binary_integer;
1360: begin
1361:
1362: -- copy data to the local IN or IN-OUT args, if any

Line 1383: okl_maintain_fee_pvt.create_payment_hdrs(p_api_version,

1379: ddp_passthru_rec.evg_stream_type_id := rosetta_g_miss_num_map(p5_a11);
1380:
1381:
1382: -- here's the delegated call to the old PL/SQL routine
1383: okl_maintain_fee_pvt.create_payment_hdrs(p_api_version,
1384: p_init_msg_list,
1385: x_return_status,
1386: x_msg_count,
1387: x_msg_data,

Line 1432: ddp_passthru_rec okl_maintain_fee_pvt.passthru_rec_type;

1428: , p5_a11 NUMBER := 0-1962.0724
1429: )
1430:
1431: as
1432: ddp_passthru_rec okl_maintain_fee_pvt.passthru_rec_type;
1433: ddindx binary_integer; indx binary_integer;
1434: begin
1435:
1436: -- copy data to the local IN or IN-OUT args, if any

Line 1456: okl_maintain_fee_pvt.delete_payment_hdrs(p_api_version,

1452: ddp_passthru_rec.base_stream_type_id := rosetta_g_miss_num_map(p5_a10);
1453: ddp_passthru_rec.evg_stream_type_id := rosetta_g_miss_num_map(p5_a11);
1454:
1455: -- here's the delegated call to the old PL/SQL routine
1456: okl_maintain_fee_pvt.delete_payment_hdrs(p_api_version,
1457: p_init_msg_list,
1458: x_return_status,
1459: x_msg_count,
1460: x_msg_data,

Line 1551: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;

1547: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1548: )
1549:
1550: as
1551: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1552: ddx_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1553: ddindx binary_integer; indx binary_integer;
1554: begin
1555:

Line 1552: ddx_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;

1548: )
1549:
1550: as
1551: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1552: ddx_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1553: ddindx binary_integer; indx binary_integer;
1554: begin
1555:
1556: -- copy data to the local IN or IN-OUT args, if any

Line 1601: okl_maintain_fee_pvt.create_fee_type(p_api_version,

1597: ddp_fee_types_rec.validate_dff_yn := p5_a35;
1598:
1599:
1600: -- here's the delegated call to the old PL/SQL routine
1601: okl_maintain_fee_pvt.create_fee_type(p_api_version,
1602: p_init_msg_list,
1603: x_return_status,
1604: x_msg_count,
1605: x_msg_data,

Line 1734: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;

1730: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1731: )
1732:
1733: as
1734: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1735: ddx_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1736: ddindx binary_integer; indx binary_integer;
1737: begin
1738:

Line 1735: ddx_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;

1731: )
1732:
1733: as
1734: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1735: ddx_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1736: ddindx binary_integer; indx binary_integer;
1737: begin
1738:
1739: -- copy data to the local IN or IN-OUT args, if any

Line 1784: okl_maintain_fee_pvt.validate_fee_type(p_api_version,

1780: ddp_fee_types_rec.validate_dff_yn := p5_a35;
1781:
1782:
1783: -- here's the delegated call to the old PL/SQL routine
1784: okl_maintain_fee_pvt.validate_fee_type(p_api_version,
1785: p_init_msg_list,
1786: x_return_status,
1787: x_msg_count,
1788: x_msg_data,

Line 1917: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;

1913: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1914: )
1915:
1916: as
1917: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1918: ddx_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1919: ddindx binary_integer; indx binary_integer;
1920: begin
1921:

Line 1918: ddx_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;

1914: )
1915:
1916: as
1917: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1918: ddx_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1919: ddindx binary_integer; indx binary_integer;
1920: begin
1921:
1922: -- copy data to the local IN or IN-OUT args, if any

Line 1967: okl_maintain_fee_pvt.update_fee_type(p_api_version,

1963: ddp_fee_types_rec.validate_dff_yn := p5_a35;
1964:
1965:
1966: -- here's the delegated call to the old PL/SQL routine
1967: okl_maintain_fee_pvt.update_fee_type(p_api_version,
1968: p_init_msg_list,
1969: x_return_status,
1970: x_msg_count,
1971: x_msg_data,

Line 2064: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;

2060: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2061: )
2062:
2063: as
2064: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
2065: ddindx binary_integer; indx binary_integer;
2066: begin
2067:
2068: -- copy data to the local IN or IN-OUT args, if any

Line 2112: okl_maintain_fee_pvt.delete_fee_type(p_api_version,

2108: ddp_fee_types_rec.attribute15 := p5_a34;
2109: ddp_fee_types_rec.validate_dff_yn := p5_a35;
2110:
2111: -- here's the delegated call to the old PL/SQL routine
2112: okl_maintain_fee_pvt.delete_fee_type(p_api_version,
2113: p_init_msg_list,
2114: x_return_status,
2115: x_msg_count,
2116: x_msg_data,

Line 2158: okl_maintain_fee_pvt.validate_rollover_feeline(p_api_version,

2154: else ddp_for_qa_check := true;
2155: end if;
2156:
2157: -- here's the delegated call to the old PL/SQL routine
2158: okl_maintain_fee_pvt.validate_rollover_feeline(p_api_version,
2159: p_init_msg_list,
2160: x_return_status,
2161: x_msg_count,
2162: x_msg_data,

Line 2258: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;

2254: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
2255: )
2256:
2257: as
2258: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
2259: ddx_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
2260: ddindx binary_integer; indx binary_integer;
2261: begin
2262:

Line 2259: ddx_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;

2255: )
2256:
2257: as
2258: ddp_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
2259: ddx_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
2260: ddindx binary_integer; indx binary_integer;
2261: begin
2262:
2263: -- copy data to the local IN or IN-OUT args, if any

Line 2309: okl_maintain_fee_pvt.process_rvi_stream(p_api_version,

2305: ddp_fee_types_rec.validate_dff_yn := p6_a35;
2306:
2307:
2308: -- here's the delegated call to the old PL/SQL routine
2309: okl_maintain_fee_pvt.process_rvi_stream(p_api_version,
2310: p_init_msg_list,
2311: x_return_status,
2312: x_msg_count,
2313: x_msg_data,

Line 2420: ddp_kpl_rec okl_maintain_fee_pvt.party_rec_type;

2416: , p5_a23 NUMBER := 0-1962.0724
2417: )
2418:
2419: as
2420: ddp_kpl_rec okl_maintain_fee_pvt.party_rec_type;
2421: ddx_kpl_rec okl_maintain_fee_pvt.party_rec_type;
2422: ddindx binary_integer; indx binary_integer;
2423: begin
2424:

Line 2421: ddx_kpl_rec okl_maintain_fee_pvt.party_rec_type;

2417: )
2418:
2419: as
2420: ddp_kpl_rec okl_maintain_fee_pvt.party_rec_type;
2421: ddx_kpl_rec okl_maintain_fee_pvt.party_rec_type;
2422: ddindx binary_integer; indx binary_integer;
2423: begin
2424:
2425: -- copy data to the local IN or IN-OUT args, if any

Line 2458: okl_maintain_fee_pvt.create_party(p_api_version,

2454: ddp_kpl_rec.cle_id := rosetta_g_miss_num_map(p5_a23);
2455:
2456:
2457: -- here's the delegated call to the old PL/SQL routine
2458: okl_maintain_fee_pvt.create_party(p_api_version,
2459: p_init_msg_list,
2460: x_return_status,
2461: x_msg_count,
2462: x_msg_data,

Line 2555: ddp_kpl_rec okl_maintain_fee_pvt.party_rec_type;

2551: , p5_a23 NUMBER := 0-1962.0724
2552: )
2553:
2554: as
2555: ddp_kpl_rec okl_maintain_fee_pvt.party_rec_type;
2556: ddx_kpl_rec okl_maintain_fee_pvt.party_rec_type;
2557: ddindx binary_integer; indx binary_integer;
2558: begin
2559:

Line 2556: ddx_kpl_rec okl_maintain_fee_pvt.party_rec_type;

2552: )
2553:
2554: as
2555: ddp_kpl_rec okl_maintain_fee_pvt.party_rec_type;
2556: ddx_kpl_rec okl_maintain_fee_pvt.party_rec_type;
2557: ddindx binary_integer; indx binary_integer;
2558: begin
2559:
2560: -- copy data to the local IN or IN-OUT args, if any

Line 2593: okl_maintain_fee_pvt.update_party(p_api_version,

2589: ddp_kpl_rec.cle_id := rosetta_g_miss_num_map(p5_a23);
2590:
2591:
2592: -- here's the delegated call to the old PL/SQL routine
2593: okl_maintain_fee_pvt.update_party(p_api_version,
2594: p_init_msg_list,
2595: x_return_status,
2596: x_msg_count,
2597: x_msg_data,

Line 2634: end okl_maintain_fee_pvt_w;

2630: p6_a22 := rosetta_g_miss_num_map(ddx_kpl_rec.dnz_chr_id);
2631: p6_a23 := rosetta_g_miss_num_map(ddx_kpl_rec.cle_id);
2632: end;
2633:
2634: end okl_maintain_fee_pvt_w;