DBA Data[Home] [Help]

APPS.OKL_SIF_STREAM_TYPES_PUB_W dependencies on OKL_SIF_STREAM_TYPES_PUB

Line 1: package body okl_sif_stream_types_pub_w as

1: package body okl_sif_stream_types_pub_w as
2: /* $Header: OKLUSITB.pls 120.1 2005/07/19 09:45:30 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 54: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;

50: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
51: )
52:
53: as
54: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
55: ddx_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
56: ddindx binary_integer; indx binary_integer;
57: begin
58:

Line 55: ddx_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;

51: )
52:
53: as
54: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
55: ddx_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
56: ddindx binary_integer; indx binary_integer;
57: begin
58:
59: -- copy data to the local IN or IN-OUT args, if any

Line 80: okl_sif_stream_types_pub.insert_sif_stream_types(p_api_version,

76: ddp_sitv_rec.pricing_name := p5_a11;
77:
78:
79: -- here's the delegated call to the old PL/SQL routine
80: okl_sif_stream_types_pub.insert_sif_stream_types(p_api_version,
81: p_init_msg_list,
82: x_return_status,
83: x_msg_count,
84: x_msg_data,

Line 141: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;

137: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
138: )
139:
140: as
141: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
142: ddx_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
143: ddindx binary_integer; indx binary_integer;
144: begin
145:

Line 142: ddx_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;

138: )
139:
140: as
141: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
142: ddx_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
143: ddindx binary_integer; indx binary_integer;
144: begin
145:
146: -- copy data to the local IN or IN-OUT args, if any

Line 168: okl_sif_stream_types_pub.insert_sif_stream_types(p_api_version,

164: );
165:
166:
167: -- here's the delegated call to the old PL/SQL routine
168: okl_sif_stream_types_pub.insert_sif_stream_types(p_api_version,
169: p_init_msg_list,
170: x_return_status,
171: x_msg_count,
172: x_msg_data,

Line 218: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;

214: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
215: )
216:
217: as
218: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
219: ddindx binary_integer; indx binary_integer;
220: begin
221:
222: -- copy data to the local IN or IN-OUT args, if any

Line 242: okl_sif_stream_types_pub.lock_sif_stream_types(p_api_version,

238: ddp_sitv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
239: ddp_sitv_rec.pricing_name := p5_a11;
240:
241: -- here's the delegated call to the old PL/SQL routine
242: okl_sif_stream_types_pub.lock_sif_stream_types(p_api_version,
243: p_init_msg_list,
244: x_return_status,
245: x_msg_count,
246: x_msg_data,

Line 277: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;

273: , p5_a11 JTF_VARCHAR2_TABLE_200
274: )
275:
276: as
277: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
278: ddindx binary_integer; indx binary_integer;
279: begin
280:
281: -- copy data to the local IN or IN-OUT args, if any

Line 302: okl_sif_stream_types_pub.lock_sif_stream_types(p_api_version,

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

Line 349: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;

345: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
346: )
347:
348: as
349: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
350: ddx_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
351: ddindx binary_integer; indx binary_integer;
352: begin
353:

Line 350: ddx_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;

346: )
347:
348: as
349: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
350: ddx_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
351: ddindx binary_integer; indx binary_integer;
352: begin
353:
354: -- copy data to the local IN or IN-OUT args, if any

Line 375: okl_sif_stream_types_pub.update_sif_stream_types(p_api_version,

371: ddp_sitv_rec.pricing_name := p5_a11;
372:
373:
374: -- here's the delegated call to the old PL/SQL routine
375: okl_sif_stream_types_pub.update_sif_stream_types(p_api_version,
376: p_init_msg_list,
377: x_return_status,
378: x_msg_count,
379: x_msg_data,

Line 436: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;

432: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
433: )
434:
435: as
436: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
437: ddx_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
438: ddindx binary_integer; indx binary_integer;
439: begin
440:

Line 437: ddx_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;

433: )
434:
435: as
436: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
437: ddx_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
438: ddindx binary_integer; indx binary_integer;
439: begin
440:
441: -- copy data to the local IN or IN-OUT args, if any

Line 463: okl_sif_stream_types_pub.update_sif_stream_types(p_api_version,

459: );
460:
461:
462: -- here's the delegated call to the old PL/SQL routine
463: okl_sif_stream_types_pub.update_sif_stream_types(p_api_version,
464: p_init_msg_list,
465: x_return_status,
466: x_msg_count,
467: x_msg_data,

Line 525: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;

521: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
522: )
523:
524: as
525: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
526: ddx_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
527: ddindx binary_integer; indx binary_integer;
528: begin
529:

Line 526: ddx_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;

522: )
523:
524: as
525: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
526: ddx_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
527: ddindx binary_integer; indx binary_integer;
528: begin
529:
530: -- copy data to the local IN or IN-OUT args, if any

Line 551: okl_sif_stream_types_pub.delete_sif_stream_types(p_api_version,

547: ddp_sitv_rec.pricing_name := p5_a11;
548:
549:
550: -- here's the delegated call to the old PL/SQL routine
551: okl_sif_stream_types_pub.delete_sif_stream_types(p_api_version,
552: p_init_msg_list,
553: x_return_status,
554: x_msg_count,
555: x_msg_data,

Line 612: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;

608: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
609: )
610:
611: as
612: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
613: ddx_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
614: ddindx binary_integer; indx binary_integer;
615: begin
616:

Line 613: ddx_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;

609: )
610:
611: as
612: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
613: ddx_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
614: ddindx binary_integer; indx binary_integer;
615: begin
616:
617: -- copy data to the local IN or IN-OUT args, if any

Line 639: okl_sif_stream_types_pub.delete_sif_stream_types(p_api_version,

635: );
636:
637:
638: -- here's the delegated call to the old PL/SQL routine
639: okl_sif_stream_types_pub.delete_sif_stream_types(p_api_version,
640: p_init_msg_list,
641: x_return_status,
642: x_msg_count,
643: x_msg_data,

Line 701: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;

697: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
698: )
699:
700: as
701: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
702: ddx_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
703: ddindx binary_integer; indx binary_integer;
704: begin
705:

Line 702: ddx_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;

698: )
699:
700: as
701: ddp_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
702: ddx_sitv_rec okl_sif_stream_types_pub.sitv_rec_type;
703: ddindx binary_integer; indx binary_integer;
704: begin
705:
706: -- copy data to the local IN or IN-OUT args, if any

Line 727: okl_sif_stream_types_pub.validate_sif_stream_types(p_api_version,

723: ddp_sitv_rec.pricing_name := p5_a11;
724:
725:
726: -- here's the delegated call to the old PL/SQL routine
727: okl_sif_stream_types_pub.validate_sif_stream_types(p_api_version,
728: p_init_msg_list,
729: x_return_status,
730: x_msg_count,
731: x_msg_data,

Line 788: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;

784: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
785: )
786:
787: as
788: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
789: ddx_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
790: ddindx binary_integer; indx binary_integer;
791: begin
792:

Line 789: ddx_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;

785: )
786:
787: as
788: ddp_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
789: ddx_sitv_tbl okl_sif_stream_types_pub.sitv_tbl_type;
790: ddindx binary_integer; indx binary_integer;
791: begin
792:
793: -- copy data to the local IN or IN-OUT args, if any

Line 815: okl_sif_stream_types_pub.validate_sif_stream_types(p_api_version,

811: );
812:
813:
814: -- here's the delegated call to the old PL/SQL routine
815: okl_sif_stream_types_pub.validate_sif_stream_types(p_api_version,
816: p_init_msg_list,
817: x_return_status,
818: x_msg_count,
819: x_msg_data,

Line 845: end okl_sif_stream_types_pub_w;

841: , p6_a11
842: );
843: end;
844:
845: end okl_sif_stream_types_pub_w;