APPS.OE_SET_UTIL dependencies on OE_ATP

Line 556: l_atp_rec OE_ATP.atp_tbl_type;

552: x_msg_data varchar2(2000);
553:
554: l_return_status VARCHAR2(30);
555: l_set_rec OE_ORDER_CACHE.set_rec_type;
556: l_atp_rec OE_ATP.atp_tbl_type;
557: l_atp_tbl OE_ATP.atp_tbl_type;
558:
559: Cursor optiontbl IS
560: Select Ordered_quantity,

Line 557: l_atp_tbl OE_ATP.atp_tbl_type;

553:
554: l_return_status VARCHAR2(30);
555: l_set_rec OE_ORDER_CACHE.set_rec_type;
556: l_atp_rec OE_ATP.atp_tbl_type;
557: l_atp_tbl OE_ATP.atp_tbl_type;
558:
559: Cursor optiontbl IS
560: Select Ordered_quantity,
561: header_id,

Line 915: l_atp_rec OE_ATP.atp_tbl_type;

911: l_line_id NUMBER ;
912: l_set_type VARCHAR2(30) ;
913: l_set_name VARCHAR2(30) ;
914: l_set_rec OE_ORDER_CACHE.set_rec_type;
915: l_atp_rec OE_ATP.atp_tbl_type;
916: l_atp_tbl OE_ATP.atp_tbl_type;
917: lcnt number := 0;
918: l_Ship_from_org_id NUMBER ;
919: l_Ship_to_org_id NUMBER ;

Line 916: l_atp_tbl OE_ATP.atp_tbl_type;

912: l_set_type VARCHAR2(30) ;
913: l_set_name VARCHAR2(30) ;
914: l_set_rec OE_ORDER_CACHE.set_rec_type;
915: l_atp_rec OE_ATP.atp_tbl_type;
916: l_atp_tbl OE_ATP.atp_tbl_type;
917: lcnt number := 0;
918: l_Ship_from_org_id NUMBER ;
919: l_Ship_to_org_id NUMBER ;
920: l_Schedule_Ship_Date DATE ;

Line 2246: l_atp_rec OE_ATP.atp_tbl_type;

2242: l_line_id NUMBER ;
2243: l_set_type VARCHAR2(30) ;
2244: l_set_name VARCHAR2(30) ;
2245: l_set_rec OE_ORDER_CACHE.set_rec_type;
2246: l_atp_rec OE_ATP.atp_tbl_type;
2247: l_atp_tbl OE_ATP.atp_tbl_type;
2248: lcnt number := 0;
2249: l_Ship_from_org_id NUMBER ;
2250: l_Ship_to_org_id NUMBER ;

Line 2247: l_atp_tbl OE_ATP.atp_tbl_type;

2243: l_set_type VARCHAR2(30) ;
2244: l_set_name VARCHAR2(30) ;
2245: l_set_rec OE_ORDER_CACHE.set_rec_type;
2246: l_atp_rec OE_ATP.atp_tbl_type;
2247: l_atp_tbl OE_ATP.atp_tbl_type;
2248: lcnt number := 0;
2249: l_Ship_from_org_id NUMBER ;
2250: l_Ship_to_org_id NUMBER ;
2251: l_Schedule_Ship_Date DATE ;

Line 5335: l_atp_rec OE_ATP.atp_tbl_type;

5331: l_line_id NUMBER ;
5332: l_set_type VARCHAR2(30) ;
5333: l_set_name VARCHAR2(30) ;
5334: l_set_rec OE_ORDER_CACHE.set_rec_type;
5335: l_atp_rec OE_ATP.atp_tbl_type;
5336: l_atp_tbl OE_ATP.atp_tbl_type;
5337: l_Ship_from_org_id NUMBER ;
5338: l_Ship_to_org_id NUMBER ;
5339: l_Schedule_Ship_Date DATE ;

Line 5336: l_atp_tbl OE_ATP.atp_tbl_type;

5332: l_set_type VARCHAR2(30) ;
5333: l_set_name VARCHAR2(30) ;
5334: l_set_rec OE_ORDER_CACHE.set_rec_type;
5335: l_atp_rec OE_ATP.atp_tbl_type;
5336: l_atp_tbl OE_ATP.atp_tbl_type;
5337: l_Ship_from_org_id NUMBER ;
5338: l_Ship_to_org_id NUMBER ;
5339: l_Schedule_Ship_Date DATE ;
5340: l_Schedule_Arrival_Date DATE ;