DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_CLOSE dependencies on PO_ACTIONS

Line 2743: PO_ACTIONS.get_closure_dates('CLOSE', poll.line_location_id)),

2739: FORALL i IN 1..l_id_tbl.COUNT
2740: UPDATE po_line_locations poll
2741: SET poll.shipment_closed_date = DECODE(poll.closed_code,
2742: 'CLOSED', NVL(poll.shipment_closed_date,
2743: PO_ACTIONS.get_closure_dates('CLOSE', poll.line_location_id)),
2744: NULL)
2745: , poll.closed_for_receiving_date = DECODE(poll.closed_code,
2746: 'CLOSED FOR RECEIVING', NVL(poll.closed_for_receiving_date,
2747: PO_ACTIONS.get_closure_dates('RECEIVE CLOSE', poll.line_location_id)),

Line 2747: PO_ACTIONS.get_closure_dates('RECEIVE CLOSE', poll.line_location_id)),

2743: PO_ACTIONS.get_closure_dates('CLOSE', poll.line_location_id)),
2744: NULL)
2745: , poll.closed_for_receiving_date = DECODE(poll.closed_code,
2746: 'CLOSED FOR RECEIVING', NVL(poll.closed_for_receiving_date,
2747: PO_ACTIONS.get_closure_dates('RECEIVE CLOSE', poll.line_location_id)),
2748: 'CLOSED FOR INVOICE', NULL,
2749: 'CLOSED', NVL(poll.closed_for_receiving_date,
2750: PO_ACTIONS.get_closure_dates('RECEIVE CLOSE', poll.line_location_id)),
2751: 'OPEN', NULL)

Line 2750: PO_ACTIONS.get_closure_dates('RECEIVE CLOSE', poll.line_location_id)),

2746: 'CLOSED FOR RECEIVING', NVL(poll.closed_for_receiving_date,
2747: PO_ACTIONS.get_closure_dates('RECEIVE CLOSE', poll.line_location_id)),
2748: 'CLOSED FOR INVOICE', NULL,
2749: 'CLOSED', NVL(poll.closed_for_receiving_date,
2750: PO_ACTIONS.get_closure_dates('RECEIVE CLOSE', poll.line_location_id)),
2751: 'OPEN', NULL)
2752: , poll.closed_for_invoice_date = DECODE(poll.closed_code,
2753: 'CLOSED FOR RECEIVING', NULL,
2754: 'CLOSED FOR INVOICE', NVL(poll.closed_for_invoice_date,

Line 2755: PO_ACTIONS.get_closure_dates('INVOICE CLOSE', poll.line_location_id)),

2751: 'OPEN', NULL)
2752: , poll.closed_for_invoice_date = DECODE(poll.closed_code,
2753: 'CLOSED FOR RECEIVING', NULL,
2754: 'CLOSED FOR INVOICE', NVL(poll.closed_for_invoice_date,
2755: PO_ACTIONS.get_closure_dates('INVOICE CLOSE', poll.line_location_id)),
2756: 'CLOSED', NVL(poll.closed_for_invoice_date,
2757: PO_ACTIONS.get_closure_dates('INVOICE CLOSE', poll.line_location_id)),
2758: 'OPEN', NULL)
2759: , poll.last_update_date = SYSDATE --bug4964600

Line 2757: PO_ACTIONS.get_closure_dates('INVOICE CLOSE', poll.line_location_id)),

2753: 'CLOSED FOR RECEIVING', NULL,
2754: 'CLOSED FOR INVOICE', NVL(poll.closed_for_invoice_date,
2755: PO_ACTIONS.get_closure_dates('INVOICE CLOSE', poll.line_location_id)),
2756: 'CLOSED', NVL(poll.closed_for_invoice_date,
2757: PO_ACTIONS.get_closure_dates('INVOICE CLOSE', poll.line_location_id)),
2758: 'OPEN', NULL)
2759: , poll.last_update_date = SYSDATE --bug4964600
2760: , poll.last_updated_by = p_user_id --bug4964600
2761: , poll.last_update_login = p_login_id --bug4964600