APPS.PO_INTERFACE_S dependencies on PO_DOC_STYLE_HEADERS

Line 873: l_change_process_type PO_DOC_STYLE_HEADERS.change_process_type%TYPE;

869:
870: -- CLM Autocreate
871: l_style_id PO_HEADERS_INTERFACE.style_id%TYPE;
872: l_clm_enabled_flag VARCHAR2(1):= 'N';
873: l_change_process_type PO_DOC_STYLE_HEADERS.change_process_type%TYPE;
874: l_is_clm_flow VARCHAR2(1):= 'N';
875:
876: BEGIN
877: --

Line 926: FROM po_doc_style_headers pdsh

922: SELECT nvl(pdsh.clm_flag,'N'),
923: Nvl(pdsh.change_process_type,'CHANGE_ORDER')
924: INTO l_clm_enabled_flag,
925: l_change_process_type
926: FROM po_doc_style_headers pdsh
927: WHERE pdsh.style_id=l_style_id;
928:
929: l_progress := '016';
930: IF g_debug_stmt THEN

Line 3160: l_enhanced_pricing_flag po_doc_style_headers.enhanced_pricing_flag%type;

3156: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type; --
3157: l_retainage_rate PO_VENDOR_SITES_ALL.retainage_rate%type; --bug#5255878
3158:
3159: --
3160: l_enhanced_pricing_flag po_doc_style_headers.enhanced_pricing_flag%type;
3161: l_pricing_call_src VARCHAR2(5);
3162: --
3163:
3164: BEGIN

Line 3524: FROM po_doc_style_headers SH

3520: --
3521: BEGIN
3522: SELECT NVL(SH.enhanced_pricing_flag,'N')
3523: INTO l_enhanced_pricing_flag
3524: FROM po_doc_style_headers SH
3525: WHERE SH.style_id = interface.style_id;
3526: EXCEPTION
3527: WHEN OTHERS THEN
3528: l_enhanced_pricing_flag := 'N';