1383: -- p_document_type
1384: -- 'RELEASE', 'PO'
1385: -- p_document_subtype
1386: -- 'RELEASE': 'BLANKET', 'SCHEDULED'
1387: -- 'PO': 'PLANNED', 'STANDARD'
1388: -- p_action
1389: -- A manual close action. Use g_doc_action_<> constant where possible.
1390: -- 'INVOICE OPEN', 'INVOICE CLOSE', 'OPEN', 'CLOSE', 'RECEIVE OPEN'
1391: -- 'RECEIVE CLOSE', 'FINALLY CLOSE'
1535:
1536: d_progress := 140;
1537:
1538: IF ((p_document_type = 'RELEASE')
1539: OR (p_document_type = 'PO' AND p_document_subtype = 'STANDARD'))
1540: THEN
1541:
1542: d_progress := 150;
1543:
2238: WHERE poll.line_location_id = l_id_tbl(i)
2239: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2240: AND poll.shipment_type =
2241: DECODE(p_document_type,
2242: --
2244: 'PO', DECODE(p_document_subtype, 'STANDARD', poll.shipment_type, 'PLANNED'),
2245: 'RELEASE', DECODE(p_document_subtype, 'SCHEDULED', 'SCHEDULED', 'BLANKET'))
2246: ;
2239: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2240: AND poll.shipment_type =
2241: DECODE(p_document_type,
2242: --
2243: -- 'STANDARD' shipptype; it can also be PREPAYMENT.
2244: 'PO', DECODE(p_document_subtype, 'STANDARD', poll.shipment_type, 'PLANNED'),
2245: 'RELEASE', DECODE(p_document_subtype, 'SCHEDULED', 'SCHEDULED', 'BLANKET'))
2246: ;
2247:
2240: AND poll.shipment_type =
2241: DECODE(p_document_type,
2242: --
2243: -- 'STANDARD' shipptype; it can also be PREPAYMENT.
2244: 'PO', DECODE(p_document_subtype, 'STANDARD', poll.shipment_type, 'PLANNED'),
2245: 'RELEASE', DECODE(p_document_subtype, 'SCHEDULED', 'SCHEDULED', 'BLANKET'))
2246: ;
2247:
2248: --