DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on MRP_ATP_PUB

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

137: ,X_MSG_DATA OUT NOCOPY VARCHAR2
138: ,x_msg_count OUT NOCOPY NUMBER);
139:
140:
141: PROCEDURE EXTEND_ATP_REC(p_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_REC_TYP
142: ,x_return_status OUT NOCOPY VARCHAR2);
143:
144: /*PROCEDURE GET_TIME_COST(p_eligible_resources_list IN CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE
145: ,x_options OUT NOCOPY CSP_SCH_INT_PVT.csp_sch_options_tab_typ

Line 4199: l_atp_rec mrp_atp_pub.atp_rec_typ;

4195: and assignment_set_id = c_assignment_id
4196: and inventory_item_id = c_item_id
4197: and sourcing_level not in (2,9));
4198:
4199: l_atp_rec mrp_atp_pub.atp_rec_typ;
4200: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
4201: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
4202: l_atp_period mrp_atp_pub.atp_period_typ;
4203: l_atp_details mrp_atp_pub.atp_details_typ;

Line 4200: l_atp_rec_out mrp_atp_pub.atp_rec_typ;

4196: and inventory_item_id = c_item_id
4197: and sourcing_level not in (2,9));
4198:
4199: l_atp_rec mrp_atp_pub.atp_rec_typ;
4200: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
4201: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
4202: l_atp_period mrp_atp_pub.atp_period_typ;
4203: l_atp_details mrp_atp_pub.atp_details_typ;
4204: l_mrp_database_link VARCHAR2(128);

Line 4201: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;

4197: and sourcing_level not in (2,9));
4198:
4199: l_atp_rec mrp_atp_pub.atp_rec_typ;
4200: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
4201: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
4202: l_atp_period mrp_atp_pub.atp_period_typ;
4203: l_atp_details mrp_atp_pub.atp_details_typ;
4204: l_mrp_database_link VARCHAR2(128);
4205: l_statement VARCHAR2(500);

Line 4202: l_atp_period mrp_atp_pub.atp_period_typ;

4198:
4199: l_atp_rec mrp_atp_pub.atp_rec_typ;
4200: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
4201: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
4202: l_atp_period mrp_atp_pub.atp_period_typ;
4203: l_atp_details mrp_atp_pub.atp_details_typ;
4204: l_mrp_database_link VARCHAR2(128);
4205: l_statement VARCHAR2(500);
4206: l_session_id NUMBER;

Line 4203: l_atp_details mrp_atp_pub.atp_details_typ;

4199: l_atp_rec mrp_atp_pub.atp_rec_typ;
4200: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
4201: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
4202: l_atp_period mrp_atp_pub.atp_period_typ;
4203: l_atp_details mrp_atp_pub.atp_details_typ;
4204: l_mrp_database_link VARCHAR2(128);
4205: l_statement VARCHAR2(500);
4206: l_session_id NUMBER;
4207: l_return_status VARCHAR2(128);

Line 4277: log('do_atp_check', 'calling MRP_ATP_PUB.CALL_ATP');

4273: l_atp_rec.ship_set_name(I) := p_unavailable_list(I).ship_set_name;
4274: END IF;
4275: END LOOP;
4276: savepoint csp_msc_atp_check;
4277: log('do_atp_check', 'calling MRP_ATP_PUB.CALL_ATP');
4278: MRP_ATP_PUB.CALL_ATP(l_session_id,
4279: l_atp_rec,
4280: l_atp_rec_out,
4281: l_atp_supply_demand,

Line 4278: MRP_ATP_PUB.CALL_ATP(l_session_id,

4274: END IF;
4275: END LOOP;
4276: savepoint csp_msc_atp_check;
4277: log('do_atp_check', 'calling MRP_ATP_PUB.CALL_ATP');
4278: MRP_ATP_PUB.CALL_ATP(l_session_id,
4279: l_atp_rec,
4280: l_atp_rec_out,
4281: l_atp_supply_demand,
4282: l_atp_period,

Line 4287: log('do_atp_check', 'after MRP_ATP_PUB.CALL_ATP');

4283: l_atp_details,
4284: x_return_status,
4285: x_msg_data,
4286: x_msg_count);
4287: log('do_atp_check', 'after MRP_ATP_PUB.CALL_ATP');
4288: log('do_atp_check', 'x_return_status: '||x_return_status);
4289: log('do_atp_check', 'x_msg_data: '||x_msg_data);
4290: log('do_atp_check', 'x_msg_count: '||x_msg_count);
4291: l_msg := FND_MSG_PUB.Get(1,FND_API.G_FALSE) ;

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

5723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5724: return;
5725: END GET_DELIVERY_DATE;
5726:
5727: PROCEDURE EXTEND_ATP_REC(p_atp_rec IN OUT NOCOPY mrp_atp_pub.atp_rec_typ
5728: ,x_return_status OUT NOCOPY VARCHAR2) IS
5729:
5730: BEGIN
5731: x_return_status := FND_API.G_RET_STS_SUCCESS;