DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on MRP_ATP_PUB

Line 120: PROCEDURE EXTEND_ATP_REC(p_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_REC_TYP

116: ,X_MSG_DATA OUT NOCOPY VARCHAR2
117: ,x_msg_count OUT NOCOPY NUMBER);
118:
119:
120: PROCEDURE EXTEND_ATP_REC(p_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_REC_TYP
121: ,x_return_status OUT NOCOPY VARCHAR2);
122:
123: /*PROCEDURE GET_TIME_COST(p_eligible_resources_list IN CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE
124: ,x_options OUT NOCOPY CSP_SCH_INT_PVT.csp_sch_options_tab_typ

Line 1959: l_atp_rec mrp_atp_pub.atp_rec_typ;

1955: and assignment_set_id = c_assignment_id
1956: and inventory_item_id = c_item_id
1957: and sourcing_level not in (2,9));
1958:
1959: l_atp_rec mrp_atp_pub.atp_rec_typ;
1960: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
1961: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
1962: l_atp_period mrp_atp_pub.atp_period_typ;
1963: l_atp_details mrp_atp_pub.atp_details_typ;

Line 1960: l_atp_rec_out mrp_atp_pub.atp_rec_typ;

1956: and inventory_item_id = c_item_id
1957: and sourcing_level not in (2,9));
1958:
1959: l_atp_rec mrp_atp_pub.atp_rec_typ;
1960: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
1961: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
1962: l_atp_period mrp_atp_pub.atp_period_typ;
1963: l_atp_details mrp_atp_pub.atp_details_typ;
1964: l_mrp_database_link VARCHAR2(128);

Line 1961: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;

1957: and sourcing_level not in (2,9));
1958:
1959: l_atp_rec mrp_atp_pub.atp_rec_typ;
1960: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
1961: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
1962: l_atp_period mrp_atp_pub.atp_period_typ;
1963: l_atp_details mrp_atp_pub.atp_details_typ;
1964: l_mrp_database_link VARCHAR2(128);
1965: l_statement VARCHAR2(500);

Line 1962: l_atp_period mrp_atp_pub.atp_period_typ;

1958:
1959: l_atp_rec mrp_atp_pub.atp_rec_typ;
1960: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
1961: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
1962: l_atp_period mrp_atp_pub.atp_period_typ;
1963: l_atp_details mrp_atp_pub.atp_details_typ;
1964: l_mrp_database_link VARCHAR2(128);
1965: l_statement VARCHAR2(500);
1966: l_session_id NUMBER;

Line 1963: l_atp_details mrp_atp_pub.atp_details_typ;

1959: l_atp_rec mrp_atp_pub.atp_rec_typ;
1960: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
1961: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
1962: l_atp_period mrp_atp_pub.atp_period_typ;
1963: l_atp_details mrp_atp_pub.atp_details_typ;
1964: l_mrp_database_link VARCHAR2(128);
1965: l_statement VARCHAR2(500);
1966: l_session_id NUMBER;
1967: l_return_status VARCHAR2(128);

Line 2029: MRP_ATP_PUB.CALL_ATP(l_session_id,

2025: l_atp_rec.ship_set_name(I) := p_unavailable_list(I).ship_set_name;
2026: END IF;
2027: END LOOP;
2028: savepoint csp_msc_atp_check;
2029: MRP_ATP_PUB.CALL_ATP(l_session_id,
2030: l_atp_rec,
2031: l_atp_rec_out,
2032: l_atp_supply_demand,
2033: l_atp_period,

Line 3333: PROCEDURE EXTEND_ATP_REC(p_atp_rec IN OUT NOCOPY mrp_atp_pub.atp_rec_typ

3329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3330: return;
3331: END GET_DELIVERY_DATE;
3332:
3333: PROCEDURE EXTEND_ATP_REC(p_atp_rec IN OUT NOCOPY mrp_atp_pub.atp_rec_typ
3334: ,x_return_status OUT NOCOPY VARCHAR2) IS
3335:
3336: BEGIN
3337: x_return_status := FND_API.G_RET_STS_SUCCESS;