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 420: p_x_material_avl_tbl IN OUT NOCOPY ahl_ltp_matrl_aval_pub.Material_Availability_Tbl,

416: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
417: p_commit IN VARCHAR2 := FND_API.g_false,
418: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
419: p_module_type IN VARCHAR2 := 'JSP',
420: p_x_material_avl_tbl IN OUT NOCOPY ahl_ltp_matrl_aval_pub.Material_Availability_Tbl,
421: x_return_status OUT NOCOPY VARCHAR2,
422: x_msg_count OUT NOCOPY NUMBER,
423: x_msg_data OUT NOCOPY VARCHAR2
424: )

Line 691: x_task_req_matrl_tbl OUT NOCOPY ahl_ltp_matrl_aval_pub.task_req_matrl_tbl,

687: p_api_version IN NUMBER,
688: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
689: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
690: p_visit_id IN NUMBER,
691: x_task_req_matrl_tbl OUT NOCOPY ahl_ltp_matrl_aval_pub.task_req_matrl_tbl,
692: x_return_status OUT NOCOPY VARCHAR2,
693: x_msg_count OUT NOCOPY NUMBER,
694: x_msg_data OUT NOCOPY VARCHAR2)
695: IS

Line 923: p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,

919: PROCEDURE Call_ATP (
920: p_api_version IN NUMBER,
921: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
922: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
923: p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
924: x_return_status OUT NOCOPY VARCHAR2,
925: x_msg_count OUT NOCOPY NUMBER,
926: x_msg_data OUT NOCOPY VARCHAR2)
927: IS

Line 989: l_temp_atp_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;

985: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
986: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;
987: x_atp_period Mrp_Atp_Pub.ATP_Period_Typ;
988: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;
989: l_temp_atp_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
990: l_error_msg VARCHAR2(2000);
991: l_error_message VARCHAR2(80);
992: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl := p_x_planned_matrl_tbl;
993: l_scheduled_date DATE;

Line 992: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl := p_x_planned_matrl_tbl;

988: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;
989: l_temp_atp_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
990: l_error_msg VARCHAR2(2000);
991: l_error_message VARCHAR2(80);
992: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl := p_x_planned_matrl_tbl;
993: l_scheduled_date DATE;
994: l_scheduled_quantity NUMBER;
995: l_Planned_Order_Rec Planned_Order_Cur%ROWTYPE;
996: --Required to capture available quantity and scheduled quanity

Line 997: l_temp_planned_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;

993: l_scheduled_date DATE;
994: l_scheduled_quantity NUMBER;
995: l_Planned_Order_Rec Planned_Order_Cur%ROWTYPE;
996: --Required to capture available quantity and scheduled quanity
997: l_temp_planned_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
998: l_order_number NUMBER;
999:
1000: BEGIN
1001:

Line 1333: p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,

1329: p_api_version IN NUMBER,
1330: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1331: p_commit IN VARCHAR2 := FND_API.g_false,
1332: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1333: p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
1334: x_return_status OUT NOCOPY VARCHAR2,
1335: x_msg_count OUT NOCOPY NUMBER,
1336: x_msg_data OUT NOCOPY VARCHAR2)
1337: IS

Line 1378: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl := p_x_planned_matrl_tbl;

1374: l_return_status VARCHAR2(1);
1375: l_msg_data VARCHAR2(2000);
1376: l_msg_count NUMBER;
1377:
1378: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl := p_x_planned_matrl_tbl;
1379: l_Sch_Material_Rec Sch_Material_Cur%ROWTYPE;
1380: l_Planned_Material_Rec Planned_Material_Cur%ROWTYPE;
1381: l_temp_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
1382: j NUMBER := 1;

Line 1381: l_temp_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;

1377:
1378: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl := p_x_planned_matrl_tbl;
1379: l_Sch_Material_Rec Sch_Material_Cur%ROWTYPE;
1380: l_Planned_Material_Rec Planned_Material_Cur%ROWTYPE;
1381: l_temp_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
1382: j NUMBER := 1;
1383: BEGIN
1384:
1385: IF (l_log_procedure >= l_log_current_level) THEN

Line 1602: x_planned_matrl_tbl OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,

1598: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1599: p_commit IN VARCHAR2 := FND_API.g_false,
1600: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1601: p_visit_id IN NUMBER,
1602: x_planned_matrl_tbl OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
1603: x_return_status OUT NOCOPY VARCHAR2,
1604: x_msg_count OUT NOCOPY NUMBER,
1605: x_msg_data OUT NOCOPY VARCHAR2)
1606: IS

Line 1639: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;

1635: l_return_status VARCHAR2(1);
1636: l_msg_data VARCHAR2(2000);
1637: l_msg_count NUMBER;
1638: --
1639: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
1640: l_Visit_Task_Matrl_Rec Get_Visit_Task_Matrl_Cur%ROWTYPE;
1641: i NUMBER;
1642: BEGIN
1643: