APPS.PO_SOURCING_PVT dependencies on PO_DOC_STYLE_HEADERS

Line 1529: FROM po_doc_style_headers pdsh, po_headers_all pha

1525:
1526:
1527: SELECT pdsh.ame_transaction_type
1528: INTO l_ame_transaction_type
1529: FROM po_doc_style_headers pdsh, po_headers_all pha
1530: WHERE pha.po_header_id = l_po_header_id
1531: AND pha.style_id = pdsh.style_id;
1532:
1533: UPDATE po_headers_all

Line 1549: po_doc_style_headers podsh

1545: podsh.ame_transaction_type
1546: INTO l_new_ame_appr_id_req,
1547: l_ame_transaction_type
1548: FROM po_headers_all poh,
1549: po_doc_style_headers podsh
1550: WHERE poh.style_id = podsh.style_id
1551: AND podsh.ame_transaction_type IS NOT NULL
1552: AND poh.po_header_id = l_po_header_id;
1553:

Line 1687: l_change_process_type PO_DOC_STYLE_HEADERS.change_process_type%TYPE;

1683: l_action PO_HEADERS_INTERFACE.action%TYPE;
1684:
1685: -- CLM CPA
1686: l_clm_enabled_flag VARCHAR2(1):= 'N';
1687: l_change_process_type PO_DOC_STYLE_HEADERS.change_process_type%TYPE;
1688:
1689: BEGIN
1690: -- Initialize API return status to success
1691: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1748: FROM po_doc_style_headers pdsh

1744: SELECT nvl(pdsh.clm_flag,'N'),
1745: Nvl(pdsh.change_process_type,'CHANGE_ORDER')
1746: INTO l_clm_enabled_flag,
1747: l_change_process_type
1748: FROM po_doc_style_headers pdsh
1749: WHERE pdsh.style_id=g_style_id;
1750:
1751: g_progress:='460';
1752: IF g_debug_stmt THEN