DBA Data[Home] [Help]

APPS.OKL_SGN_TRANSLATIONS_PUB_W dependencies on OKL_SGN_TRANSLATIONS_PUB

Line 1: package body okl_sgn_translations_pub_w as

1: package body okl_sgn_translations_pub_w as
2: /* $Header: OKLUSGTB.pls 120.1 2005/07/19 07:30:30 asawanka 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 92: ddp_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;

88: , p5_a30 NUMBER := 0-1962.0724
89: )
90:
91: as
92: ddp_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
93: ddx_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
94: ddindx binary_integer; indx binary_integer;
95: begin
96:

Line 93: ddx_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;

89: )
90:
91: as
92: ddp_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
93: ddx_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
94: ddindx binary_integer; indx binary_integer;
95: begin
96:
97: -- copy data to the local IN or IN-OUT args, if any

Line 137: okl_sgn_translations_pub.insert_sgn_translations(p_api_version,

133: ddp_sgnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
134:
135:
136: -- here's the delegated call to the old PL/SQL routine
137: okl_sgn_translations_pub.insert_sgn_translations(p_api_version,
138: p_init_msg_list,
139: x_return_status,
140: x_msg_count,
141: x_msg_data,

Line 255: ddp_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;

251: , p6_a30 out nocopy JTF_NUMBER_TABLE
252: )
253:
254: as
255: ddp_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
256: ddx_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
257: ddindx binary_integer; indx binary_integer;
258: begin
259:

Line 256: ddx_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;

252: )
253:
254: as
255: ddp_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
256: ddx_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
257: ddindx binary_integer; indx binary_integer;
258: begin
259:
260: -- copy data to the local IN or IN-OUT args, if any

Line 301: okl_sgn_translations_pub.insert_sgn_translations(p_api_version,

297: );
298:
299:
300: -- here's the delegated call to the old PL/SQL routine
301: okl_sgn_translations_pub.insert_sgn_translations(p_api_version,
302: p_init_msg_list,
303: x_return_status,
304: x_msg_count,
305: x_msg_data,

Line 389: ddp_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;

385: , p5_a30 NUMBER := 0-1962.0724
386: )
387:
388: as
389: ddp_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
390: ddindx binary_integer; indx binary_integer;
391: begin
392:
393: -- copy data to the local IN or IN-OUT args, if any

Line 432: okl_sgn_translations_pub.lock_sgn_translations(p_api_version,

428: ddp_sgnv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
429: ddp_sgnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
430:
431: -- here's the delegated call to the old PL/SQL routine
432: okl_sgn_translations_pub.lock_sgn_translations(p_api_version,
433: p_init_msg_list,
434: x_return_status,
435: x_msg_count,
436: x_msg_data,

Line 486: ddp_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;

482: , p5_a30 JTF_NUMBER_TABLE
483: )
484:
485: as
486: ddp_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
487: ddindx binary_integer; indx binary_integer;
488: begin
489:
490: -- copy data to the local IN or IN-OUT args, if any

Line 530: okl_sgn_translations_pub.lock_sgn_translations(p_api_version,

526: , p5_a30
527: );
528:
529: -- here's the delegated call to the old PL/SQL routine
530: okl_sgn_translations_pub.lock_sgn_translations(p_api_version,
531: p_init_msg_list,
532: x_return_status,
533: x_msg_count,
534: x_msg_data,

Line 615: ddp_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;

611: , p5_a30 NUMBER := 0-1962.0724
612: )
613:
614: as
615: ddp_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
616: ddx_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
617: ddindx binary_integer; indx binary_integer;
618: begin
619:

Line 616: ddx_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;

612: )
613:
614: as
615: ddp_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
616: ddx_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
617: ddindx binary_integer; indx binary_integer;
618: begin
619:
620: -- copy data to the local IN or IN-OUT args, if any

Line 660: okl_sgn_translations_pub.update_sgn_translations(p_api_version,

656: ddp_sgnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
657:
658:
659: -- here's the delegated call to the old PL/SQL routine
660: okl_sgn_translations_pub.update_sgn_translations(p_api_version,
661: p_init_msg_list,
662: x_return_status,
663: x_msg_count,
664: x_msg_data,

Line 778: ddp_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;

774: , p6_a30 out nocopy JTF_NUMBER_TABLE
775: )
776:
777: as
778: ddp_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
779: ddx_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
780: ddindx binary_integer; indx binary_integer;
781: begin
782:

Line 779: ddx_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;

775: )
776:
777: as
778: ddp_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
779: ddx_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
780: ddindx binary_integer; indx binary_integer;
781: begin
782:
783: -- copy data to the local IN or IN-OUT args, if any

Line 824: okl_sgn_translations_pub.update_sgn_translations(p_api_version,

820: );
821:
822:
823: -- here's the delegated call to the old PL/SQL routine
824: okl_sgn_translations_pub.update_sgn_translations(p_api_version,
825: p_init_msg_list,
826: x_return_status,
827: x_msg_count,
828: x_msg_data,

Line 912: ddp_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;

908: , p5_a30 NUMBER := 0-1962.0724
909: )
910:
911: as
912: ddp_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
913: ddindx binary_integer; indx binary_integer;
914: begin
915:
916: -- copy data to the local IN or IN-OUT args, if any

Line 955: okl_sgn_translations_pub.delete_sgn_translations(p_api_version,

951: ddp_sgnv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
952: ddp_sgnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
953:
954: -- here's the delegated call to the old PL/SQL routine
955: okl_sgn_translations_pub.delete_sgn_translations(p_api_version,
956: p_init_msg_list,
957: x_return_status,
958: x_msg_count,
959: x_msg_data,

Line 1009: ddp_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;

1005: , p5_a30 JTF_NUMBER_TABLE
1006: )
1007:
1008: as
1009: ddp_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
1010: ddindx binary_integer; indx binary_integer;
1011: begin
1012:
1013: -- copy data to the local IN or IN-OUT args, if any

Line 1053: okl_sgn_translations_pub.delete_sgn_translations(p_api_version,

1049: , p5_a30
1050: );
1051:
1052: -- here's the delegated call to the old PL/SQL routine
1053: okl_sgn_translations_pub.delete_sgn_translations(p_api_version,
1054: p_init_msg_list,
1055: x_return_status,
1056: x_msg_count,
1057: x_msg_data,

Line 1138: ddp_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;

1134: , p5_a30 NUMBER := 0-1962.0724
1135: )
1136:
1137: as
1138: ddp_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
1139: ddx_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
1140: ddindx binary_integer; indx binary_integer;
1141: begin
1142:

Line 1139: ddx_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;

1135: )
1136:
1137: as
1138: ddp_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
1139: ddx_sgnv_rec okl_sgn_translations_pub.sgnv_rec_type;
1140: ddindx binary_integer; indx binary_integer;
1141: begin
1142:
1143: -- copy data to the local IN or IN-OUT args, if any

Line 1183: okl_sgn_translations_pub.validate_sgn_translations(p_api_version,

1179: ddp_sgnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1180:
1181:
1182: -- here's the delegated call to the old PL/SQL routine
1183: okl_sgn_translations_pub.validate_sgn_translations(p_api_version,
1184: p_init_msg_list,
1185: x_return_status,
1186: x_msg_count,
1187: x_msg_data,

Line 1301: ddp_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;

1297: , p6_a30 out nocopy JTF_NUMBER_TABLE
1298: )
1299:
1300: as
1301: ddp_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
1302: ddx_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
1303: ddindx binary_integer; indx binary_integer;
1304: begin
1305:

Line 1302: ddx_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;

1298: )
1299:
1300: as
1301: ddp_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
1302: ddx_sgnv_tbl okl_sgn_translations_pub.sgnv_tbl_type;
1303: ddindx binary_integer; indx binary_integer;
1304: begin
1305:
1306: -- copy data to the local IN or IN-OUT args, if any

Line 1347: okl_sgn_translations_pub.validate_sgn_translations(p_api_version,

1343: );
1344:
1345:
1346: -- here's the delegated call to the old PL/SQL routine
1347: okl_sgn_translations_pub.validate_sgn_translations(p_api_version,
1348: p_init_msg_list,
1349: x_return_status,
1350: x_msg_count,
1351: x_msg_data,

Line 1396: end okl_sgn_translations_pub_w;

1392: , p6_a30
1393: );
1394: end;
1395:
1396: end okl_sgn_translations_pub_w;