DBA Data[Home] [Help]

APPS.OE_SET_UTIL dependencies on OE_ATP

Line 520: l_atp_rec OE_ATP.atp_tbl_type;

516: x_msg_data varchar2(2000);
517:
518: l_return_status VARCHAR2(30);
519: l_set_rec OE_ORDER_CACHE.set_rec_type;
520: l_atp_rec OE_ATP.atp_tbl_type;
521: l_atp_tbl OE_ATP.atp_tbl_type;
522:
523: Cursor optiontbl IS
524: Select Ordered_quantity,

Line 521: l_atp_tbl OE_ATP.atp_tbl_type;

517:
518: l_return_status VARCHAR2(30);
519: l_set_rec OE_ORDER_CACHE.set_rec_type;
520: l_atp_rec OE_ATP.atp_tbl_type;
521: l_atp_tbl OE_ATP.atp_tbl_type;
522:
523: Cursor optiontbl IS
524: Select Ordered_quantity,
525: header_id,

Line 879: l_atp_rec OE_ATP.atp_tbl_type;

875: l_line_id NUMBER ;
876: l_set_type VARCHAR2(30) ;
877: l_set_name VARCHAR2(30) ;
878: l_set_rec OE_ORDER_CACHE.set_rec_type;
879: l_atp_rec OE_ATP.atp_tbl_type;
880: l_atp_tbl OE_ATP.atp_tbl_type;
881: lcnt number := 0;
882: l_Ship_from_org_id NUMBER ;
883: l_Ship_to_org_id NUMBER ;

Line 880: l_atp_tbl OE_ATP.atp_tbl_type;

876: l_set_type VARCHAR2(30) ;
877: l_set_name VARCHAR2(30) ;
878: l_set_rec OE_ORDER_CACHE.set_rec_type;
879: l_atp_rec OE_ATP.atp_tbl_type;
880: l_atp_tbl OE_ATP.atp_tbl_type;
881: lcnt number := 0;
882: l_Ship_from_org_id NUMBER ;
883: l_Ship_to_org_id NUMBER ;
884: l_Schedule_Ship_Date DATE ;

Line 2193: l_atp_rec OE_ATP.atp_tbl_type;

2189: l_line_id NUMBER ;
2190: l_set_type VARCHAR2(30) ;
2191: l_set_name VARCHAR2(30) ;
2192: l_set_rec OE_ORDER_CACHE.set_rec_type;
2193: l_atp_rec OE_ATP.atp_tbl_type;
2194: l_atp_tbl OE_ATP.atp_tbl_type;
2195: lcnt number := 0;
2196: l_Ship_from_org_id NUMBER ;
2197: l_Ship_to_org_id NUMBER ;

Line 2194: l_atp_tbl OE_ATP.atp_tbl_type;

2190: l_set_type VARCHAR2(30) ;
2191: l_set_name VARCHAR2(30) ;
2192: l_set_rec OE_ORDER_CACHE.set_rec_type;
2193: l_atp_rec OE_ATP.atp_tbl_type;
2194: l_atp_tbl OE_ATP.atp_tbl_type;
2195: lcnt number := 0;
2196: l_Ship_from_org_id NUMBER ;
2197: l_Ship_to_org_id NUMBER ;
2198: l_Schedule_Ship_Date DATE ;

Line 5278: l_atp_rec OE_ATP.atp_tbl_type;

5274: l_line_id NUMBER ;
5275: l_set_type VARCHAR2(30) ;
5276: l_set_name VARCHAR2(30) ;
5277: l_set_rec OE_ORDER_CACHE.set_rec_type;
5278: l_atp_rec OE_ATP.atp_tbl_type;
5279: l_atp_tbl OE_ATP.atp_tbl_type;
5280: l_Ship_from_org_id NUMBER ;
5281: l_Ship_to_org_id NUMBER ;
5282: l_Schedule_Ship_Date DATE ;

Line 5279: l_atp_tbl OE_ATP.atp_tbl_type;

5275: l_set_type VARCHAR2(30) ;
5276: l_set_name VARCHAR2(30) ;
5277: l_set_rec OE_ORDER_CACHE.set_rec_type;
5278: l_atp_rec OE_ATP.atp_tbl_type;
5279: l_atp_tbl OE_ATP.atp_tbl_type;
5280: l_Ship_from_org_id NUMBER ;
5281: l_Ship_to_org_id NUMBER ;
5282: l_Schedule_Ship_Date DATE ;
5283: l_Schedule_Arrival_Date DATE ;