1: package body okl_vp_change_request_pvt_w as
2: /* $Header: OKLEVCRB.pls 120.0 2005/08/03 07:55:22 sjalasut noship $ */
3: procedure create_change_request_header(p_api_version NUMBER
4: , p_init_msg_list VARCHAR2
5: , x_return_status out nocopy VARCHAR2
81: , p6_a36 out nocopy NUMBER
82: )
83:
84: as
85: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
86: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
87: ddindx binary_integer; indx binary_integer;
88: begin
89:
82: )
83:
84: as
85: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
86: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
87: ddindx binary_integer; indx binary_integer;
88: begin
89:
90: -- copy data to the local IN or IN-OUT args, if any
132: ddp_vcrv_rec.last_update_login := p5_a36;
133:
134:
135: -- here's the delegated call to the old PL/SQL routine
136: okl_vp_change_request_pvt.create_change_request_header(p_api_version,
137: p_init_msg_list,
138: x_return_status,
139: x_msg_count,
140: x_msg_data,
268: , p6_a36 out nocopy NUMBER
269: )
270:
271: as
272: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
273: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
274: ddindx binary_integer; indx binary_integer;
275: begin
276:
269: )
270:
271: as
272: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
273: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
274: ddindx binary_integer; indx binary_integer;
275: begin
276:
277: -- copy data to the local IN or IN-OUT args, if any
319: ddp_vcrv_rec.last_update_login := p5_a36;
320:
321:
322: -- here's the delegated call to the old PL/SQL routine
323: okl_vp_change_request_pvt.update_change_request_header(p_api_version,
324: p_init_msg_list,
325: x_return_status,
326: x_msg_count,
327: x_msg_data,
444: , x_request_status out nocopy VARCHAR2
445: )
446:
447: as
448: ddp_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
449: ddx_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
450: ddindx binary_integer; indx binary_integer;
451: begin
452:
445: )
446:
447: as
448: ddp_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
449: ddx_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
450: ddindx binary_integer; indx binary_integer;
451: begin
452:
453: -- copy data to the local IN or IN-OUT args, if any
491:
492:
493:
494: -- here's the delegated call to the old PL/SQL routine
495: okl_vp_change_request_pvt.create_change_request_lines(p_api_version,
496: p_init_msg_list,
497: x_return_status,
498: x_msg_count,
499: x_msg_data,
613: , x_request_status out nocopy VARCHAR2
614: )
615:
616: as
617: ddp_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
618: ddx_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
619: ddindx binary_integer; indx binary_integer;
620: begin
621:
614: )
615:
616: as
617: ddp_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
618: ddx_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
619: ddindx binary_integer; indx binary_integer;
620: begin
621:
622: -- copy data to the local IN or IN-OUT args, if any
660:
661:
662:
663: -- here's the delegated call to the old PL/SQL routine
664: okl_vp_change_request_pvt.update_change_request_lines(p_api_version,
665: p_init_msg_list,
666: x_return_status,
667: x_msg_count,
668: x_msg_data,
751: , x_request_status out nocopy VARCHAR2
752: )
753:
754: as
755: ddp_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
756: ddindx binary_integer; indx binary_integer;
757: begin
758:
759: -- copy data to the local IN or IN-OUT args, if any
796: );
797:
798:
799: -- here's the delegated call to the old PL/SQL routine
800: okl_vp_change_request_pvt.delete_change_request_lines(p_api_version,
801: p_init_msg_list,
802: x_return_status,
803: x_msg_count,
804: x_msg_data,
957: , p8_a30 out nocopy JTF_NUMBER_TABLE
958: )
959:
960: as
961: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
962: ddp_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
963: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
964: ddx_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
965: ddindx binary_integer; indx binary_integer;
958: )
959:
960: as
961: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
962: ddp_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
963: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
964: ddx_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
965: ddindx binary_integer; indx binary_integer;
966: begin
959:
960: as
961: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
962: ddp_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
963: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
964: ddx_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
965: ddindx binary_integer; indx binary_integer;
966: begin
967:
960: as
961: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
962: ddp_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
963: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
964: ddx_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;
965: ddindx binary_integer; indx binary_integer;
966: begin
967:
968: -- copy data to the local IN or IN-OUT args, if any
1044:
1045:
1046:
1047: -- here's the delegated call to the old PL/SQL routine
1048: okl_vp_change_request_pvt.create_change_request(p_api_version,
1049: p_init_msg_list,
1050: x_return_status,
1051: x_msg_count,
1052: x_msg_data,
1216: , p6_a36 out nocopy NUMBER
1217: )
1218:
1219: as
1220: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
1221: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
1222: ddindx binary_integer; indx binary_integer;
1223: begin
1224:
1217: )
1218:
1219: as
1220: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
1221: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;
1222: ddindx binary_integer; indx binary_integer;
1223: begin
1224:
1225: -- copy data to the local IN or IN-OUT args, if any
1267: ddp_vcrv_rec.last_update_login := p5_a36;
1268:
1269:
1270: -- here's the delegated call to the old PL/SQL routine
1271: okl_vp_change_request_pvt.abandon_change_request(p_api_version,
1272: p_init_msg_list,
1273: x_return_status,
1274: x_msg_count,
1275: x_msg_data,
1321: p6_a35 := ddx_vcrv_rec.last_update_date;
1322: p6_a36 := ddx_vcrv_rec.last_update_login;
1323: end;
1324:
1325: end okl_vp_change_request_pvt_w;