APPS.PO_CONTERMS_UTL_GRP dependencies on PO_HEADERS_DRAFT_ALL

Line 15: FROM po_headers_draft_all

11: l_po_header_id NUMBER:=0;
12: BEGIN
13: SELECT po_header_id
14: INTO l_po_header_id
15: FROM po_headers_draft_all
16: WHERE draft_id = p_draft_id
17: AND rownum < 2;
18: RETURN(l_po_header_id);
19: EXCEPTION

Line 916: FROM po_headers_draft_all

912: SELECT nvl(authorization_status,'INCOMPLETE'), revision_num, type_lookup_code
913: ,DECODE(type_lookup_code,'STANDARD','PO','BLANKET','PA','CONTRACT','PA',null)
914: INTO l_po_status,l_po_revision, l_doc_type_code
915: ,l_document_type
916: FROM po_headers_draft_all
917: WHERE draft_id = p_header_id;
918: END IF; -- CLM Mod
919:
920: EXCEPTION

Line 1404: FROM PO_HEADERS_DRAFT_ALL poh

1400: WHERE poh.po_header_id = p_header_id;
1401: ELSE -- CLM Mod
1402: SELECT poh.conterms_exist_flag
1403: INTO l_old_conterms_flag
1404: FROM PO_HEADERS_DRAFT_ALL poh
1405: WHERE poh.draft_id = p_header_id
1406: AND rownum <2;
1407: END IF; -- CLM Mod
1408:

Line 1492: Update po_headers_draft_all

1488: ELSE --CLM Mod
1489: -- SQL WHAT-Update the conterms_exist_flag and the contract terms dates in po_headers_all
1490: -- SQL WHY - Update the flag based on if contract terms template attached or removed
1491: -- SQL JOIN- None
1492: Update po_headers_draft_all
1493: Set conterms_exist_flag = l_conterms_exist_flag,
1494: Conterms_articles_upd_date = l_date,
1495: Conterms_DELIV_upd_date = l_date,
1496: Last_update_date = sysdate,

Line 2645: po_headers_draft_all poh

2641: ,l_po_attrib_tbl(87).variable_value_id --
2642: ,l_po_attrib_tbl(88).variable_value_id --
2643:
2644: FROM
2645: po_headers_draft_all poh
2646: ,FINANCIALS_SYSTEM_PARAMS_ALL FP
2647: ,FND_CURRENCIES_VL CU
2648: ,GL_SETS_OF_BOOKS gsb
2649: ,FND_CURRENCIES_VL cuf

Line 3415: FROM po_headers_draft_all phda

3411: nvl(phda.conterms_exist_flag, 'N')
3412: INTO l_document_type,
3413: l_doc_number,
3414: l_conterms_flag_mod
3415: FROM po_headers_draft_all phda
3416: WHERE phda.po_header_id = p_document_id
3417: AND phda.draft_id = p_draft_id;
3418: Exception
3419: When others then