DBA Data[Home] [Help]

APPS.OKL_SETUPFMACONSTRAINTS_PVT_W dependencies on OKL_SETUPFMACONSTRAINTS_PVT

Line 1: package body okl_setupfmaconstraints_pvt_w as

1: package body okl_setupfmaconstraints_pvt_w as
2: /* $Header: OKLESFCB.pls 120.1 2005/07/12 09:09:21 dkagrawa 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 47: ddp_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;

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

Line 49: ddx_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;

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

Line 69: okl_setupfmaconstraints_pvt.get_rec(ddp_fodv_rec,

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

Line 158: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;

154: , p6_a9 NUMBER := 0-1962.0724
155: )
156:
157: as
158: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;
159: ddp_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;
160: ddx_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;
161: ddindx binary_integer; indx binary_integer;
162: begin

Line 159: ddp_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;

155: )
156:
157: as
158: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;
159: ddp_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;
160: ddx_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;
161: ddindx binary_integer; indx binary_integer;
162: begin
163:

Line 160: ddx_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;

156:
157: as
158: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;
159: ddp_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;
160: ddx_fodv_rec okl_setupfmaconstraints_pvt.fodv_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 218: okl_setupfmaconstraints_pvt.insert_fmaconstraints(p_api_version,

214: ddp_fodv_rec.last_update_login := rosetta_g_miss_num_map(p6_a9);
215:
216:
217: -- here's the delegated call to the old PL/SQL routine
218: okl_setupfmaconstraints_pvt.insert_fmaconstraints(p_api_version,
219: p_init_msg_list,
220: x_return_status,
221: x_msg_count,
222: x_msg_data,

Line 309: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;

305: , p6_a9 NUMBER := 0-1962.0724
306: )
307:
308: as
309: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;
310: ddp_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;
311: ddx_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;
312: ddindx binary_integer; indx binary_integer;
313: begin

Line 310: ddp_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;

306: )
307:
308: as
309: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;
310: ddp_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;
311: ddx_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;
312: ddindx binary_integer; indx binary_integer;
313: begin
314:

Line 311: ddx_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;

307:
308: as
309: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;
310: ddp_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;
311: ddx_fodv_rec okl_setupfmaconstraints_pvt.fodv_rec_type;
312: ddindx binary_integer; indx binary_integer;
313: begin
314:
315: -- copy data to the local IN or IN-OUT args, if any

Line 369: okl_setupfmaconstraints_pvt.update_fmaconstraints(p_api_version,

365: ddp_fodv_rec.last_update_login := rosetta_g_miss_num_map(p6_a9);
366:
367:
368: -- here's the delegated call to the old PL/SQL routine
369: okl_setupfmaconstraints_pvt.update_fmaconstraints(p_api_version,
370: p_init_msg_list,
371: x_return_status,
372: x_msg_count,
373: x_msg_data,

Line 416: ddp_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;

412: , p5_a9 JTF_NUMBER_TABLE
413: )
414:
415: as
416: ddp_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;
417: ddindx binary_integer; indx binary_integer;
418: begin
419:
420: -- copy data to the local IN or IN-OUT args, if any

Line 439: okl_setupfmaconstraints_pvt.delete_fmaconstraints(p_api_version,

435: , p5_a9
436: );
437:
438: -- here's the delegated call to the old PL/SQL routine
439: okl_setupfmaconstraints_pvt.delete_fmaconstraints(p_api_version,
440: p_init_msg_list,
441: x_return_status,
442: x_msg_count,
443: x_msg_data,

Line 516: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;

512: , p5_a33 NUMBER := 0-1962.0724
513: )
514:
515: as
516: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;
517: ddp_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;
518: ddx_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;
519: ddindx binary_integer; indx binary_integer;
520: begin

Line 517: ddp_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;

513: )
514:
515: as
516: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;
517: ddp_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;
518: ddx_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;
519: ddindx binary_integer; indx binary_integer;
520: begin
521:

Line 518: ddx_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;

514:
515: as
516: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;
517: ddp_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;
518: ddx_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;
519: ddindx binary_integer; indx binary_integer;
520: begin
521:
522: -- copy data to the local IN or IN-OUT args, if any

Line 577: okl_setupfmaconstraints_pvt.insert_fmaconstraints(p_api_version,

573: );
574:
575:
576: -- here's the delegated call to the old PL/SQL routine
577: okl_setupfmaconstraints_pvt.insert_fmaconstraints(p_api_version,
578: p_init_msg_list,
579: x_return_status,
580: x_msg_count,
581: x_msg_data,

Line 669: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;

665: , p5_a33 NUMBER := 0-1962.0724
666: )
667:
668: as
669: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;
670: ddp_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;
671: ddx_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;
672: ddindx binary_integer; indx binary_integer;
673: begin

Line 670: ddp_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;

666: )
667:
668: as
669: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;
670: ddp_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;
671: ddx_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;
672: ddindx binary_integer; indx binary_integer;
673: begin
674:

Line 671: ddx_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;

667:
668: as
669: ddp_fmav_rec okl_setupfmaconstraints_pvt.fmav_rec_type;
670: ddp_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;
671: ddx_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;
672: ddindx binary_integer; indx binary_integer;
673: begin
674:
675: -- copy data to the local IN or IN-OUT args, if any

Line 730: okl_setupfmaconstraints_pvt.update_fmaconstraints(p_api_version,

726: );
727:
728:
729: -- here's the delegated call to the old PL/SQL routine
730: okl_setupfmaconstraints_pvt.update_fmaconstraints(p_api_version,
731: p_init_msg_list,
732: x_return_status,
733: x_msg_count,
734: x_msg_data,

Line 760: end okl_setupfmaconstraints_pvt_w;

756: , p7_a9
757: );
758: end;
759:
760: end okl_setupfmaconstraints_pvt_w;