eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_LTP_MATRL_AVAL_PVT dependencies on AHL_LTP_MATRL_AVAL_PUB

Line 437: p_x_material_avl_tbl IN OUT NOCOPY ahl_ltp_matrl_aval_pub.Material_Availability_Tbl,

433: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
434: p_commit IN VARCHAR2 := FND_API.g_false,
435: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
436: p_module_type IN VARCHAR2 := 'JSP',
437: p_x_material_avl_tbl IN OUT NOCOPY ahl_ltp_matrl_aval_pub.Material_Availability_Tbl,
438: x_return_status OUT NOCOPY VARCHAR2,
439: x_msg_count OUT NOCOPY NUMBER,
440: x_msg_data OUT NOCOPY VARCHAR2
441: )

Line 715: x_task_req_matrl_tbl OUT NOCOPY ahl_ltp_matrl_aval_pub.task_req_matrl_tbl,

711: p_api_version IN NUMBER,
712: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
713: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
714: p_visit_id IN NUMBER,
715: x_task_req_matrl_tbl OUT NOCOPY ahl_ltp_matrl_aval_pub.task_req_matrl_tbl,
716: x_return_status OUT NOCOPY VARCHAR2,
717: x_msg_count OUT NOCOPY NUMBER,
718: x_msg_data OUT NOCOPY VARCHAR2)
719: IS

Line 949: p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,

945: PROCEDURE Call_ATP (
946: p_api_version IN NUMBER,
947: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
948: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
949: p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
950: x_return_status OUT NOCOPY VARCHAR2,
951: x_msg_count OUT NOCOPY NUMBER,
952: x_msg_data OUT NOCOPY VARCHAR2)
953: IS

Line 1017: l_temp_atp_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;

1013: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
1014: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;
1015: x_atp_period Mrp_Atp_Pub.ATP_Period_Typ;
1016: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;
1017: l_temp_atp_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
1018: l_error_msg VARCHAR2(2000);
1019: l_error_message VARCHAR2(80);
1020: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl := p_x_planned_matrl_tbl;
1021: l_scheduled_date DATE;

Line 1020: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl := p_x_planned_matrl_tbl;

1016: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;
1017: l_temp_atp_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
1018: l_error_msg VARCHAR2(2000);
1019: l_error_message VARCHAR2(80);
1020: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl := p_x_planned_matrl_tbl;
1021: l_scheduled_date DATE;
1022: l_scheduled_quantity NUMBER;
1023: l_Planned_Order_Rec Planned_Order_Cur%ROWTYPE;
1024: --Required to capture available quantity and scheduled quanity

Line 1025: l_temp_planned_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;

1021: l_scheduled_date DATE;
1022: l_scheduled_quantity NUMBER;
1023: l_Planned_Order_Rec Planned_Order_Cur%ROWTYPE;
1024: --Required to capture available quantity and scheduled quanity
1025: l_temp_planned_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
1026: l_order_number NUMBER;
1027:
1028: BEGIN
1029:

Line 1387: p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,

1383: p_api_version IN NUMBER,
1384: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1385: p_commit IN VARCHAR2 := FND_API.g_false,
1386: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1387: p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
1388: x_return_status OUT NOCOPY VARCHAR2,
1389: x_msg_count OUT NOCOPY NUMBER,
1390: x_msg_data OUT NOCOPY VARCHAR2)
1391: IS

Line 1477: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl := p_x_planned_matrl_tbl;

1473: l_return_status VARCHAR2(1);
1474: l_msg_data VARCHAR2(2000);
1475: l_msg_count NUMBER;
1476:
1477: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl := p_x_planned_matrl_tbl;
1478: l_Sch_Material_Rec Sch_Material_Cur%ROWTYPE;
1479: l_Planned_Material_Rec Planned_Material_Cur%ROWTYPE;
1480: l_temp_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
1481: j NUMBER := 1;

Line 1480: l_temp_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;

1476:
1477: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl := p_x_planned_matrl_tbl;
1478: l_Sch_Material_Rec Sch_Material_Cur%ROWTYPE;
1479: l_Planned_Material_Rec Planned_Material_Cur%ROWTYPE;
1480: l_temp_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
1481: j NUMBER := 1;
1482: BEGIN
1483:
1484: IF (l_log_procedure >= l_log_current_level) THEN

Line 1703: x_planned_matrl_tbl OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,

1699: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1700: p_commit IN VARCHAR2 := FND_API.g_false,
1701: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1702: p_visit_id IN NUMBER,
1703: x_planned_matrl_tbl OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
1704: x_return_status OUT NOCOPY VARCHAR2,
1705: x_msg_count OUT NOCOPY NUMBER,
1706: x_msg_data OUT NOCOPY VARCHAR2)
1707: IS

Line 1742: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;

1738: l_return_status VARCHAR2(1);
1739: l_msg_data VARCHAR2(2000);
1740: l_msg_count NUMBER;
1741: --
1742: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
1743: l_Visit_Task_Matrl_Rec Get_Visit_Task_Matrl_Cur%ROWTYPE;
1744: i NUMBER;
1745: BEGIN
1746:

Line 1921: p_deleted_matrl_tbl IN AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,

1917: --
1918: PROCEDURE Unschedule_deleted_materials (
1919: p_api_version IN NUMBER,
1920: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1921: p_deleted_matrl_tbl IN AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
1922: x_return_status OUT NOCOPY VARCHAR2,
1923: x_msg_count OUT NOCOPY NUMBER,
1924: x_msg_data OUT NOCOPY VARCHAR2)
1925: IS