297: -- Exceptions : -
298: --=============================================================================
299: FUNCTION is_referenced
300: (
301: p_po_line_id IN PO_LINES_ALL.from_line_id%TYPE
302: )
303: RETURN BOOLEAN
304: IS
305: l_count NUMBER;
307: BEGIN
308:
309: SELECT count('Standard POs referencing GA line')
310: INTO l_count
311: FROM po_lines_all
312: WHERE from_line_id = p_po_line_id;
313:
314: IF ( l_count > 0 ) THEN
315: return (TRUE);
389: -- Exceptions : -
390: --=============================================================================
391: FUNCTION is_expired
392: (
393: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
394: )
395: RETURN BOOLEAN
396: IS
397: l_header_end_date PO_HEADERS_ALL.end_date%TYPE;
394: )
395: RETURN BOOLEAN
396: IS
397: l_header_end_date PO_HEADERS_ALL.end_date%TYPE;
398: l_line_expiration_date PO_LINES_ALL.expiration_date%TYPE;
399:
400: BEGIN
401:
402: --SQL Get the end_date for the header
406: pol.expiration_date
407: INTO l_header_end_date,
408: l_line_expiration_date
409: FROM po_headers_all poh,
410: po_lines_all pol
411: WHERE poh.po_header_id = pol.po_header_id -- JOIN
412: AND pol.po_line_id = p_po_line_id;
413:
414: -- Both the header end_date and line expiration_date must be in the future
454: -- Exceptions : -
455: --=============================================================================
456: FUNCTION is_approved
457: (
458: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
459: )
460: RETURN BOOLEAN
461: IS
462: l_count NUMBER;
470: --
471: SELECT count('Line exists with following conditions.')
472: INTO l_count
473: FROM po_headers_all poh,
474: po_lines_all pol
475: WHERE
476: nvl(poh.cancel_flag, 'N') = 'N'
477: AND nvl(poh.closed_code, 'OPEN') <> 'FINALLY CLOSED'
478: AND nvl(poh.approved_flag, 'N') = 'Y'
524: --=============================================================================
525: FUNCTION is_ga_valid
526: (
527: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
528: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
529: )
530: RETURN BOOLEAN
531: IS
532: BEGIN
1000: -- EXCEPTIONS : -
1001: --==========================================================================
1002: PROCEDURE sync_ga_line_attachments(
1003: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
1004: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
1005: x_return_status OUT NOCOPY VARCHAR2,
1006: x_msg_data OUT NOCOPY VARCHAR2) IS
1007:
1008: l_count_po_line_att NUMBER := 0;
2370:
2371: cursor lines_csr is
2372: select from_line_id, decode(from_header_id, NULL,contract_id, from_header_id ) from po_lines_merge_v where po_header_id = p_po_header_id and draft_id = p_draft_id; --Bug 13540474
2373:
2374: l_po_line_id PO_LINES_ALL.po_line_id%type;
2375: l_src_doc_id PO_HEADERS_ALL.po_header_id%TYPE;
2376:
2377:
2378: BEGIN