DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_CLOSE dependencies on PO_ACTIONS

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

3030: FORALL i IN 1..l_id_tbl.COUNT
3031: UPDATE po_line_locations poll
3032: SET poll.shipment_closed_date = DECODE(poll.closed_code,
3033: 'CLOSED', NVL(poll.shipment_closed_date,
3034: PO_ACTIONS.get_closure_dates('CLOSE', poll.line_location_id)),
3035: NULL)
3036: , poll.closed_for_receiving_date = DECODE(poll.closed_code,
3037: 'CLOSED FOR RECEIVING', NVL(poll.closed_for_receiving_date,
3038: PO_ACTIONS.get_closure_dates('RECEIVE CLOSE', poll.line_location_id)),

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

3034: PO_ACTIONS.get_closure_dates('CLOSE', poll.line_location_id)),
3035: NULL)
3036: , poll.closed_for_receiving_date = DECODE(poll.closed_code,
3037: 'CLOSED FOR RECEIVING', NVL(poll.closed_for_receiving_date,
3038: PO_ACTIONS.get_closure_dates('RECEIVE CLOSE', poll.line_location_id)),
3039: 'CLOSED FOR INVOICE', NULL,
3040: 'CLOSED', NVL(poll.closed_for_receiving_date,
3041: PO_ACTIONS.get_closure_dates('RECEIVE CLOSE', poll.line_location_id)),
3042: 'OPEN', NULL)

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

3037: 'CLOSED FOR RECEIVING', NVL(poll.closed_for_receiving_date,
3038: PO_ACTIONS.get_closure_dates('RECEIVE CLOSE', poll.line_location_id)),
3039: 'CLOSED FOR INVOICE', NULL,
3040: 'CLOSED', NVL(poll.closed_for_receiving_date,
3041: PO_ACTIONS.get_closure_dates('RECEIVE CLOSE', poll.line_location_id)),
3042: 'OPEN', NULL)
3043: , poll.closed_for_invoice_date = DECODE(poll.closed_code,
3044: 'CLOSED FOR RECEIVING', NULL,
3045: 'CLOSED FOR INVOICE', NVL(poll.closed_for_invoice_date,

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

3042: 'OPEN', NULL)
3043: , poll.closed_for_invoice_date = DECODE(poll.closed_code,
3044: 'CLOSED FOR RECEIVING', NULL,
3045: 'CLOSED FOR INVOICE', NVL(poll.closed_for_invoice_date,
3046: PO_ACTIONS.get_closure_dates('INVOICE CLOSE', poll.line_location_id)),
3047: 'CLOSED', NVL(poll.closed_for_invoice_date,
3048: PO_ACTIONS.get_closure_dates('INVOICE CLOSE', poll.line_location_id)),
3049: 'OPEN', NULL)
3050: , poll.last_update_date = SYSDATE --bug4964600

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

3044: 'CLOSED FOR RECEIVING', NULL,
3045: 'CLOSED FOR INVOICE', NVL(poll.closed_for_invoice_date,
3046: PO_ACTIONS.get_closure_dates('INVOICE CLOSE', poll.line_location_id)),
3047: 'CLOSED', NVL(poll.closed_for_invoice_date,
3048: PO_ACTIONS.get_closure_dates('INVOICE CLOSE', poll.line_location_id)),
3049: 'OPEN', NULL)
3050: , poll.last_update_date = SYSDATE --bug4964600
3051: , poll.last_updated_by = p_user_id --bug4964600
3052: , poll.last_update_login = p_login_id --bug4964600