DBA Data[Home] [Help]

APPS.OKL_VP_CHANGE_REQUEST_PVT_W dependencies on OKL_VP_CHANGE_REQUEST_PVT

Line 1: package body okl_vp_change_request_pvt_w as

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

Line 85: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;

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:

Line 86: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;

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

Line 136: okl_vp_change_request_pvt.create_change_request_header(p_api_version,

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,

Line 272: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;

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:

Line 273: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;

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

Line 323: okl_vp_change_request_pvt.update_change_request_header(p_api_version,

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,

Line 448: ddp_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;

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:

Line 449: ddx_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;

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

Line 495: okl_vp_change_request_pvt.create_change_request_lines(p_api_version,

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,

Line 617: ddp_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;

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:

Line 618: ddx_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;

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

Line 664: okl_vp_change_request_pvt.update_change_request_lines(p_api_version,

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,

Line 755: ddp_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;

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

Line 800: okl_vp_change_request_pvt.delete_change_request_lines(p_api_version,

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,

Line 961: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;

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;

Line 962: ddp_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;

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

Line 963: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;

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:

Line 964: ddx_vrrv_tbl okl_vp_change_request_pvt.vrrv_tbl_type;

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

Line 1048: okl_vp_change_request_pvt.create_change_request(p_api_version,

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,

Line 1220: ddp_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;

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:

Line 1221: ddx_vcrv_rec okl_vp_change_request_pvt.vcrv_rec_type;

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

Line 1271: okl_vp_change_request_pvt.abandon_change_request(p_api_version,

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,

Line 1325: end okl_vp_change_request_pvt_w;

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;