APPS.AHL_LTP_RESRC_LEVL_PUB_W dependencies on AHL_LTP_RESRC_LEVL_PUB

Line 1: package body ahl_ltp_resrc_levl_pub_w as

1: package body ahl_ltp_resrc_levl_pub_w as
2: /* $Header: AHLWRLGB.pls 120.2 2006/05/04 07:41 anraj 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 JTF_VARCHAR2_TABLE_100

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_DATE_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100

Line 53: procedure rosetta_table_copy_out_p3(t ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

49: end loop;
50: end if;
51: end if;
52: end rosetta_table_copy_in_p3;
53: procedure rosetta_table_copy_out_p3(t ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , a1 out nocopy JTF_DATE_TABLE
55: , a2 out nocopy JTF_DATE_TABLE
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE

118: end if;
119: end if;
120: end rosetta_table_copy_out_p3;
121:
122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_VARCHAR2_TABLE_100
125: , a3 JTF_VARCHAR2_TABLE_100
126: , a4 JTF_VARCHAR2_TABLE_100

Line 157: procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE

153: end loop;
154: end if;
155: end if;
156: end rosetta_table_copy_in_p4;
157: procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 256: ddp_req_resources ahl_ltp_resrc_levl_pub.req_resources_rec;

252: , x_msg_data out nocopy VARCHAR2
253: )
254:
255: as
256: ddp_req_resources ahl_ltp_resrc_levl_pub.req_resources_rec;
257: ddx_aval_resources_tbl ahl_ltp_resrc_levl_pub.aval_resources_tbl;
258: ddindx binary_integer; indx binary_integer;
259: begin
260:

Line 257: ddx_aval_resources_tbl ahl_ltp_resrc_levl_pub.aval_resources_tbl;

253: )
254:
255: as
256: ddp_req_resources ahl_ltp_resrc_levl_pub.req_resources_rec;
257: ddx_aval_resources_tbl ahl_ltp_resrc_levl_pub.aval_resources_tbl;
258: ddindx binary_integer; indx binary_integer;
259: begin
260:
261: -- copy data to the local IN or IN-OUT args, if any

Line 287: ahl_ltp_resrc_levl_pub.derive_resource_capacity(p_api_version,

283:
284:
285:
286: -- here's the delegated call to the old PL/SQL routine
287: ahl_ltp_resrc_levl_pub.derive_resource_capacity(p_api_version,
288: p_init_msg_list,
289: p_commit,
290: p_validation_level,
291: p_module_type,

Line 305: ahl_ltp_resrc_levl_pub_w.rosetta_table_copy_out_p3(ddx_aval_resources_tbl, p6_a0

301:
302:
303:
304:
305: ahl_ltp_resrc_levl_pub_w.rosetta_table_copy_out_p3(ddx_aval_resources_tbl, p6_a0
306: , p6_a1
307: , p6_a2
308: , p6_a3
309: , p6_a4

Line 355: ddp_req_resources ahl_ltp_resrc_levl_pub.req_resources_rec;

351: , x_msg_data out nocopy VARCHAR2
352: )
353:
354: as
355: ddp_req_resources ahl_ltp_resrc_levl_pub.req_resources_rec;
356: ddx_resource_con_tbl ahl_ltp_resrc_levl_pub.resource_con_tbl;
357: ddindx binary_integer; indx binary_integer;
358: begin
359:

Line 356: ddx_resource_con_tbl ahl_ltp_resrc_levl_pub.resource_con_tbl;

352: )
353:
354: as
355: ddp_req_resources ahl_ltp_resrc_levl_pub.req_resources_rec;
356: ddx_resource_con_tbl ahl_ltp_resrc_levl_pub.resource_con_tbl;
357: ddindx binary_integer; indx binary_integer;
358: begin
359:
360: -- copy data to the local IN or IN-OUT args, if any

Line 386: ahl_ltp_resrc_levl_pub.derive_resource_consum(p_api_version,

382:
383:
384:
385: -- here's the delegated call to the old PL/SQL routine
386: ahl_ltp_resrc_levl_pub.derive_resource_consum(p_api_version,
387: p_init_msg_list,
388: p_commit,
389: p_validation_level,
390: p_module_type,

Line 404: ahl_ltp_resrc_levl_pub_w.rosetta_table_copy_out_p4(ddx_resource_con_tbl, p6_a0

400:
401:
402:
403:
404: ahl_ltp_resrc_levl_pub_w.rosetta_table_copy_out_p4(ddx_resource_con_tbl, p6_a0
405: , p6_a1
406: , p6_a2
407: , p6_a3
408: , p6_a4

Line 419: end ahl_ltp_resrc_levl_pub_w;

415:
416:
417: end;
418:
419: end ahl_ltp_resrc_levl_pub_w;