DBA Data[Home] [Help]

APPS.OKL_SETUPFMACONSTRAINTS_PUB_W dependencies on OKL_SETUPFMACONSTRAINTS_PUB

Line 1: package body okl_setupfmaconstraints_pub_w as

1: package body okl_setupfmaconstraints_pub_w as
2: /* $Header: OKLUSFCB.pls 120.1 2005/07/19 07:29:41 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 48: ddp_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;

44: , p0_a9 NUMBER := 0-1962.0724
45: )
46:
47: as
48: ddp_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
49: ddx_no_data_found boolean;
50: ddx_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
51: ddindx binary_integer; indx binary_integer;
52: begin

Line 50: ddx_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;

46:
47: as
48: ddp_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
49: ddx_no_data_found boolean;
50: ddx_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
51: ddindx binary_integer; indx binary_integer;
52: begin
53:
54: -- copy data to the local IN or IN-OUT args, if any

Line 71: okl_setupfmaconstraints_pub.get_rec(ddp_fodv_rec,

67:
68:
69:
70: -- here's the delegated call to the old PL/SQL routine
71: okl_setupfmaconstraints_pub.get_rec(ddp_fodv_rec,
72: x_return_status,
73: x_msg_data,
74: ddx_no_data_found,
75: ddx_fodv_rec);

Line 162: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;

158: , p6_a9 NUMBER := 0-1962.0724
159: )
160:
161: as
162: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;
163: ddp_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
164: ddx_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
165: ddindx binary_integer; indx binary_integer;
166: begin

Line 163: ddp_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;

159: )
160:
161: as
162: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;
163: ddp_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
164: ddx_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
165: ddindx binary_integer; indx binary_integer;
166: begin
167:

Line 164: ddx_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;

160:
161: as
162: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;
163: ddp_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
164: ddx_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
165: ddindx binary_integer; indx binary_integer;
166: begin
167:
168: -- copy data to the local IN or IN-OUT args, if any

Line 222: okl_setupfmaconstraints_pub.insert_fmaconstraints(p_api_version,

218: ddp_fodv_rec.last_update_login := rosetta_g_miss_num_map(p6_a9);
219:
220:
221: -- here's the delegated call to the old PL/SQL routine
222: okl_setupfmaconstraints_pub.insert_fmaconstraints(p_api_version,
223: p_init_msg_list,
224: x_return_status,
225: x_msg_count,
226: x_msg_data,

Line 313: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;

309: , p6_a9 NUMBER := 0-1962.0724
310: )
311:
312: as
313: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;
314: ddp_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
315: ddx_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
316: ddindx binary_integer; indx binary_integer;
317: begin

Line 314: ddp_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;

310: )
311:
312: as
313: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;
314: ddp_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
315: ddx_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
316: ddindx binary_integer; indx binary_integer;
317: begin
318:

Line 315: ddx_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;

311:
312: as
313: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;
314: ddp_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
315: ddx_fodv_rec okl_setupfmaconstraints_pub.fodv_rec_type;
316: ddindx binary_integer; indx binary_integer;
317: begin
318:
319: -- copy data to the local IN or IN-OUT args, if any

Line 373: okl_setupfmaconstraints_pub.update_fmaconstraints(p_api_version,

369: ddp_fodv_rec.last_update_login := rosetta_g_miss_num_map(p6_a9);
370:
371:
372: -- here's the delegated call to the old PL/SQL routine
373: okl_setupfmaconstraints_pub.update_fmaconstraints(p_api_version,
374: p_init_msg_list,
375: x_return_status,
376: x_msg_count,
377: x_msg_data,

Line 420: ddp_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;

416: , p5_a9 JTF_NUMBER_TABLE
417: )
418:
419: as
420: ddp_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;
421: ddindx binary_integer; indx binary_integer;
422: begin
423:
424: -- copy data to the local IN or IN-OUT args, if any

Line 443: okl_setupfmaconstraints_pub.delete_fmaconstraints(p_api_version,

439: , p5_a9
440: );
441:
442: -- here's the delegated call to the old PL/SQL routine
443: okl_setupfmaconstraints_pub.delete_fmaconstraints(p_api_version,
444: p_init_msg_list,
445: x_return_status,
446: x_msg_count,
447: x_msg_data,

Line 520: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;

516: , p5_a33 NUMBER := 0-1962.0724
517: )
518:
519: as
520: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;
521: ddp_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;
522: ddx_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;
523: ddindx binary_integer; indx binary_integer;
524: begin

Line 521: ddp_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;

517: )
518:
519: as
520: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;
521: ddp_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;
522: ddx_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;
523: ddindx binary_integer; indx binary_integer;
524: begin
525:

Line 522: ddx_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;

518:
519: as
520: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;
521: ddp_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;
522: ddx_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;
523: ddindx binary_integer; indx binary_integer;
524: begin
525:
526: -- copy data to the local IN or IN-OUT args, if any

Line 581: okl_setupfmaconstraints_pub.insert_fmaconstraints(p_api_version,

577: );
578:
579:
580: -- here's the delegated call to the old PL/SQL routine
581: okl_setupfmaconstraints_pub.insert_fmaconstraints(p_api_version,
582: p_init_msg_list,
583: x_return_status,
584: x_msg_count,
585: x_msg_data,

Line 673: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;

669: , p5_a33 NUMBER := 0-1962.0724
670: )
671:
672: as
673: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;
674: ddp_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;
675: ddx_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;
676: ddindx binary_integer; indx binary_integer;
677: begin

Line 674: ddp_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;

670: )
671:
672: as
673: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;
674: ddp_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;
675: ddx_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;
676: ddindx binary_integer; indx binary_integer;
677: begin
678:

Line 675: ddx_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;

671:
672: as
673: ddp_fmav_rec okl_setupfmaconstraints_pub.fmav_rec_type;
674: ddp_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;
675: ddx_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;
676: ddindx binary_integer; indx binary_integer;
677: begin
678:
679: -- copy data to the local IN or IN-OUT args, if any

Line 734: okl_setupfmaconstraints_pub.update_fmaconstraints(p_api_version,

730: );
731:
732:
733: -- here's the delegated call to the old PL/SQL routine
734: okl_setupfmaconstraints_pub.update_fmaconstraints(p_api_version,
735: p_init_msg_list,
736: x_return_status,
737: x_msg_count,
738: x_msg_data,

Line 764: end okl_setupfmaconstraints_pub_w;

760: , p7_a9
761: );
762: end;
763:
764: end okl_setupfmaconstraints_pub_w;