APPS.PO_MOD_CONTROL_PVT dependencies on PO_DOCUMENT_ACTION_PVT

Line 999: AND NVL(poll2.closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)

995: WHERE poll1.line_location_id = p_doc_level_id
996: AND poll1.po_line_id = poll2.po_line_id
997: AND NVL(poll2.cancel_flag,'N') <> 'Y'
998: AND NVL(poll2.payment_type, 'NULL') NOT IN ('ADVANCE', 'DELIVERY') --
999: AND NVL(poll2.closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)
1000: <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
1001: AND poll2.line_location_id <> p_doc_level_id);
1002: EXCEPTION
1003: WHEN NO_DATA_FOUND THEN

Line 1000: <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED

996: AND poll1.po_line_id = poll2.po_line_id
997: AND NVL(poll2.cancel_flag,'N') <> 'Y'
998: AND NVL(poll2.payment_type, 'NULL') NOT IN ('ADVANCE', 'DELIVERY') --
999: AND NVL(poll2.closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)
1000: <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
1001: AND poll2.line_location_id <> p_doc_level_id);
1002: EXCEPTION
1003: WHEN NO_DATA_FOUND THEN
1004: --Current shipment is the only shipment on the line that is not cancelled or finally closed

Line 1026: AND l_current_action in ('CANCEL PO','CANCEL PO LINE', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN

1022: END IF;
1023: -- If consumption transaction exist we don't allow Cancel and Finally
1024: -- Close actions
1025: IF (l_cons_trans_exist = 'Y'
1026: AND l_current_action in ('CANCEL PO','CANCEL PO LINE', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN
1027: NULL;
1028: --If it is the only shipment then we dont allow the cancellation or finally closing of the shipment.
1029: ELSIF(l_ship_invalid_for_ctrl_actn = 'Y'
1030: AND l_current_action in ('CANCEL PO SHIPMENT', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN

Line 1030: AND l_current_action in ('CANCEL PO SHIPMENT', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN

1026: AND l_current_action in ('CANCEL PO','CANCEL PO LINE', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN
1027: NULL;
1028: --If it is the only shipment then we dont allow the cancellation or finally closing of the shipment.
1029: ELSIF(l_ship_invalid_for_ctrl_actn = 'Y'
1030: AND l_current_action in ('CANCEL PO SHIPMENT', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN
1031: NULL;
1032: ELSE
1033: -- For Update Mode only Cancel Related And Hold Related
1034: -- Control Actions are valid

Line 1179: po_document_action_pvt.Do_return(p_document_id => l_req_header_id,

1175:
1176: -- Return Requisition, if not already returned
1177: IF(l_req_authorization_status <> 'RETURNED') THEN
1178:
1179: po_document_action_pvt.Do_return(p_document_id => l_req_header_id,
1180: p_document_type => 'REQUISITION',
1181: p_document_subtype => 'PURCHASE',
1182: p_note => 'PAR Withdraw',
1183: p_approval_path_id => l_approval_id,