1: package body okl_deal_creat_pvt_w as
2: /* $Header: OKLEDCRB.pls 120.12 2009/05/08 06:45:14 rpillay ship $ */
3: procedure rosetta_table_copy_in_p7(t out nocopy okl_deal_creat_pvt.deal_tab_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_2000
1: package body okl_deal_creat_pvt_w as
2: /* $Header: OKLEDCRB.pls 120.12 2009/05/08 06:45:14 rpillay ship $ */
3: procedure rosetta_table_copy_in_p7(t out nocopy okl_deal_creat_pvt.deal_tab_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
226: end loop;
227: end if;
228: end if;
229: end rosetta_table_copy_in_p7;
230: procedure rosetta_table_copy_out_p7(t okl_deal_creat_pvt.deal_tab_type, a0 out nocopy JTF_NUMBER_TABLE
231: , a1 out nocopy JTF_VARCHAR2_TABLE_200
232: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
233: , a3 out nocopy JTF_VARCHAR2_TABLE_100
234: , a4 out nocopy JTF_VARCHAR2_TABLE_100
770: end if;
771: end if;
772: end rosetta_table_copy_out_p7;
773:
774: procedure rosetta_table_copy_in_p9(t out nocopy okl_deal_creat_pvt.party_tab_type, a0 JTF_NUMBER_TABLE
775: , a1 JTF_VARCHAR2_TABLE_100
776: , a2 JTF_VARCHAR2_TABLE_500
777: , a3 JTF_VARCHAR2_TABLE_500
778: , a4 JTF_VARCHAR2_TABLE_500
839: end loop;
840: end if;
841: end if;
842: end rosetta_table_copy_in_p9;
843: procedure rosetta_table_copy_out_p9(t okl_deal_creat_pvt.party_tab_type, a0 out nocopy JTF_NUMBER_TABLE
844: , a1 out nocopy JTF_VARCHAR2_TABLE_100
845: , a2 out nocopy JTF_VARCHAR2_TABLE_500
846: , a3 out nocopy JTF_VARCHAR2_TABLE_500
847: , a4 out nocopy JTF_VARCHAR2_TABLE_500
988: end if;
989: end if;
990: end rosetta_table_copy_out_p9;
991:
992: procedure rosetta_table_copy_in_p11(t out nocopy okl_deal_creat_pvt.deal_values_tbl, a0 JTF_NUMBER_TABLE
993: , a1 JTF_VARCHAR2_TABLE_200
994: , a2 JTF_VARCHAR2_TABLE_2000
995: , a3 JTF_VARCHAR2_TABLE_100
996: , a4 JTF_VARCHAR2_TABLE_100
1215: end loop;
1216: end if;
1217: end if;
1218: end rosetta_table_copy_in_p11;
1219: procedure rosetta_table_copy_out_p11(t okl_deal_creat_pvt.deal_values_tbl, a0 out nocopy JTF_NUMBER_TABLE
1220: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1221: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
1222: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1223: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1977: , p6_a104 out nocopy VARCHAR2
1978: )
1979:
1980: as
1981: ddp_durv_rec okl_deal_creat_pvt.deal_rec_type;
1982: ddx_durv_rec okl_deal_creat_pvt.deal_rec_type;
1983: ddindx binary_integer; indx binary_integer;
1984: begin
1985:
1978: )
1979:
1980: as
1981: ddp_durv_rec okl_deal_creat_pvt.deal_rec_type;
1982: ddx_durv_rec okl_deal_creat_pvt.deal_rec_type;
1983: ddindx binary_integer; indx binary_integer;
1984: begin
1985:
1986: -- copy data to the local IN or IN-OUT args, if any
2096: ddp_durv_rec.labill_labacc_rul_info_cat := p5_a104;
2097:
2098:
2099: -- here's the delegated call to the old PL/SQL routine
2100: okl_deal_creat_pvt.update_deal(p_api_version,
2101: p_init_msg_list,
2102: x_return_status,
2103: x_msg_count,
2104: x_msg_data,
2436: , p6_a104 out nocopy VARCHAR2
2437: )
2438:
2439: as
2440: ddp_durv_rec okl_deal_creat_pvt.deal_rec_type;
2441: ddx_durv_rec okl_deal_creat_pvt.deal_rec_type;
2442: ddindx binary_integer; indx binary_integer;
2443: begin
2444:
2437: )
2438:
2439: as
2440: ddp_durv_rec okl_deal_creat_pvt.deal_rec_type;
2441: ddx_durv_rec okl_deal_creat_pvt.deal_rec_type;
2442: ddindx binary_integer; indx binary_integer;
2443: begin
2444:
2445: -- copy data to the local IN or IN-OUT args, if any
2555: ddp_durv_rec.labill_labacc_rul_info_cat := p5_a104;
2556:
2557:
2558: -- here's the delegated call to the old PL/SQL routine
2559: okl_deal_creat_pvt.load_deal(p_api_version,
2560: p_init_msg_list,
2561: x_return_status,
2562: x_msg_count,
2563: x_msg_data,
2737: , p6_a25 out nocopy VARCHAR2
2738: )
2739:
2740: as
2741: ddp_kpl_rec okl_deal_creat_pvt.party_rec_type;
2742: ddx_kpl_rec okl_deal_creat_pvt.party_rec_type;
2743: ddindx binary_integer; indx binary_integer;
2744: begin
2745:
2738: )
2739:
2740: as
2741: ddp_kpl_rec okl_deal_creat_pvt.party_rec_type;
2742: ddx_kpl_rec okl_deal_creat_pvt.party_rec_type;
2743: ddindx binary_integer; indx binary_integer;
2744: begin
2745:
2746: -- copy data to the local IN or IN-OUT args, if any
2777: ddp_kpl_rec.alias := p5_a25;
2778:
2779:
2780: -- here's the delegated call to the old PL/SQL routine
2781: okl_deal_creat_pvt.create_party(p_api_version,
2782: p_init_msg_list,
2783: x_return_status,
2784: x_msg_count,
2785: x_msg_data,
2880: , p6_a25 out nocopy VARCHAR2
2881: )
2882:
2883: as
2884: ddp_kpl_rec okl_deal_creat_pvt.party_rec_type;
2885: ddx_kpl_rec okl_deal_creat_pvt.party_rec_type;
2886: ddindx binary_integer; indx binary_integer;
2887: begin
2888:
2881: )
2882:
2883: as
2884: ddp_kpl_rec okl_deal_creat_pvt.party_rec_type;
2885: ddx_kpl_rec okl_deal_creat_pvt.party_rec_type;
2886: ddindx binary_integer; indx binary_integer;
2887: begin
2888:
2889: -- copy data to the local IN or IN-OUT args, if any
2920: ddp_kpl_rec.alias := p5_a25;
2921:
2922:
2923: -- here's the delegated call to the old PL/SQL routine
2924: okl_deal_creat_pvt.update_party(p_api_version,
2925: p_init_msg_list,
2926: x_return_status,
2927: x_msg_count,
2928: x_msg_data,
3089: , p6_a116 out nocopy DATE
3090: )
3091:
3092: as
3093: ddx_deal_values_rec okl_deal_creat_pvt.deal_values_rec;
3094: ddindx binary_integer; indx binary_integer;
3095: begin
3096:
3097: -- copy data to the local IN or IN-OUT args, if any
3102:
3103:
3104:
3105: -- here's the delegated call to the old PL/SQL routine
3106: okl_deal_creat_pvt.load_deal(p_api_version,
3107: p_init_msg_list,
3108: x_return_status,
3109: x_msg_count,
3110: x_msg_data,
3254: , p6_a8 out nocopy VARCHAR2
3255: )
3256:
3257: as
3258: ddx_booking_summary_rec okl_deal_creat_pvt.booking_summary_rec;
3259: ddindx binary_integer; indx binary_integer;
3260: begin
3261:
3262: -- copy data to the local IN or IN-OUT args, if any
3267:
3268:
3269:
3270: -- here's the delegated call to the old PL/SQL routine
3271: okl_deal_creat_pvt.load_booking_summary(p_api_version,
3272: p_init_msg_list,
3273: x_return_status,
3274: x_msg_count,
3275: x_msg_data,
3293: p6_a7 := ddx_booking_summary_rec.total_upfront_sales_tax;
3294: p6_a8 := ddx_booking_summary_rec.rvi_premium;
3295: end;
3296:
3297: end okl_deal_creat_pvt_w;