DBA Data[Home] [Help]

APPS.OKL_SIF_TRX_PARMS_PUB_W dependencies on OKL_SIF_TRX_PARMS_PUB

Line 1: package body okl_sif_trx_parms_pub_w as

1: package body okl_sif_trx_parms_pub_w as
2: /* $Header: OKLUSXPB.pls 120.1 2005/07/19 09:45:55 viselvar 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_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;

54: , p5_a13 NUMBER := 0-1962.0724
55: )
56:
57: as
58: ddp_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
59: ddx_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
60: ddindx binary_integer; indx binary_integer;
61: begin
62:

Line 59: ddx_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;

55: )
56:
57: as
58: ddp_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
59: ddx_sxpv_rec okl_sif_trx_parms_pub.sxpv_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_sif_trx_parms_pub.insert_sif_trx_parms(p_api_version,

82: ddp_sxpv_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_sif_trx_parms_pub.insert_sif_trx_parms(p_api_version,
87: p_init_msg_list,
88: x_return_status,
89: x_msg_count,
90: x_msg_data,

Line 153: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;

149: , p6_a13 out nocopy JTF_NUMBER_TABLE
150: )
151:
152: as
153: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
154: ddx_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
155: ddindx binary_integer; indx binary_integer;
156: begin
157:

Line 154: ddx_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;

150: )
151:
152: as
153: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
154: ddx_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_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 182: okl_sif_trx_parms_pub.insert_sif_trx_parms(p_api_version,

178: );
179:
180:
181: -- here's the delegated call to the old PL/SQL routine
182: okl_sif_trx_parms_pub.insert_sif_trx_parms(p_api_version,
183: p_init_msg_list,
184: x_return_status,
185: x_msg_count,
186: x_msg_data,

Line 236: ddp_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;

232: , p5_a13 NUMBER := 0-1962.0724
233: )
234:
235: as
236: ddp_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
237: ddindx binary_integer; indx binary_integer;
238: begin
239:
240: -- copy data to the local IN or IN-OUT args, if any

Line 262: okl_sif_trx_parms_pub.lock_sif_trx_parms(p_api_version,

258: ddp_sxpv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a12);
259: ddp_sxpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
260:
261: -- here's the delegated call to the old PL/SQL routine
262: okl_sif_trx_parms_pub.lock_sif_trx_parms(p_api_version,
263: p_init_msg_list,
264: x_return_status,
265: x_msg_count,
266: x_msg_data,

Line 299: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;

295: , p5_a13 JTF_NUMBER_TABLE
296: )
297:
298: as
299: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
300: ddindx binary_integer; indx binary_integer;
301: begin
302:
303: -- copy data to the local IN or IN-OUT args, if any

Line 326: okl_sif_trx_parms_pub.lock_sif_trx_parms(p_api_version,

322: , p5_a13
323: );
324:
325: -- here's the delegated call to the old PL/SQL routine
326: okl_sif_trx_parms_pub.lock_sif_trx_parms(p_api_version,
327: p_init_msg_list,
328: x_return_status,
329: x_msg_count,
330: x_msg_data,

Line 377: ddp_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;

373: , p5_a13 NUMBER := 0-1962.0724
374: )
375:
376: as
377: ddp_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
378: ddx_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
379: ddindx binary_integer; indx binary_integer;
380: begin
381:

Line 378: ddx_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;

374: )
375:
376: as
377: ddp_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
378: ddx_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
379: ddindx binary_integer; indx binary_integer;
380: begin
381:
382: -- copy data to the local IN or IN-OUT args, if any

Line 405: okl_sif_trx_parms_pub.update_sif_trx_parms(p_api_version,

401: ddp_sxpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
402:
403:
404: -- here's the delegated call to the old PL/SQL routine
405: okl_sif_trx_parms_pub.update_sif_trx_parms(p_api_version,
406: p_init_msg_list,
407: x_return_status,
408: x_msg_count,
409: x_msg_data,

Line 472: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;

468: , p6_a13 out nocopy JTF_NUMBER_TABLE
469: )
470:
471: as
472: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
473: ddx_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
474: ddindx binary_integer; indx binary_integer;
475: begin
476:

Line 473: ddx_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;

469: )
470:
471: as
472: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
473: ddx_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
474: ddindx binary_integer; indx binary_integer;
475: begin
476:
477: -- copy data to the local IN or IN-OUT args, if any

Line 501: okl_sif_trx_parms_pub.update_sif_trx_parms(p_api_version,

497: );
498:
499:
500: -- here's the delegated call to the old PL/SQL routine
501: okl_sif_trx_parms_pub.update_sif_trx_parms(p_api_version,
502: p_init_msg_list,
503: x_return_status,
504: x_msg_count,
505: x_msg_data,

Line 569: ddp_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;

565: , p5_a13 NUMBER := 0-1962.0724
566: )
567:
568: as
569: ddp_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
570: ddx_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
571: ddindx binary_integer; indx binary_integer;
572: begin
573:

Line 570: ddx_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;

566: )
567:
568: as
569: ddp_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
570: ddx_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
571: ddindx binary_integer; indx binary_integer;
572: begin
573:
574: -- copy data to the local IN or IN-OUT args, if any

Line 597: okl_sif_trx_parms_pub.delete_sif_trx_parms(p_api_version,

593: ddp_sxpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
594:
595:
596: -- here's the delegated call to the old PL/SQL routine
597: okl_sif_trx_parms_pub.delete_sif_trx_parms(p_api_version,
598: p_init_msg_list,
599: x_return_status,
600: x_msg_count,
601: x_msg_data,

Line 664: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;

660: , p6_a13 out nocopy JTF_NUMBER_TABLE
661: )
662:
663: as
664: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
665: ddx_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
666: ddindx binary_integer; indx binary_integer;
667: begin
668:

Line 665: ddx_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;

661: )
662:
663: as
664: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
665: ddx_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
666: ddindx binary_integer; indx binary_integer;
667: begin
668:
669: -- copy data to the local IN or IN-OUT args, if any

Line 693: okl_sif_trx_parms_pub.delete_sif_trx_parms(p_api_version,

689: );
690:
691:
692: -- here's the delegated call to the old PL/SQL routine
693: okl_sif_trx_parms_pub.delete_sif_trx_parms(p_api_version,
694: p_init_msg_list,
695: x_return_status,
696: x_msg_count,
697: x_msg_data,

Line 761: ddp_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;

757: , p5_a13 NUMBER := 0-1962.0724
758: )
759:
760: as
761: ddp_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
762: ddx_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
763: ddindx binary_integer; indx binary_integer;
764: begin
765:

Line 762: ddx_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;

758: )
759:
760: as
761: ddp_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
762: ddx_sxpv_rec okl_sif_trx_parms_pub.sxpv_rec_type;
763: ddindx binary_integer; indx binary_integer;
764: begin
765:
766: -- copy data to the local IN or IN-OUT args, if any

Line 789: okl_sif_trx_parms_pub.validate_sif_trx_parms(p_api_version,

785: ddp_sxpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
786:
787:
788: -- here's the delegated call to the old PL/SQL routine
789: okl_sif_trx_parms_pub.validate_sif_trx_parms(p_api_version,
790: p_init_msg_list,
791: x_return_status,
792: x_msg_count,
793: x_msg_data,

Line 856: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;

852: , p6_a13 out nocopy JTF_NUMBER_TABLE
853: )
854:
855: as
856: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
857: ddx_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
858: ddindx binary_integer; indx binary_integer;
859: begin
860:

Line 857: ddx_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;

853: )
854:
855: as
856: ddp_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
857: ddx_sxpv_tbl okl_sif_trx_parms_pub.sxpv_tbl_type;
858: ddindx binary_integer; indx binary_integer;
859: begin
860:
861: -- copy data to the local IN or IN-OUT args, if any

Line 885: okl_sif_trx_parms_pub.validate_sif_trx_parms(p_api_version,

881: );
882:
883:
884: -- here's the delegated call to the old PL/SQL routine
885: okl_sif_trx_parms_pub.validate_sif_trx_parms(p_api_version,
886: p_init_msg_list,
887: x_return_status,
888: x_msg_count,
889: x_msg_data,

Line 917: end okl_sif_trx_parms_pub_w;

913: , p6_a13
914: );
915: end;
916:
917: end okl_sif_trx_parms_pub_w;