DBA Data[Home] [Help]

APPS.OKL_SYSTEM_PARAMS_ALL_PUB_W dependencies on OKL_SYSTEM_PARAMS_ALL_PUB

Line 1: package body okl_system_params_all_pub_w as

1: package body okl_system_params_all_pub_w as
2: /* $Header: OKLUSYPB.pls 120.14.12010000.2 2008/11/13 16:20:44 kkorrapo ship $ */
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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 159: ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;

155: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
156: )
157:
158: as
159: ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;
160: ddx_sypv_rec okl_system_params_all_pub.sypv_rec_type;
161: ddindx binary_integer; indx binary_integer;
162: begin
163:

Line 160: ddx_sypv_rec okl_system_params_all_pub.sypv_rec_type;

156: )
157:
158: as
159: ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;
160: ddx_sypv_rec okl_system_params_all_pub.sypv_rec_type;
161: ddindx binary_integer; indx binary_integer;
162: begin
163:
164: -- copy data to the local IN or IN-OUT args, if any

Line 236: okl_system_params_all_pub.insert_system_parameters(p_api_version,

232: ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
233:
234:
235: -- here's the delegated call to the old PL/SQL routine
236: okl_system_params_all_pub.insert_system_parameters(p_api_version,
237: p_init_msg_list,
238: x_return_status,
239: x_msg_count,
240: x_msg_data,

Line 450: ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;

446: , p6_a62 out nocopy JTF_VARCHAR2_TABLE_200
447: )
448:
449: as
450: ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
451: ddx_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
452: ddindx binary_integer; indx binary_integer;
453: begin
454:

Line 451: ddx_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;

447: )
448:
449: as
450: ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
451: ddx_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
452: ddindx binary_integer; indx binary_integer;
453: begin
454:
455: -- copy data to the local IN or IN-OUT args, if any

Line 528: okl_system_params_all_pub.insert_system_parameters(p_api_version,

524: );
525:
526:
527: -- here's the delegated call to the old PL/SQL routine
528: okl_system_params_all_pub.insert_system_parameters(p_api_version,
529: p_init_msg_list,
530: x_return_status,
531: x_msg_count,
532: x_msg_data,

Line 680: ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;

676: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
677: )
678:
679: as
680: ddp_sypv_rec okl_system_params_all_pub.sypv_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 755: okl_system_params_all_pub.lock_system_parameters(p_api_version,

751: ddp_sypv_rec.qckqte_seq_prefix_txt := p5_a61;
752: ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
753:
754: -- here's the delegated call to the old PL/SQL routine
755: okl_system_params_all_pub.lock_system_parameters(p_api_version,
756: p_init_msg_list,
757: x_return_status,
758: x_msg_count,
759: x_msg_data,

Line 841: ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;

837: , p5_a62 JTF_VARCHAR2_TABLE_200
838: )
839:
840: as
841: ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
842: ddindx binary_integer; indx binary_integer;
843: begin
844:
845: -- copy data to the local IN or IN-OUT args, if any

Line 917: okl_system_params_all_pub.lock_system_parameters(p_api_version,

913: , p5_a62
914: );
915:
916: -- here's the delegated call to the old PL/SQL routine
917: okl_system_params_all_pub.lock_system_parameters(p_api_version,
918: p_init_msg_list,
919: x_return_status,
920: x_msg_count,
921: x_msg_data,

Line 1066: ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;

1062: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1063: )
1064:
1065: as
1066: ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;
1067: ddx_sypv_rec okl_system_params_all_pub.sypv_rec_type;
1068: ddindx binary_integer; indx binary_integer;
1069: begin
1070:

Line 1067: ddx_sypv_rec okl_system_params_all_pub.sypv_rec_type;

1063: )
1064:
1065: as
1066: ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;
1067: ddx_sypv_rec okl_system_params_all_pub.sypv_rec_type;
1068: ddindx binary_integer; indx binary_integer;
1069: begin
1070:
1071: -- copy data to the local IN or IN-OUT args, if any

