893:
894: BEGIN
895: SELECT 'Y'
896: INTO l_any_lines_get_rejected
897: FROM DUAL
898: WHERE EXISTS
899: (SELECT 1
900: FROM po_lines_draft_all
901: WHERE draft_id = l_draft_id
1167:
1168: BEGIN
1169: SELECT PO_WF_ITEMKEY_S.NEXTVAL
1170: INTO l_new_itemkey
1171: FROM DUAL;
1172:
1173: RETURN g_ITEMKEY_PREFIX || '#' || TO_CHAR(p_draft_id) || '#' ||
1174: TO_CHAR(l_new_itemkey);
1175:
2987: END IF;
2988:
2989: SELECT NVL(MAX(FND_API.G_TRUE), FND_API.G_FALSE)
2990: INTO l_has_record_to_accept
2991: FROM DUAL
2992: WHERE EXISTS
2993: ( SELECT 1
2994: FROM po_lines_draft_all
2995: WHERE draft_id = p_draft_id