DBA Data[Home] [Help]

APPS.ASO_ATP_INT dependencies on MRP_ATP_PUB

Line 67: PROCEDURE Extend_ATP (p_atp_tbl IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

63:
64:
65:
66:
67: PROCEDURE Extend_ATP (p_atp_tbl IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
68: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
69: IS
70: BEGIN
71: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 120: PROCEDURE Populate_Output_Table( p_atp_rec IN MRP_ATP_PUB.ATP_REC_TYP,

116:
117: END Extend_ATP;
118:
119:
120: PROCEDURE Populate_Output_Table( p_atp_rec IN MRP_ATP_PUB.ATP_REC_TYP,
121: x_aso_atp_tbl OUT NOCOPY ASO_ATP_INT.ATP_TBL_TYP,
122: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
123: AS
124:

Line 401: l_atp_rec mrp_atp_pub.atp_rec_typ;

397: l_api_version_number CONSTANT NUMBER := 1.0;
398:
399: l_session_id number;
400: l_sysdate date;
401: l_atp_rec mrp_atp_pub.atp_rec_typ;
402: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
403: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
404: l_atp_period mrp_atp_pub.atp_period_typ;
405: l_atp_details mrp_atp_pub.atp_details_typ;

Line 402: l_atp_rec_out mrp_atp_pub.atp_rec_typ;

398:
399: l_session_id number;
400: l_sysdate date;
401: l_atp_rec mrp_atp_pub.atp_rec_typ;
402: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
403: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
404: l_atp_period mrp_atp_pub.atp_period_typ;
405: l_atp_details mrp_atp_pub.atp_details_typ;
406: l_null_aso_atp_typ aso_atp_int.atp_rec_typ;

Line 403: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;

399: l_session_id number;
400: l_sysdate date;
401: l_atp_rec mrp_atp_pub.atp_rec_typ;
402: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
403: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
404: l_atp_period mrp_atp_pub.atp_period_typ;
405: l_atp_details mrp_atp_pub.atp_details_typ;
406: l_null_aso_atp_typ aso_atp_int.atp_rec_typ;
407: l_mrp_database_link Varchar2(128);

Line 404: l_atp_period mrp_atp_pub.atp_period_typ;

400: l_sysdate date;
401: l_atp_rec mrp_atp_pub.atp_rec_typ;
402: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
403: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
404: l_atp_period mrp_atp_pub.atp_period_typ;
405: l_atp_details mrp_atp_pub.atp_details_typ;
406: l_null_aso_atp_typ aso_atp_int.atp_rec_typ;
407: l_mrp_database_link Varchar2(128);
408: l_statement Varchar2(500);

Line 405: l_atp_details mrp_atp_pub.atp_details_typ;

401: l_atp_rec mrp_atp_pub.atp_rec_typ;
402: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
403: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
404: l_atp_period mrp_atp_pub.atp_period_typ;
405: l_atp_details mrp_atp_pub.atp_details_typ;
406: l_null_aso_atp_typ aso_atp_int.atp_rec_typ;
407: l_mrp_database_link Varchar2(128);
408: l_statement Varchar2(500);
409: l_ship_from_org_id Number ;

Line 1822: aso_debug_pub.add('do_check_atp: Before call to mrp_atp_pub.call_atp procedure',1,'Y');

1818: end if;
1819:
1820: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1821: aso_debug_pub.add('do_check_atp: After call to msc_atp_global.get_atp_session_id procedure',1,'Y');
1822: aso_debug_pub.add('do_check_atp: Before call to mrp_atp_pub.call_atp procedure',1,'Y');
1823: END IF;
1824:
1825: MRP_ATP_PUB.CALL_ATP(l_session_id,
1826: l_atp_rec,

Line 1825: MRP_ATP_PUB.CALL_ATP(l_session_id,

1821: aso_debug_pub.add('do_check_atp: After call to msc_atp_global.get_atp_session_id procedure',1,'Y');
1822: aso_debug_pub.add('do_check_atp: Before call to mrp_atp_pub.call_atp procedure',1,'Y');
1823: END IF;
1824:
1825: MRP_ATP_PUB.CALL_ATP(l_session_id,
1826: l_atp_rec,
1827: l_atp_rec_out,
1828: l_atp_supply_demand,
1829: l_atp_period,

Line 1836: aso_debug_pub.add('do_check_atp: After call to mrp_atp_pub.call_atp procedure',1,'Y');

1832: x_new_msg_data,
1833: x_msg_count);
1834:
1835: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1836: aso_debug_pub.add('do_check_atp: After call to mrp_atp_pub.call_atp procedure',1,'Y');
1837: aso_debug_pub.add('do_check_atp: x_return_status: '|| x_return_status ,1,'Y');
1838: aso_debug_pub.add('Error msg: '||x_new_msg_data,1,'Y');
1839: END IF;
1840:

Line 1979: l_atp_rec mrp_atp_pub.atp_rec_typ;

1975: l_api_name CONSTANT VARCHAR2(30) := 'Check_ATP' ;
1976: l_api_version_number CONSTANT NUMBER := 1.0;
1977: l_session_id number;
1978: l_sysdate date;
1979: l_atp_rec mrp_atp_pub.atp_rec_typ;
1980: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
1981: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
1982: l_atp_period mrp_atp_pub.atp_period_typ;
1983: l_atp_details mrp_atp_pub.atp_details_typ;

Line 1980: l_atp_rec_out mrp_atp_pub.atp_rec_typ;

1976: l_api_version_number CONSTANT NUMBER := 1.0;
1977: l_session_id number;
1978: l_sysdate date;
1979: l_atp_rec mrp_atp_pub.atp_rec_typ;
1980: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
1981: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
1982: l_atp_period mrp_atp_pub.atp_period_typ;
1983: l_atp_details mrp_atp_pub.atp_details_typ;
1984: l_null_aso_atp_typ aso_atp_int.atp_rec_typ;

Line 1981: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;

1977: l_session_id number;
1978: l_sysdate date;
1979: l_atp_rec mrp_atp_pub.atp_rec_typ;
1980: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
1981: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
1982: l_atp_period mrp_atp_pub.atp_period_typ;
1983: l_atp_details mrp_atp_pub.atp_details_typ;
1984: l_null_aso_atp_typ aso_atp_int.atp_rec_typ;
1985: l_mrp_database_link Varchar2(128);

Line 1982: l_atp_period mrp_atp_pub.atp_period_typ;

1978: l_sysdate date;
1979: l_atp_rec mrp_atp_pub.atp_rec_typ;
1980: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
1981: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
1982: l_atp_period mrp_atp_pub.atp_period_typ;
1983: l_atp_details mrp_atp_pub.atp_details_typ;
1984: l_null_aso_atp_typ aso_atp_int.atp_rec_typ;
1985: l_mrp_database_link Varchar2(128);
1986: l_statement Varchar2(500);

Line 1983: l_atp_details mrp_atp_pub.atp_details_typ;

1979: l_atp_rec mrp_atp_pub.atp_rec_typ;
1980: l_atp_rec_out mrp_atp_pub.atp_rec_typ;
1981: l_atp_supply_demand mrp_atp_pub.atp_supply_demand_typ;
1982: l_atp_period mrp_atp_pub.atp_period_typ;
1983: l_atp_details mrp_atp_pub.atp_details_typ;
1984: l_null_aso_atp_typ aso_atp_int.atp_rec_typ;
1985: l_mrp_database_link Varchar2(128);
1986: l_statement Varchar2(500);
1987: l_ship_from_org_id Number ;

Line 2301: MRP_ATP_PUB.CALL_ATP(l_session_id,

2297: aso_debug_pub.add('Check_atp: Source Organization ID is '||l_atp_rec.source_organization_id(1));
2298: aso_debug_pub.add('Check_atp :Before calling mrp api ',1,'Y');
2299: END IF;
2300:
2301: MRP_ATP_PUB.CALL_ATP(l_session_id,
2302: l_atp_rec,
2303: l_atp_rec_out,
2304: l_atp_supply_demand,
2305: l_atp_period,