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_SETUPPRODUCTS_PVT_W dependencies on OKL_SETUPPRODUCTS_PVT

Line 1: package body okl_setupproducts_pvt_w as

1: package body okl_setupproducts_pvt_w as
2: /* $Header: OKLESPDB.pls 120.3 2005/10/30 04:08:24 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 22: procedure rosetta_table_copy_in_p56(t out nocopy okl_setupproducts_pvt.pdt_parameters_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p56(t out nocopy okl_setupproducts_pvt.pdt_parameters_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 99: procedure rosetta_table_copy_out_p56(t okl_setupproducts_pvt.pdt_parameters_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

95: end loop;
96: end if;
97: end if;
98: end rosetta_table_copy_in_p56;
99: procedure rosetta_table_copy_out_p56(t okl_setupproducts_pvt.pdt_parameters_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_VARCHAR2_TABLE_200
101: , a2 out nocopy JTF_DATE_TABLE
102: , a3 out nocopy JTF_DATE_TABLE
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 339: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;

335: , p0_a32 NUMBER := 0-1962.0724
336: )
337:
338: as
339: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
340: ddx_no_data_found boolean;
341: ddx_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
342: ddindx binary_integer; indx binary_integer;
343: begin

Line 341: ddx_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;

337:
338: as
339: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
340: ddx_no_data_found boolean;
341: ddx_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
342: ddindx binary_integer; indx binary_integer;
343: begin
344:
345: -- copy data to the local IN or IN-OUT args, if any

Line 384: okl_setupproducts_pvt.get_rec(ddp_pdtv_rec,

380:
381:
382:
383: -- here's the delegated call to the old PL/SQL routine
384: okl_setupproducts_pvt.get_rec(ddp_pdtv_rec,
385: x_return_status,
386: ddx_no_data_found,
387: ddx_pdtv_rec);
388:

Line 508: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;

504: , p5_a32 NUMBER := 0-1962.0724
505: )
506:
507: as
508: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
509: ddx_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
510: ddindx binary_integer; indx binary_integer;
511: begin
512:

Line 509: ddx_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;

505: )
506:
507: as
508: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
509: ddx_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
510: ddindx binary_integer; indx binary_integer;
511: begin
512:
513: -- copy data to the local IN or IN-OUT args, if any

Line 555: okl_setupproducts_pvt.insert_products(p_api_version,

551: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
552:
553:
554: -- here's the delegated call to the old PL/SQL routine
555: okl_setupproducts_pvt.insert_products(p_api_version,
556: p_init_msg_list,
557: x_return_status,
558: x_msg_count,
559: x_msg_data,

Line 679: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;

675: , p5_a32 NUMBER := 0-1962.0724
676: )
677:
678: as
679: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
680: ddx_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
681: ddindx binary_integer; indx binary_integer;
682: begin
683:

Line 680: ddx_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;

676: )
677:
678: as
679: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
680: ddx_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
681: ddindx binary_integer; indx binary_integer;
682: begin
683:
684: -- copy data to the local IN or IN-OUT args, if any

Line 726: okl_setupproducts_pvt.update_products(p_api_version,

722: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
723:
724:
725: -- here's the delegated call to the old PL/SQL routine
726: okl_setupproducts_pvt.update_products(p_api_version,
727: p_init_msg_list,
728: x_return_status,
729: x_msg_count,
730: x_msg_data,

Line 817: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;

813: , p5_a32 NUMBER := 0-1962.0724
814: )
815:
816: as
817: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
818: ddindx binary_integer; indx binary_integer;
819: begin
820:
821: -- copy data to the local IN or IN-OUT args, if any

Line 862: okl_setupproducts_pvt.product_approval_process(p_api_version,

858: ddp_pdtv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
859: ddp_pdtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
860:
861: -- here's the delegated call to the old PL/SQL routine
862: okl_setupproducts_pvt.product_approval_process(p_api_version,
863: p_init_msg_list,
864: x_return_status,
865: x_msg_count,
866: x_msg_data,

Line 951: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;

947: , p5_a32 NUMBER := 0-1962.0724
948: )
949:
950: as
951: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
952: ddx_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
953: ddindx binary_integer; indx binary_integer;
954: begin
955:

Line 952: ddx_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;

948: )
949:
950: as
951: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
952: ddx_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
953: ddindx binary_integer; indx binary_integer;
954: begin
955:
956: -- copy data to the local IN or IN-OUT args, if any

Line 998: okl_setupproducts_pvt.validate_product(p_api_version,

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

Line 1122: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;

1118: )
1119:
1120: as
1121: ddx_no_data_found boolean;
1122: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
1123: ddp_product_date date;
1124: ddp_pdt_parameter_rec okl_setupproducts_pvt.pdt_parameters_rec_type;
1125: ddindx binary_integer; indx binary_integer;
1126: begin

Line 1124: ddp_pdt_parameter_rec okl_setupproducts_pvt.pdt_parameters_rec_type;

1120: as
1121: ddx_no_data_found boolean;
1122: ddp_pdtv_rec okl_setupproducts_pvt.pdtv_rec_type;
1123: ddp_product_date date;
1124: ddp_pdt_parameter_rec okl_setupproducts_pvt.pdt_parameters_rec_type;
1125: ddindx binary_integer; indx binary_integer;
1126: begin
1127:
1128: -- copy data to the local IN or IN-OUT args, if any

Line 1173: okl_setupproducts_pvt.getpdt_parameters(p_api_version,

1169: ddp_product_date := rosetta_g_miss_date_in_map(p_product_date);
1170:
1171:
1172: -- here's the delegated call to the old PL/SQL routine
1173: okl_setupproducts_pvt.getpdt_parameters(p_api_version,
1174: p_init_msg_list,
1175: x_return_status,
1176: ddx_no_data_found,
1177: x_msg_count,

Line 1230: end okl_setupproducts_pvt_w;

1226: p8_a28 := rosetta_g_miss_num_map(ddp_pdt_parameter_rec.reporting_pdt_id);
1227: p8_a29 := ddp_pdt_parameter_rec.reporting_product;
1228: end;
1229:
1230: end okl_setupproducts_pvt_w;