APPS.AHL_LTP_REQST_MATRL_PUB_W dependencies on AHL_LTP_REQST_MATRL_PUB

Line 1: package body ahl_ltp_reqst_matrl_pub_w as

1: package body ahl_ltp_reqst_matrl_pub_w as
2: /* $Header: AHLWRMTB.pls 115.11 2004/04/12 17:08:13 ssurapan 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 13: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100

Line 90: procedure rosetta_table_copy_out_p3(t ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, a0 out nocopy JTF_NUMBER_TABLE

86: end loop;
87: end if;
88: end if;
89: end rosetta_table_copy_in_p3;
90: procedure rosetta_table_copy_out_p3(t ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_NUMBER_TABLE
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 259: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 JTF_NUMBER_TABLE

255: end if;
256: end if;
257: end rosetta_table_copy_out_p3;
258:
259: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
260: , a1 JTF_NUMBER_TABLE
261: , a2 JTF_NUMBER_TABLE
262: , a3 JTF_VARCHAR2_TABLE_100
263: , a4 JTF_NUMBER_TABLE

Line 306: procedure rosetta_table_copy_out_p4(t ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE

302: end loop;
303: end if;
304: end if;
305: end rosetta_table_copy_in_p4;
306: procedure rosetta_table_copy_out_p4(t ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
307: , a1 out nocopy JTF_NUMBER_TABLE
308: , a2 out nocopy JTF_NUMBER_TABLE
309: , a3 out nocopy JTF_VARCHAR2_TABLE_100
310: , a4 out nocopy JTF_NUMBER_TABLE

Line 400: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 JTF_NUMBER_TABLE

396: end if;
397: end if;
398: end rosetta_table_copy_out_p4;
399:
400: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 JTF_NUMBER_TABLE
401: , a1 JTF_NUMBER_TABLE
402: , a2 JTF_NUMBER_TABLE
403: , a3 JTF_NUMBER_TABLE
404: , a4 JTF_VARCHAR2_TABLE_100

Line 439: procedure rosetta_table_copy_out_p5(t ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 out nocopy JTF_NUMBER_TABLE

435: end loop;
436: end if;
437: end if;
438: end rosetta_table_copy_in_p5;
439: procedure rosetta_table_copy_out_p5(t ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 out nocopy JTF_NUMBER_TABLE
440: , a1 out nocopy JTF_NUMBER_TABLE
441: , a2 out nocopy JTF_NUMBER_TABLE
442: , a3 out nocopy JTF_NUMBER_TABLE
443: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 535: ddp_planned_materials_tbl ahl_ltp_reqst_matrl_pub.planned_materials_tbl;

531: , x_msg_data out nocopy VARCHAR2
532: )
533:
534: as
535: ddp_planned_materials_tbl ahl_ltp_reqst_matrl_pub.planned_materials_tbl;
536: ddindx binary_integer; indx binary_integer;
537: begin
538:
539: -- copy data to the local IN or IN-OUT args, if any

Line 545: ahl_ltp_reqst_matrl_pub_w.rosetta_table_copy_in_p5(ddp_planned_materials_tbl, p5_a0

541:
542:
543:
544:
545: ahl_ltp_reqst_matrl_pub_w.rosetta_table_copy_in_p5(ddp_planned_materials_tbl, p5_a0
546: , p5_a1
547: , p5_a2
548: , p5_a3
549: , p5_a4

Line 562: ahl_ltp_reqst_matrl_pub.update_planned_materials(p_api_version,

558:
559:
560:
561: -- here's the delegated call to the old PL/SQL routine
562: ahl_ltp_reqst_matrl_pub.update_planned_materials(p_api_version,
563: p_init_msg_list,
564: p_commit,
565: p_validation_level,
566: p_module_type,

Line 583: end ahl_ltp_reqst_matrl_pub_w;

579:
580:
581: end;
582:
583: end ahl_ltp_reqst_matrl_pub_w;