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_RA_ANALYSER_PVT dependencies on MRP_ATP_PUB

Line 346: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

342: l_forecast_vwp_qty_tbl NumTabType;
343: l_forecast_non_qty_tbl NumTabType;
344:
345: -- For ATP Call - Check Availability API
346: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
347: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
348: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
349: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
350: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 347: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

343: l_forecast_non_qty_tbl NumTabType;
344:
345: -- For ATP Call - Check Availability API
346: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
347: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
348: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
349: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
350: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
351: l_session_id NUMBER;

Line 348: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

344:
345: -- For ATP Call - Check Availability API
346: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
347: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
348: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
349: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
350: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
351: l_session_id NUMBER;
352:

Line 349: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;

345: -- For ATP Call - Check Availability API
346: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
347: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
348: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
349: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
350: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
351: l_session_id NUMBER;
352:
353: -- Dummy PLSql table to fetch dummy forecast associations for population MRP with residual of 100% Probability.

Line 350: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;

346: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
347: x_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
348: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
349: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
350: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
351: l_session_id NUMBER;
352:
353: -- Dummy PLSql table to fetch dummy forecast associations for population MRP with residual of 100% Probability.
354: l_dummy_fct_desg_tbl Varchar10TabType;

Line 1581: l_atp_rec.Inventory_Item_Id := Mrp_Atp_Pub.number_arr(l_dtls_inv_item_id_tbl(j));

1577: RAISE FND_API.G_EXC_ERROR;
1578: END IF;
1579:
1580: --Assign values to input record for ATP api.
1581: l_atp_rec.Inventory_Item_Id := Mrp_Atp_Pub.number_arr(l_dtls_inv_item_id_tbl(j));
1582: l_atp_rec.Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));
1583: l_atp_rec.Source_Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));
1584: l_atp_rec.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(l_fs_arrival_date_tbl(i),'DD-MM-YYYY'));
1585: l_atp_rec.Quantity_Ordered := Mrp_Atp_Pub.number_arr(l_dtls_quantity_tbl(j));

Line 1582: l_atp_rec.Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));

1578: END IF;
1579:
1580: --Assign values to input record for ATP api.
1581: l_atp_rec.Inventory_Item_Id := Mrp_Atp_Pub.number_arr(l_dtls_inv_item_id_tbl(j));
1582: l_atp_rec.Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));
1583: l_atp_rec.Source_Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));
1584: l_atp_rec.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(l_fs_arrival_date_tbl(i),'DD-MM-YYYY'));
1585: l_atp_rec.Quantity_Ordered := Mrp_Atp_Pub.number_arr(l_dtls_quantity_tbl(j));
1586: l_atp_rec.Quantity_UOM := Mrp_Atp_Pub.char3_arr(l_dtls_uom_tbl(j));

Line 1583: l_atp_rec.Source_Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));

1579:
1580: --Assign values to input record for ATP api.
1581: l_atp_rec.Inventory_Item_Id := Mrp_Atp_Pub.number_arr(l_dtls_inv_item_id_tbl(j));
1582: l_atp_rec.Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));
1583: l_atp_rec.Source_Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));
1584: l_atp_rec.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(l_fs_arrival_date_tbl(i),'DD-MM-YYYY'));
1585: l_atp_rec.Quantity_Ordered := Mrp_Atp_Pub.number_arr(l_dtls_quantity_tbl(j));
1586: l_atp_rec.Quantity_UOM := Mrp_Atp_Pub.char3_arr(l_dtls_uom_tbl(j));
1587: l_atp_rec.Calling_Module := Mrp_Atp_Pub.number_arr(867);

Line 1584: l_atp_rec.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(l_fs_arrival_date_tbl(i),'DD-MM-YYYY'));

1580: --Assign values to input record for ATP api.
1581: l_atp_rec.Inventory_Item_Id := Mrp_Atp_Pub.number_arr(l_dtls_inv_item_id_tbl(j));
1582: l_atp_rec.Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));
1583: l_atp_rec.Source_Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));
1584: l_atp_rec.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(l_fs_arrival_date_tbl(i),'DD-MM-YYYY'));
1585: l_atp_rec.Quantity_Ordered := Mrp_Atp_Pub.number_arr(l_dtls_quantity_tbl(j));
1586: l_atp_rec.Quantity_UOM := Mrp_Atp_Pub.char3_arr(l_dtls_uom_tbl(j));
1587: l_atp_rec.Calling_Module := Mrp_Atp_Pub.number_arr(867);
1588: l_atp_rec.Action := Mrp_Atp_Pub.number_arr(100);

Line 1585: l_atp_rec.Quantity_Ordered := Mrp_Atp_Pub.number_arr(l_dtls_quantity_tbl(j));

1581: l_atp_rec.Inventory_Item_Id := Mrp_Atp_Pub.number_arr(l_dtls_inv_item_id_tbl(j));
1582: l_atp_rec.Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));
1583: l_atp_rec.Source_Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));
1584: l_atp_rec.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(l_fs_arrival_date_tbl(i),'DD-MM-YYYY'));
1585: l_atp_rec.Quantity_Ordered := Mrp_Atp_Pub.number_arr(l_dtls_quantity_tbl(j));
1586: l_atp_rec.Quantity_UOM := Mrp_Atp_Pub.char3_arr(l_dtls_uom_tbl(j));
1587: l_atp_rec.Calling_Module := Mrp_Atp_Pub.number_arr(867);
1588: l_atp_rec.Action := Mrp_Atp_Pub.number_arr(100);
1589: l_atp_rec.override_flag := Mrp_Atp_Pub.char1_arr('N');

