eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PRODUCTS_PUB_W dependencies on OKL_PRODUCTS_PUB

Line 1: package body okl_products_pub_w as

1: package body okl_products_pub_w as
2: /* $Header: OKLUPDTB.pls 120.3 2005/10/30 04:49:09 appldev 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 96: ddp_pdtv_rec okl_products_pub.pdtv_rec_type;

92: , p5_a32 NUMBER := 0-1962.0724
93: )
94:
95: as
96: ddp_pdtv_rec okl_products_pub.pdtv_rec_type;
97: ddx_pdtv_rec okl_products_pub.pdtv_rec_type;
98: ddindx binary_integer; indx binary_integer;
99: begin
100:

Line 97: ddx_pdtv_rec okl_products_pub.pdtv_rec_type;

93: )
94:
95: as
96: ddp_pdtv_rec okl_products_pub.pdtv_rec_type;
97: ddx_pdtv_rec okl_products_pub.pdtv_rec_type;
98: ddindx binary_integer; indx binary_integer;
99: begin
100:
101: -- copy data to the local IN or IN-OUT args, if any

Line 143: okl_products_pub.insert_products(p_api_version,

139: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
140:
141:
142: -- here's the delegated call to the old PL/SQL routine
143: okl_products_pub.insert_products(p_api_version,
144: p_init_msg_list,
145: x_return_status,
146: x_msg_count,
147: x_msg_data,

Line 267: ddp_pdtv_tbl okl_products_pub.pdtv_tbl_type;

263: , p6_a32 out nocopy JTF_NUMBER_TABLE
264: )
265:
266: as
267: ddp_pdtv_tbl okl_products_pub.pdtv_tbl_type;
268: ddx_pdtv_tbl okl_products_pub.pdtv_tbl_type;
269: ddindx binary_integer; indx binary_integer;
270: begin
271:

Line 268: ddx_pdtv_tbl okl_products_pub.pdtv_tbl_type;

264: )
265:
266: as
267: ddp_pdtv_tbl okl_products_pub.pdtv_tbl_type;
268: ddx_pdtv_tbl okl_products_pub.pdtv_tbl_type;
269: ddindx binary_integer; indx binary_integer;
270: begin
271:
272: -- copy data to the local IN or IN-OUT args, if any

Line 315: okl_products_pub.insert_products(p_api_version,

311: );
312:
313:
314: -- here's the delegated call to the old PL/SQL routine
315: okl_products_pub.insert_products(p_api_version,
316: p_init_msg_list,
317: x_return_status,
318: x_msg_count,
319: x_msg_data,

Line 407: ddp_pdtv_rec okl_products_pub.pdtv_rec_type;

403: , p5_a32 NUMBER := 0-1962.0724
404: )
405:
406: as
407: ddp_pdtv_rec okl_products_pub.pdtv_rec_type;
408: ddindx binary_integer; indx binary_integer;
409: begin
410:
411: -- copy data to the local IN or IN-OUT args, if any

Line 452: okl_products_pub.lock_products(p_api_version,

448: ddp_pdtv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
449: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
450:
451: -- here's the delegated call to the old PL/SQL routine
452: okl_products_pub.lock_products(p_api_version,
453: p_init_msg_list,
454: x_return_status,
455: x_msg_count,
456: x_msg_data,

Line 508: ddp_pdtv_tbl okl_products_pub.pdtv_tbl_type;

504: , p5_a32 JTF_NUMBER_TABLE
505: )
506:
507: as
508: ddp_pdtv_tbl okl_products_pub.pdtv_tbl_type;
509: ddindx binary_integer; indx binary_integer;
510: begin
511:
512: -- copy data to the local IN or IN-OUT args, if any

Line 554: okl_products_pub.lock_products(p_api_version,

550: , p5_a32
551: );
552:
553: -- here's the delegated call to the old PL/SQL routine
554: okl_products_pub.lock_products(p_api_version,
555: p_init_msg_list,
556: x_return_status,
557: x_msg_count,
558: x_msg_data,

Line 643: ddp_pdtv_rec okl_products_pub.pdtv_rec_type;

639: , p5_a32 NUMBER := 0-1962.0724
640: )
641:
642: as
643: ddp_pdtv_rec okl_products_pub.pdtv_rec_type;
644: ddx_pdtv_rec okl_products_pub.pdtv_rec_type;
645: ddindx binary_integer; indx binary_integer;
646: begin
647:

Line 644: ddx_pdtv_rec okl_products_pub.pdtv_rec_type;

640: )
641:
642: as
643: ddp_pdtv_rec okl_products_pub.pdtv_rec_type;
644: ddx_pdtv_rec okl_products_pub.pdtv_rec_type;
645: ddindx binary_integer; indx binary_integer;
646: begin
647:
648: -- copy data to the local IN or IN-OUT args, if any

Line 690: okl_products_pub.update_products(p_api_version,

686: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
687:
688:
689: -- here's the delegated call to the old PL/SQL routine
690: okl_products_pub.update_products(p_api_version,
691: p_init_msg_list,
692: x_return_status,
693: x_msg_count,
694: x_msg_data,

Line 814: ddp_pdtv_tbl okl_products_pub.pdtv_tbl_type;

810: , p6_a32 out nocopy JTF_NUMBER_TABLE
811: )
812:
813: as
814: ddp_pdtv_tbl okl_products_pub.pdtv_tbl_type;
815: ddx_pdtv_tbl okl_products_pub.pdtv_tbl_type;
816: ddindx binary_integer; indx binary_integer;
817: begin
818:

Line 815: ddx_pdtv_tbl okl_products_pub.pdtv_tbl_type;

811: )
812:
813: as
814: ddp_pdtv_tbl okl_products_pub.pdtv_tbl_type;
815: ddx_pdtv_tbl okl_products_pub.pdtv_tbl_type;
816: ddindx binary_integer; indx binary_integer;
817: begin
818:
819: -- copy data to the local IN or IN-OUT args, if any

Line 862: okl_products_pub.update_products(p_api_version,

858: );
859:
860:
861: -- here's the delegated call to the old PL/SQL routine
862: okl_products_pub.update_products(p_api_version,
863: p_init_msg_list,
864: x_return_status,
865: x_msg_count,
866: x_msg_data,

Line 954: ddp_pdtv_rec okl_products_pub.pdtv_rec_type;

950: , p5_a32 NUMBER := 0-1962.0724
951: )
952:
953: as
954: ddp_pdtv_rec okl_products_pub.pdtv_rec_type;
955: ddindx binary_integer; indx binary_integer;
956: begin
957:
958: -- copy data to the local IN or IN-OUT args, if any

Line 999: okl_products_pub.delete_products(p_api_version,

995: ddp_pdtv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
996: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
997:
998: -- here's the delegated call to the old PL/SQL routine
999: okl_products_pub.delete_products(p_api_version,
1000: p_init_msg_list,
1001: x_return_status,
1002: x_msg_count,
1003: x_msg_data,

Line 1055: ddp_pdtv_tbl okl_products_pub.pdtv_tbl_type;

1051: , p5_a32 JTF_NUMBER_TABLE
1052: )
1053:
1054: as
1055: ddp_pdtv_tbl okl_products_pub.pdtv_tbl_type;
1056: ddindx binary_integer; indx binary_integer;
1057: begin
1058:
1059: -- copy data to the local IN or IN-OUT args, if any

Line 1101: okl_products_pub.delete_products(p_api_version,

1097: , p5_a32
1098: );
1099:
1100: -- here's the delegated call to the old PL/SQL routine
1101: okl_products_pub.delete_products(p_api_version,
1102: p_init_msg_list,
1103: x_return_status,
1104: x_msg_count,
1105: x_msg_data,

Line 1157: ddp_pdtv_rec okl_products_pub.pdtv_rec_type;

1153: , p5_a32 NUMBER := 0-1962.0724
1154: )
1155:
1156: as
1157: ddp_pdtv_rec okl_products_pub.pdtv_rec_type;
1158: ddindx binary_integer; indx binary_integer;
1159: begin
1160:
1161: -- copy data to the local IN or IN-OUT args, if any

Line 1202: okl_products_pub.validate_products(p_api_version,

1198: ddp_pdtv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
1199: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
1200:
1201: -- here's the delegated call to the old PL/SQL routine
1202: okl_products_pub.validate_products(p_api_version,
1203: p_init_msg_list,
1204: x_return_status,
1205: x_msg_count,
1206: x_msg_data,

Line 1258: ddp_pdtv_tbl okl_products_pub.pdtv_tbl_type;

1254: , p5_a32 JTF_NUMBER_TABLE
1255: )
1256:
1257: as
1258: ddp_pdtv_tbl okl_products_pub.pdtv_tbl_type;
1259: ddindx binary_integer; indx binary_integer;
1260: begin
1261:
1262: -- copy data to the local IN or IN-OUT args, if any

Line 1304: okl_products_pub.validate_products(p_api_version,

1300: , p5_a32
1301: );
1302:
1303: -- here's the delegated call to the old PL/SQL routine
1304: okl_products_pub.validate_products(p_api_version,
1305: p_init_msg_list,
1306: x_return_status,
1307: x_msg_count,
1308: x_msg_data,

Line 1319: end okl_products_pub_w;

1315:
1316:
1317: end;
1318:
1319: end okl_products_pub_w;