DBA Data[Home] [Help]

APPS.OKL_FE_STD_RATE_TMPL_PVT_W dependencies on OKL_FE_STD_RATE_TMPL_PVT

Line 1: package body okl_fe_std_rate_tmpl_pvt_w as

1: package body okl_fe_std_rate_tmpl_pvt_w as
2: /* $Header: OKLESRTB.pls 120.0 2005/07/07 10:37:59 viselvar noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy okl_fe_std_rate_tmpl_pvt.okl_number_table, a0 JTF_NUMBER_TABLE) as
4: ddindx binary_integer; indx binary_integer;
5: begin

Line 3: procedure rosetta_table_copy_in_p5(t out nocopy okl_fe_std_rate_tmpl_pvt.okl_number_table, a0 JTF_NUMBER_TABLE) as

1: package body okl_fe_std_rate_tmpl_pvt_w as
2: /* $Header: OKLESRTB.pls 120.0 2005/07/07 10:37:59 viselvar noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy okl_fe_std_rate_tmpl_pvt.okl_number_table, a0 JTF_NUMBER_TABLE) as
4: ddindx binary_integer; indx binary_integer;
5: begin
6: if a0 is not null and a0.count > 0 then
7: if a0.count > 0 then

Line 21: procedure rosetta_table_copy_out_p5(t okl_fe_std_rate_tmpl_pvt.okl_number_table, a0 out nocopy JTF_NUMBER_TABLE) as

17: end loop;
18: end if;
19: end if;
20: end rosetta_table_copy_in_p5;
21: procedure rosetta_table_copy_out_p5(t okl_fe_std_rate_tmpl_pvt.okl_number_table, a0 out nocopy JTF_NUMBER_TABLE) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_NUMBER_TABLE();

Line 44: procedure rosetta_table_copy_in_p8(t out nocopy okl_fe_std_rate_tmpl_pvt.invalid_object_tbl, a0 JTF_NUMBER_TABLE

40: end if;
41: end if;
42: end rosetta_table_copy_out_p5;
43:
44: procedure rosetta_table_copy_in_p8(t out nocopy okl_fe_std_rate_tmpl_pvt.invalid_object_tbl, a0 JTF_NUMBER_TABLE
45: , a1 JTF_VARCHAR2_TABLE_300
46: , a2 JTF_VARCHAR2_TABLE_100
47: , a3 JTF_VARCHAR2_TABLE_100
48: ) as

Line 69: procedure rosetta_table_copy_out_p8(t okl_fe_std_rate_tmpl_pvt.invalid_object_tbl, a0 out nocopy JTF_NUMBER_TABLE

65: end loop;
66: end if;
67: end if;
68: end rosetta_table_copy_in_p8;
69: procedure rosetta_table_copy_out_p8(t okl_fe_std_rate_tmpl_pvt.invalid_object_tbl, a0 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_VARCHAR2_TABLE_300
71: , a2 out nocopy JTF_VARCHAR2_TABLE_100
72: , a3 out nocopy JTF_VARCHAR2_TABLE_100
73: ) as

Line 250: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;

246: , p11_a35 out nocopy JTF_VARCHAR2_TABLE_500
247: )
248:
249: as
250: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
251: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
252: ddx_ech_rec okl_fe_std_rate_tmpl_pvt.okl_ech_rec;
253: ddx_ecl_tbl okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl;
254: ddx_ecv_tbl okl_fe_std_rate_tmpl_pvt.okl_ecv_tbl;

Line 251: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;

247: )
248:
249: as
250: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
251: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
252: ddx_ech_rec okl_fe_std_rate_tmpl_pvt.okl_ech_rec;
253: ddx_ecl_tbl okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl;
254: ddx_ecv_tbl okl_fe_std_rate_tmpl_pvt.okl_ecv_tbl;
255: ddindx binary_integer; indx binary_integer;

Line 252: ddx_ech_rec okl_fe_std_rate_tmpl_pvt.okl_ech_rec;

248:
249: as
250: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
251: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
252: ddx_ech_rec okl_fe_std_rate_tmpl_pvt.okl_ech_rec;
253: ddx_ecl_tbl okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl;
254: ddx_ecv_tbl okl_fe_std_rate_tmpl_pvt.okl_ecv_tbl;
255: ddindx binary_integer; indx binary_integer;
256: begin

Line 253: ddx_ecl_tbl okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl;

249: as
250: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
251: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
252: ddx_ech_rec okl_fe_std_rate_tmpl_pvt.okl_ech_rec;
253: ddx_ecl_tbl okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl;
254: ddx_ecv_tbl okl_fe_std_rate_tmpl_pvt.okl_ecv_tbl;
255: ddindx binary_integer; indx binary_integer;
256: begin
257:

Line 254: ddx_ecv_tbl okl_fe_std_rate_tmpl_pvt.okl_ecv_tbl;

250: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
251: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
252: ddx_ech_rec okl_fe_std_rate_tmpl_pvt.okl_ech_rec;
253: ddx_ecl_tbl okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl;
254: ddx_ecv_tbl okl_fe_std_rate_tmpl_pvt.okl_ecv_tbl;
255: ddindx binary_integer; indx binary_integer;
256: begin
257:
258: -- copy data to the local IN or IN-OUT args, if any

Line 272: okl_fe_std_rate_tmpl_pvt.get_version(p_api_version,

268:
269:
270:
271: -- here's the delegated call to the old PL/SQL routine
272: okl_fe_std_rate_tmpl_pvt.get_version(p_api_version,
273: p_init_msg_list,
274: x_return_status,
275: x_msg_count,
276: x_msg_data,

Line 574: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;

570: , p10_a35 out nocopy JTF_VARCHAR2_TABLE_500
571: )
572:
573: as
574: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
575: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
576: ddx_ech_rec okl_fe_std_rate_tmpl_pvt.okl_ech_rec;
577: ddx_ecl_tbl okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl;
578: ddx_ecv_tbl okl_fe_std_rate_tmpl_pvt.okl_ecv_tbl;

Line 575: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;

571: )
572:
573: as
574: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
575: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
576: ddx_ech_rec okl_fe_std_rate_tmpl_pvt.okl_ech_rec;
577: ddx_ecl_tbl okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl;
578: ddx_ecv_tbl okl_fe_std_rate_tmpl_pvt.okl_ecv_tbl;
579: ddindx binary_integer; indx binary_integer;

Line 576: ddx_ech_rec okl_fe_std_rate_tmpl_pvt.okl_ech_rec;

572:
573: as
574: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
575: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
576: ddx_ech_rec okl_fe_std_rate_tmpl_pvt.okl_ech_rec;
577: ddx_ecl_tbl okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl;
578: ddx_ecv_tbl okl_fe_std_rate_tmpl_pvt.okl_ecv_tbl;
579: ddindx binary_integer; indx binary_integer;
580: begin

Line 577: ddx_ecl_tbl okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl;

573: as
574: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
575: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
576: ddx_ech_rec okl_fe_std_rate_tmpl_pvt.okl_ech_rec;
577: ddx_ecl_tbl okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl;
578: ddx_ecv_tbl okl_fe_std_rate_tmpl_pvt.okl_ecv_tbl;
579: ddindx binary_integer; indx binary_integer;
580: begin
581:

Line 578: ddx_ecv_tbl okl_fe_std_rate_tmpl_pvt.okl_ecv_tbl;

574: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
575: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
576: ddx_ech_rec okl_fe_std_rate_tmpl_pvt.okl_ech_rec;
577: ddx_ecl_tbl okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl;
578: ddx_ecv_tbl okl_fe_std_rate_tmpl_pvt.okl_ecv_tbl;
579: ddindx binary_integer; indx binary_integer;
580: begin
581:
582: -- copy data to the local IN or IN-OUT args, if any

Line 595: okl_fe_std_rate_tmpl_pvt.get_version(p_api_version,

591:
592:
593:
594: -- here's the delegated call to the old PL/SQL routine
595: okl_fe_std_rate_tmpl_pvt.get_version(p_api_version,
596: p_init_msg_list,
597: x_return_status,
598: x_msg_count,
599: x_msg_data,

Line 830: ddp_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;

826: , p6_a33 out nocopy NUMBER
827: )
828:
829: as
830: ddp_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
831: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
832: ddindx binary_integer; indx binary_integer;
833: begin
834:

Line 831: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;

827: )
828:
829: as
830: ddp_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
831: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
832: ddindx binary_integer; indx binary_integer;
833: begin
834:
835: -- copy data to the local IN or IN-OUT args, if any

Line 878: okl_fe_std_rate_tmpl_pvt.create_version(p_api_version,

874: ddp_srv_rec.last_update_login := p5_a33;
875:
876:
877: -- here's the delegated call to the old PL/SQL routine
878: okl_fe_std_rate_tmpl_pvt.create_version(p_api_version,
879: p_init_msg_list,
880: x_return_status,
881: x_msg_count,
882: x_msg_data,

Line 1081: ddp_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;

1077: , p8_a33 out nocopy NUMBER
1078: )
1079:
1080: as
1081: ddp_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
1082: ddp_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
1083: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
1084: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
1085: ddindx binary_integer; indx binary_integer;

Line 1082: ddp_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;

1078: )
1079:
1080: as
1081: ddp_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
1082: ddp_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
1083: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
1084: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
1085: ddindx binary_integer; indx binary_integer;
1086: begin

Line 1083: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;

1079:
1080: as
1081: ddp_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
1082: ddp_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
1083: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
1084: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
1085: ddindx binary_integer; indx binary_integer;
1086: begin
1087:

Line 1084: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;

1080: as
1081: ddp_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
1082: ddp_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
1083: ddx_srtv_rec okl_fe_std_rate_tmpl_pvt.okl_srtv_rec;
1084: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
1085: ddindx binary_integer; indx binary_integer;
1086: begin
1087:
1088: -- copy data to the local IN or IN-OUT args, if any

Line 1171: okl_fe_std_rate_tmpl_pvt.insert_srt(p_api_version,

1167:
1168:
1169:
1170: -- here's the delegated call to the old PL/SQL routine
1171: okl_fe_std_rate_tmpl_pvt.insert_srt(p_api_version,
1172: p_init_msg_list,
1173: x_return_status,
1174: x_msg_count,
1175: x_msg_data,

Line 1340: ddp_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;

1336: , p6_a33 out nocopy NUMBER
1337: )
1338:
1339: as
1340: ddp_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
1341: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
1342: ddindx binary_integer; indx binary_integer;
1343: begin
1344:

Line 1341: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;

1337: )
1338:
1339: as
1340: ddp_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
1341: ddx_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
1342: ddindx binary_integer; indx binary_integer;
1343: begin
1344:
1345: -- copy data to the local IN or IN-OUT args, if any

Line 1388: okl_fe_std_rate_tmpl_pvt.update_srt(p_api_version,

1384: ddp_srv_rec.last_update_login := p5_a33;
1385:
1386:
1387: -- here's the delegated call to the old PL/SQL routine
1388: okl_fe_std_rate_tmpl_pvt.update_srt(p_api_version,
1389: p_init_msg_list,
1390: x_return_status,
1391: x_msg_count,
1392: x_msg_data,

Line 1452: ddx_obj_tbl okl_fe_std_rate_tmpl_pvt.invalid_object_tbl;

1448: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1449: )
1450:
1451: as
1452: ddx_obj_tbl okl_fe_std_rate_tmpl_pvt.invalid_object_tbl;
1453: ddindx binary_integer; indx binary_integer;
1454: begin
1455:
1456: -- copy data to the local IN or IN-OUT args, if any

Line 1465: okl_fe_std_rate_tmpl_pvt.invalid_objects(p_api_version,

1461:
1462:
1463:
1464: -- here's the delegated call to the old PL/SQL routine
1465: okl_fe_std_rate_tmpl_pvt.invalid_objects(p_api_version,
1466: p_init_msg_list,
1467: x_return_status,
1468: x_msg_count,
1469: x_msg_data,

Line 1480: okl_fe_std_rate_tmpl_pvt_w.rosetta_table_copy_out_p8(ddx_obj_tbl, p6_a0

1476:
1477:
1478:
1479:
1480: okl_fe_std_rate_tmpl_pvt_w.rosetta_table_copy_out_p8(ddx_obj_tbl, p6_a0
1481: , p6_a1
1482: , p6_a2
1483: , p6_a3
1484: );

Line 1530: ddp_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;

1526: , x_cal_eff_from out nocopy DATE
1527: )
1528:
1529: as
1530: ddp_srv_rec okl_fe_std_rate_tmpl_pvt.okl_srv_rec;
1531: ddindx binary_integer; indx binary_integer;
1532: begin
1533:
1534: -- copy data to the local IN or IN-OUT args, if any

Line 1577: okl_fe_std_rate_tmpl_pvt.calc_start_date(p_api_version,

1573: ddp_srv_rec.last_update_login := p5_a33;
1574:
1575:
1576: -- here's the delegated call to the old PL/SQL routine
1577: okl_fe_std_rate_tmpl_pvt.calc_start_date(p_api_version,
1578: p_init_msg_list,
1579: x_return_status,
1580: x_msg_count,
1581: x_msg_data,

Line 1604: ddp_srv_id_tbl okl_fe_std_rate_tmpl_pvt.okl_number_table;

1600: , p_end_date DATE
1601: )
1602:
1603: as
1604: ddp_srv_id_tbl okl_fe_std_rate_tmpl_pvt.okl_number_table;
1605: ddindx binary_integer; indx binary_integer;
1606: begin
1607:
1608: -- copy data to the local IN or IN-OUT args, if any

Line 1614: okl_fe_std_rate_tmpl_pvt_w.rosetta_table_copy_in_p5(ddp_srv_id_tbl, p_srv_id_tbl);

1610:
1611:
1612:
1613:
1614: okl_fe_std_rate_tmpl_pvt_w.rosetta_table_copy_in_p5(ddp_srv_id_tbl, p_srv_id_tbl);
1615:
1616:
1617: -- here's the delegated call to the old PL/SQL routine
1618: okl_fe_std_rate_tmpl_pvt.enddate_std_rate_tmpl(p_api_version,

Line 1618: okl_fe_std_rate_tmpl_pvt.enddate_std_rate_tmpl(p_api_version,

1614: okl_fe_std_rate_tmpl_pvt_w.rosetta_table_copy_in_p5(ddp_srv_id_tbl, p_srv_id_tbl);
1615:
1616:
1617: -- here's the delegated call to the old PL/SQL routine
1618: okl_fe_std_rate_tmpl_pvt.enddate_std_rate_tmpl(p_api_version,
1619: p_init_msg_list,
1620: x_return_status,
1621: x_msg_count,
1622: x_msg_data,

Line 1635: end okl_fe_std_rate_tmpl_pvt_w;

1631:
1632:
1633: end;
1634:
1635: end okl_fe_std_rate_tmpl_pvt_w;