Line 1586: l_atp_rec.Quantity_UOM := Mrp_Atp_Pub.char3_arr(l_dtls_uom_tbl(j));

1582: l_atp_rec.Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));
1583: l_atp_rec.Source_Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));
1584: l_atp_rec.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(l_fs_arrival_date_tbl(i),'DD-MM-YYYY'));
1585: l_atp_rec.Quantity_Ordered := Mrp_Atp_Pub.number_arr(l_dtls_quantity_tbl(j));
1586: l_atp_rec.Quantity_UOM := Mrp_Atp_Pub.char3_arr(l_dtls_uom_tbl(j));
1587: l_atp_rec.Calling_Module := Mrp_Atp_Pub.number_arr(867);
1588: l_atp_rec.Action := Mrp_Atp_Pub.number_arr(100);
1589: l_atp_rec.override_flag := Mrp_Atp_Pub.char1_arr('N');
1590:

Line 1587: l_atp_rec.Calling_Module := Mrp_Atp_Pub.number_arr(867);

1583: l_atp_rec.Source_Organization_Id := Mrp_Atp_Pub.number_arr(l_fs_arr_org_id_tbl(i));
1584: l_atp_rec.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(l_fs_arrival_date_tbl(i),'DD-MM-YYYY'));
1585: l_atp_rec.Quantity_Ordered := Mrp_Atp_Pub.number_arr(l_dtls_quantity_tbl(j));
1586: l_atp_rec.Quantity_UOM := Mrp_Atp_Pub.char3_arr(l_dtls_uom_tbl(j));
1587: l_atp_rec.Calling_Module := Mrp_Atp_Pub.number_arr(867);
1588: l_atp_rec.Action := Mrp_Atp_Pub.number_arr(100);
1589: l_atp_rec.override_flag := Mrp_Atp_Pub.char1_arr('N');
1590:
1591: SELECT mrp_atp_schedule_temp_s.NEXTVAL

Line 1588: l_atp_rec.Action := Mrp_Atp_Pub.number_arr(100);

1584: l_atp_rec.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(l_fs_arrival_date_tbl(i),'DD-MM-YYYY'));
1585: l_atp_rec.Quantity_Ordered := Mrp_Atp_Pub.number_arr(l_dtls_quantity_tbl(j));
1586: l_atp_rec.Quantity_UOM := Mrp_Atp_Pub.char3_arr(l_dtls_uom_tbl(j));
1587: l_atp_rec.Calling_Module := Mrp_Atp_Pub.number_arr(867);
1588: l_atp_rec.Action := Mrp_Atp_Pub.number_arr(100);
1589: l_atp_rec.override_flag := Mrp_Atp_Pub.char1_arr('N');
1590:
1591: SELECT mrp_atp_schedule_temp_s.NEXTVAL
1592: INTO l_dummy_identifier

Line 1589: l_atp_rec.override_flag := Mrp_Atp_Pub.char1_arr('N');

1585: l_atp_rec.Quantity_Ordered := Mrp_Atp_Pub.number_arr(l_dtls_quantity_tbl(j));
1586: l_atp_rec.Quantity_UOM := Mrp_Atp_Pub.char3_arr(l_dtls_uom_tbl(j));
1587: l_atp_rec.Calling_Module := Mrp_Atp_Pub.number_arr(867);
1588: l_atp_rec.Action := Mrp_Atp_Pub.number_arr(100);
1589: l_atp_rec.override_flag := Mrp_Atp_Pub.char1_arr('N');
1590:
1591: SELECT mrp_atp_schedule_temp_s.NEXTVAL
1592: INTO l_dummy_identifier
1593: from dual;

Line 1595: l_atp_rec.Identifier := Mrp_Atp_Pub.number_arr(l_dummy_identifier);

1591: SELECT mrp_atp_schedule_temp_s.NEXTVAL
1592: INTO l_dummy_identifier
1593: from dual;
1594:
1595: l_atp_rec.Identifier := Mrp_Atp_Pub.number_arr(l_dummy_identifier);
1596:
1597: IF (p_concurrent_flag = 'Y') THEN
1598: fnd_file.put_line(fnd_file.log, ' - B - Calling ATP API -- ' || l_dtls_inv_item_id_tbl(j));
1599: END IF;

Line 1604: MRP_ATP_PUB.Call_ATP (l_session_id,

1600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1601: fnd_log.string(fnd_log.level_statement,l_full_name,' -B- Calling ATP API -- ' || l_dtls_inv_item_id_tbl(j));
1602: END IF;
1603:
1604: MRP_ATP_PUB.Call_ATP (l_session_id,
1605: l_atp_rec,
1606: x_atp_rec ,
1607: x_atp_supply_demand ,
1608: x_atp_period,

Line 1617: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MRP_ATP_PUB.Call_ATP U Errored');

1613: );
1614:
1615: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1616: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1617: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MRP_ATP_PUB.Call_ATP U Errored');
1618: END IF;
1619: IF (p_concurrent_flag = 'Y') THEN
1620: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Hand Quantity --' || l_session_id);
1621: END IF;

Line 1625: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MRP_ATP_PUB.Call_ATP E Errored');

1621: END IF;
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1625: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MRP_ATP_PUB.Call_ATP E Errored');
1626: END IF;
1627: IF (p_concurrent_flag = 'Y') THEN
1628: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Hand Quantity --' || l_session_id);
1629: END IF;