DBA Data[Home] [Help]

APPS.OKL_SETUP_PRD_PRCTEMPL_PUB_W dependencies on OKL_SETUP_PRD_PRCTEMPL_PUB

Line 1: package body okl_setup_prd_prctempl_pub_w as

1: package body okl_setup_prd_prctempl_pub_w as
2: /* $Header: OKLUPPEB.pls 120.2 2005/10/30 04:49:29 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 58: ddp_pitv_rec okl_setup_prd_prctempl_pub.pitv_rec_type;

54: , p5_a13 NUMBER := 0-1962.0724
55: )
56:
57: as
58: ddp_pitv_rec okl_setup_prd_prctempl_pub.pitv_rec_type;
59: ddx_pitv_rec okl_setup_prd_prctempl_pub.pitv_rec_type;
60: ddindx binary_integer; indx binary_integer;
61: begin
62:

Line 59: ddx_pitv_rec okl_setup_prd_prctempl_pub.pitv_rec_type;

55: )
56:
57: as
58: ddp_pitv_rec okl_setup_prd_prctempl_pub.pitv_rec_type;
59: ddx_pitv_rec okl_setup_prd_prctempl_pub.pitv_rec_type;
60: ddindx binary_integer; indx binary_integer;
61: begin
62:
63: -- copy data to the local IN or IN-OUT args, if any

Line 86: okl_setup_prd_prctempl_pub.insert_prd_price_tmpls(p_api_version,

82: ddp_pitv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
83:
84:
85: -- here's the delegated call to the old PL/SQL routine
86: okl_setup_prd_prctempl_pub.insert_prd_price_tmpls(p_api_version,
87: p_init_msg_list,
88: x_return_status,
89: x_msg_count,
90: x_msg_data,

Line 153: ddp_pitv_rec okl_setup_prd_prctempl_pub.pitv_rec_type;

149: , p5_a13 NUMBER := 0-1962.0724
150: )
151:
152: as
153: ddp_pitv_rec okl_setup_prd_prctempl_pub.pitv_rec_type;
154: ddx_pitv_rec okl_setup_prd_prctempl_pub.pitv_rec_type;
155: ddindx binary_integer; indx binary_integer;
156: begin
157:

Line 154: ddx_pitv_rec okl_setup_prd_prctempl_pub.pitv_rec_type;

150: )
151:
152: as
153: ddp_pitv_rec okl_setup_prd_prctempl_pub.pitv_rec_type;
154: ddx_pitv_rec okl_setup_prd_prctempl_pub.pitv_rec_type;
155: ddindx binary_integer; indx binary_integer;
156: begin
157:
158: -- copy data to the local IN or IN-OUT args, if any

Line 181: okl_setup_prd_prctempl_pub.update_prd_price_tmpls(p_api_version,

177: ddp_pitv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
178:
179:
180: -- here's the delegated call to the old PL/SQL routine
181: okl_setup_prd_prctempl_pub.update_prd_price_tmpls(p_api_version,
182: p_init_msg_list,
183: x_return_status,
184: x_msg_count,
185: x_msg_data,

Line 248: ddp_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;

244: , p6_a13 out nocopy JTF_NUMBER_TABLE
245: )
246:
247: as
248: ddp_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;
249: ddx_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;
250: ddindx binary_integer; indx binary_integer;
251: begin
252:

Line 249: ddx_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;

245: )
246:
247: as
248: ddp_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;
249: ddx_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;
250: ddindx binary_integer; indx binary_integer;
251: begin
252:
253: -- copy data to the local IN or IN-OUT args, if any

Line 277: okl_setup_prd_prctempl_pub.insert_prd_price_tmpls(p_api_version,

273: );
274:
275:
276: -- here's the delegated call to the old PL/SQL routine
277: okl_setup_prd_prctempl_pub.insert_prd_price_tmpls(p_api_version,
278: p_init_msg_list,
279: x_return_status,
280: x_msg_count,
281: x_msg_data,

Line 345: ddp_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;

341: , p6_a13 out nocopy JTF_NUMBER_TABLE
342: )
343:
344: as
345: ddp_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;
346: ddx_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;
347: ddindx binary_integer; indx binary_integer;
348: begin
349:

Line 346: ddx_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;

342: )
343:
344: as
345: ddp_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;
346: ddx_pitv_tbl okl_setup_prd_prctempl_pub.pitv_tbl_type;
347: ddindx binary_integer; indx binary_integer;
348: begin
349:
350: -- copy data to the local IN or IN-OUT args, if any

Line 374: okl_setup_prd_prctempl_pub.update_prd_price_tmpls(p_api_version,

370: );
371:
372:
373: -- here's the delegated call to the old PL/SQL routine
374: okl_setup_prd_prctempl_pub.update_prd_price_tmpls(p_api_version,
375: p_init_msg_list,
376: x_return_status,
377: x_msg_count,
378: x_msg_data,

Line 448: ddp_pdtv_rec okl_setup_prd_prctempl_pub.pdtv_rec_type;

444: , p5_a32 NUMBER := 0-1962.0724
445: )
446:
447: as
448: ddp_pdtv_rec okl_setup_prd_prctempl_pub.pdtv_rec_type;
449: ddindx binary_integer; indx binary_integer;
450: begin
451:
452: -- copy data to the local IN or IN-OUT args, if any

Line 494: okl_setup_prd_prctempl_pub.check_product_constraints(p_api_version,

490: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
491:
492:
493: -- here's the delegated call to the old PL/SQL routine
494: okl_setup_prd_prctempl_pub.check_product_constraints(p_api_version,
495: p_init_msg_list,
496: x_return_status,
497: x_msg_count,
498: x_msg_data,

Line 553: ddp_pdtv_tbl okl_setup_prd_prctempl_pub.pdtv_tbl_type;

549: , x_validated out nocopy VARCHAR2
550: )
551:
552: as
553: ddp_pdtv_tbl okl_setup_prd_prctempl_pub.pdtv_tbl_type;
554: ddindx binary_integer; indx binary_integer;
555: begin
556:
557: -- copy data to the local IN or IN-OUT args, if any

Line 600: okl_setup_prd_prctempl_pub.check_product_constraints(p_api_version,

596: );
597:
598:
599: -- here's the delegated call to the old PL/SQL routine
600: okl_setup_prd_prctempl_pub.check_product_constraints(p_api_version,
601: p_init_msg_list,
602: x_return_status,
603: x_msg_count,
604: x_msg_data,

Line 617: end okl_setup_prd_prctempl_pub_w;

613:
614:
615: end;
616:
617: end okl_setup_prd_prctempl_pub_w;