Line 1143: okl_system_params_all_pub.update_system_parameters(p_api_version,

1139: ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
1140:
1141:
1142: -- here's the delegated call to the old PL/SQL routine
1143: okl_system_params_all_pub.update_system_parameters(p_api_version,
1144: p_init_msg_list,
1145: x_return_status,
1146: x_msg_count,
1147: x_msg_data,

Line 1357: ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;

1353: , p6_a62 out nocopy JTF_VARCHAR2_TABLE_200
1354: )
1355:
1356: as
1357: ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
1358: ddx_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
1359: ddindx binary_integer; indx binary_integer;
1360: begin
1361:

Line 1358: ddx_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;

1354: )
1355:
1356: as
1357: ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
1358: ddx_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
1359: ddindx binary_integer; indx binary_integer;
1360: begin
1361:
1362: -- copy data to the local IN or IN-OUT args, if any

Line 1435: okl_system_params_all_pub.update_system_parameters(p_api_version,

1431: );
1432:
1433:
1434: -- here's the delegated call to the old PL/SQL routine
1435: okl_system_params_all_pub.update_system_parameters(p_api_version,
1436: p_init_msg_list,
1437: x_return_status,
1438: x_msg_count,
1439: x_msg_data,

Line 1587: ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;

1583: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1584: )
1585:
1586: as
1587: ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;
1588: ddindx binary_integer; indx binary_integer;
1589: begin
1590:
1591: -- copy data to the local IN or IN-OUT args, if any

Line 1662: okl_system_params_all_pub.delete_system_parameters(p_api_version,

1658: ddp_sypv_rec.qckqte_seq_prefix_txt := p5_a61;
1659: ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
1660:
1661: -- here's the delegated call to the old PL/SQL routine
1662: okl_system_params_all_pub.delete_system_parameters(p_api_version,
1663: p_init_msg_list,
1664: x_return_status,
1665: x_msg_count,
1666: x_msg_data,

Line 1748: ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;

1744: , p5_a62 JTF_VARCHAR2_TABLE_200
1745: )
1746:
1747: as
1748: ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
1749: ddindx binary_integer; indx binary_integer;
1750: begin
1751:
1752: -- copy data to the local IN or IN-OUT args, if any

Line 1824: okl_system_params_all_pub.delete_system_parameters(p_api_version,

1820: , p5_a62
1821: );
1822:
1823: -- here's the delegated call to the old PL/SQL routine
1824: okl_system_params_all_pub.delete_system_parameters(p_api_version,
1825: p_init_msg_list,
1826: x_return_status,
1827: x_msg_count,
1828: x_msg_data,

Line 1910: ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;

1906: , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1907: )
1908:
1909: as
1910: ddp_sypv_rec okl_system_params_all_pub.sypv_rec_type;
1911: ddindx binary_integer; indx binary_integer;
1912: begin
1913:
1914: -- copy data to the local IN or IN-OUT args, if any

Line 1985: okl_system_params_all_pub.validate_system_parameters(p_api_version,

1981: ddp_sypv_rec.qckqte_seq_prefix_txt := p5_a61;
1982: ddp_sypv_rec.lseqte_seq_prefix_txt := p5_a62;
1983:
1984: -- here's the delegated call to the old PL/SQL routine
1985: okl_system_params_all_pub.validate_system_parameters(p_api_version,
1986: p_init_msg_list,
1987: x_return_status,
1988: x_msg_count,
1989: x_msg_data,

Line 2071: ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;

2067: , p5_a62 JTF_VARCHAR2_TABLE_200
2068: )
2069:
2070: as
2071: ddp_sypv_tbl okl_system_params_all_pub.sypv_tbl_type;
2072: ddindx binary_integer; indx binary_integer;
2073: begin
2074:
2075: -- copy data to the local IN or IN-OUT args, if any

Line 2147: okl_system_params_all_pub.validate_system_parameters(p_api_version,

2143: , p5_a62
2144: );
2145:
2146: -- here's the delegated call to the old PL/SQL routine
2147: okl_system_params_all_pub.validate_system_parameters(p_api_version,
2148: p_init_msg_list,
2149: x_return_status,
2150: x_msg_count,
2151: x_msg_data,

Line 2162: end okl_system_params_all_pub_w;

2158:
2159:
2160: end;
2161:
2162: end okl_system_params_all_pub_w;