APPS.OKL_PERD_STATUS_PVT_W dependencies on OKL_PERD_STATUS_PVT

Line 1: package body okl_perd_status_pvt_w as

1: package body okl_perd_status_pvt_w as
2: /* $Header: OKLEPSMB.pls 120.1 2005/07/11 14:19:25 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 22: procedure rosetta_table_copy_in_p1(t out nocopy okl_perd_status_pvt.period_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy okl_perd_status_pvt.period_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 91: procedure rosetta_table_copy_out_p1(t okl_perd_status_pvt.period_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

87: end loop;
88: end if;
89: end if;
90: end rosetta_table_copy_in_p1;
91: procedure rosetta_table_copy_out_p1(t okl_perd_status_pvt.period_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_DATE_TABLE
95: , a4 out nocopy JTF_NUMBER_TABLE

Line 300: ddp_period_rec okl_perd_status_pvt.period_rec_type;

296: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
297: )
298:
299: as
300: ddp_period_rec okl_perd_status_pvt.period_rec_type;
301: ddx_period_tbl okl_perd_status_pvt.period_tbl_type;
302: ddindx binary_integer; indx binary_integer;
303: begin
304:

Line 301: ddx_period_tbl okl_perd_status_pvt.period_tbl_type;

297: )
298:
299: as
300: ddp_period_rec okl_perd_status_pvt.period_rec_type;
301: ddx_period_tbl okl_perd_status_pvt.period_tbl_type;
302: ddindx binary_integer; indx binary_integer;
303: begin
304:
305: -- copy data to the local IN or IN-OUT args, if any

Line 340: okl_perd_status_pvt.search_period_status(p_api_version,

336: ddp_period_rec.elimination_confirmed_flag := p5_a25;
337:
338:
339: -- here's the delegated call to the old PL/SQL routine
340: okl_perd_status_pvt.search_period_status(p_api_version,
341: p_init_msg_list,
342: x_return_status,
343: x_msg_count,
344: x_msg_data,

Line 355: okl_perd_status_pvt_w.rosetta_table_copy_out_p1(ddx_period_tbl, p6_a0

351:
352:
353:
354:
355: okl_perd_status_pvt_w.rosetta_table_copy_out_p1(ddx_period_tbl, p6_a0
356: , p6_a1
357: , p6_a2
358: , p6_a3
359: , p6_a4

Line 418: ddp_period_tbl okl_perd_status_pvt.period_tbl_type;

414: , p5_a25 JTF_VARCHAR2_TABLE_100
415: )
416:
417: as
418: ddp_period_tbl okl_perd_status_pvt.period_tbl_type;
419: ddindx binary_integer; indx binary_integer;
420: begin
421:
422: -- copy data to the local IN or IN-OUT args, if any

Line 428: okl_perd_status_pvt_w.rosetta_table_copy_in_p1(ddp_period_tbl, p5_a0

424:
425:
426:
427:
428: okl_perd_status_pvt_w.rosetta_table_copy_in_p1(ddp_period_tbl, p5_a0
429: , p5_a1
430: , p5_a2
431: , p5_a3
432: , p5_a4

Line 457: okl_perd_status_pvt.update_period_status(p_api_version,

453: , p5_a25
454: );
455:
456: -- here's the delegated call to the old PL/SQL routine
457: okl_perd_status_pvt.update_period_status(p_api_version,
458: p_init_msg_list,
459: x_return_status,
460: x_msg_count,
461: x_msg_data,

Line 506: ddp_period_rec okl_perd_status_pvt.period_rec_type;

502: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
503: )
504:
505: as
506: ddp_period_rec okl_perd_status_pvt.period_rec_type;
507: ddindx binary_integer; indx binary_integer;
508: begin
509:
510: -- copy data to the local IN or IN-OUT args, if any

Line 544: okl_perd_status_pvt.update_perd_row(p_api_version,

540: ddp_period_rec.effective_period_num := rosetta_g_miss_num_map(p5_a24);
541: ddp_period_rec.elimination_confirmed_flag := p5_a25;
542:
543: -- here's the delegated call to the old PL/SQL routine
544: okl_perd_status_pvt.update_perd_row(p_api_version,
545: p_init_msg_list,
546: x_return_status,
547: x_msg_count,
548: x_msg_data,

Line 559: end okl_perd_status_pvt_w;

555:
556:
557: end;
558:
559: end okl_perd_status_pvt_w;