DBA Data[Home] [Help]

APPS.POS_ORDER_MODIFIERS_PKG dependencies on PO_ASL_ATTRIBUTES

Line 21: /* Update PO_ASL_ATTRIBUTES form ISP */

17:
18: l_seq number;
19: BEGIN
20:
21: /* Update PO_ASL_ATTRIBUTES form ISP */
22: select POS_ORDER_MODIFIERS_TEMP_ID_S.NEXTVAL
23: into l_seq from sys.dual;
24:
25: insert into POS_ORDER_MODIFIERS_TEMP (

Line 83: /* Update PO_ASL_ATTRIBUTES form ISP */

79: l_count number;
80:
81: BEGIN
82:
83: /* Update PO_ASL_ATTRIBUTES form ISP */
84: select count(*)
85: into l_count
86: from POS_ORDER_MODIFIERS_TEMP
87: where asl_id=p_asl_id and status='NEW';

Line 796: UPDATE PO_ASL_ATTRIBUTES

792: from POS_ORDER_MODIFIERS_TEMP
793: where asl_id=l_asl_id
794: and status='NEW';
795:
796: UPDATE PO_ASL_ATTRIBUTES
797: SET PROCESSING_LEAD_TIME = l_proc_lead_time,
798: MIN_ORDER_QTY = l_min_order_qty,
799: FIXED_LOT_MULTIPLE = l_fixed_lot_multiple
800: WHERE asl_id = l_asl_id