DBA Data[Home] [Help]

APPS.POS_ISP_UPDMODIFIERS dependencies on PO_ASL_ATTRIBUTES

Line 9: p_asl_id IN PO_ASL_ATTRIBUTES.ASL_ID%TYPE,

5: PROCEDURE NAME: updmodifiers()
6: ===========================================================================*/
7:
8: PROCEDURE updmodifiers(
9: p_asl_id IN PO_ASL_ATTRIBUTES.ASL_ID%TYPE,
10: p_proc_lead_time IN PO_ASL_ATTRIBUTES.PROCESSING_LEAD_TIME%TYPE,
11: p_min_order_qty IN PO_ASL_ATTRIBUTES.MIN_ORDER_QTY%TYPE,
12: p_fixed_lot_multiple IN PO_ASL_ATTRIBUTES.FIXED_LOT_MULTIPLE%TYPE,
13: p_error_code OUT NOCOPY VARCHAR2,

Line 10: p_proc_lead_time IN PO_ASL_ATTRIBUTES.PROCESSING_LEAD_TIME%TYPE,

6: ===========================================================================*/
7:
8: PROCEDURE updmodifiers(
9: p_asl_id IN PO_ASL_ATTRIBUTES.ASL_ID%TYPE,
10: p_proc_lead_time IN PO_ASL_ATTRIBUTES.PROCESSING_LEAD_TIME%TYPE,
11: p_min_order_qty IN PO_ASL_ATTRIBUTES.MIN_ORDER_QTY%TYPE,
12: p_fixed_lot_multiple IN PO_ASL_ATTRIBUTES.FIXED_LOT_MULTIPLE%TYPE,
13: p_error_code OUT NOCOPY VARCHAR2,
14: p_error_message OUT NOCOPY VARCHAR2) IS

Line 11: p_min_order_qty IN PO_ASL_ATTRIBUTES.MIN_ORDER_QTY%TYPE,

7:
8: PROCEDURE updmodifiers(
9: p_asl_id IN PO_ASL_ATTRIBUTES.ASL_ID%TYPE,
10: p_proc_lead_time IN PO_ASL_ATTRIBUTES.PROCESSING_LEAD_TIME%TYPE,
11: p_min_order_qty IN PO_ASL_ATTRIBUTES.MIN_ORDER_QTY%TYPE,
12: p_fixed_lot_multiple IN PO_ASL_ATTRIBUTES.FIXED_LOT_MULTIPLE%TYPE,
13: p_error_code OUT NOCOPY VARCHAR2,
14: p_error_message OUT NOCOPY VARCHAR2) IS
15:

Line 12: p_fixed_lot_multiple IN PO_ASL_ATTRIBUTES.FIXED_LOT_MULTIPLE%TYPE,

8: PROCEDURE updmodifiers(
9: p_asl_id IN PO_ASL_ATTRIBUTES.ASL_ID%TYPE,
10: p_proc_lead_time IN PO_ASL_ATTRIBUTES.PROCESSING_LEAD_TIME%TYPE,
11: p_min_order_qty IN PO_ASL_ATTRIBUTES.MIN_ORDER_QTY%TYPE,
12: p_fixed_lot_multiple IN PO_ASL_ATTRIBUTES.FIXED_LOT_MULTIPLE%TYPE,
13: p_error_code OUT NOCOPY VARCHAR2,
14: p_error_message OUT NOCOPY VARCHAR2) IS
15:
16:

Line 20: /* Update PO_ASL_ATTRIBUTES form ISP */

16:
17:
18: BEGIN
19:
20: /* Update PO_ASL_ATTRIBUTES form ISP */
21:
22: UPDATE PO_ASL_ATTRIBUTES
23: SET PROCESSING_LEAD_TIME = p_proc_lead_time,
24: MIN_ORDER_QTY = p_min_order_qty,

Line 22: UPDATE PO_ASL_ATTRIBUTES

18: BEGIN
19:
20: /* Update PO_ASL_ATTRIBUTES form ISP */
21:
22: UPDATE PO_ASL_ATTRIBUTES
23: SET PROCESSING_LEAD_TIME = p_proc_lead_time,
24: MIN_ORDER_QTY = p_min_order_qty,
25: FIXED_LOT_MULTIPLE = p_fixed_lot_multiple
26: WHERE asl_id = p_asl_id