APPS.CTO_WORKFLOW_API_PK dependencies on PO_HEADERS_ALL

Line 751: v_po_header_id po_headers_all.po_header_id%type ;

747:
748: l_stmt_num number;
749:
750: v_header_id oe_order_lines_all.header_id%type ;
751: v_po_header_id po_headers_all.po_header_id%type ;
752: v_authorization_status po_headers_all.authorization_status%type ;
753:
754:
755: DROPSHIP_EXCEPTION EXCEPTION ;

Line 752: v_authorization_status po_headers_all.authorization_status%type ;

748: l_stmt_num number;
749:
750: v_header_id oe_order_lines_all.header_id%type ;
751: v_po_header_id po_headers_all.po_header_id%type ;
752: v_authorization_status po_headers_all.authorization_status%type ;
753:
754:
755: DROPSHIP_EXCEPTION EXCEPTION ;
756:

Line 827: from po_headers_all poh,

823: -- to avoid too many rows exception
824:
825: select poh.authorization_status
826: into v_authorization_status
827: from po_headers_all poh,
828: po_lines_all pol,
829: oe_drop_ship_sources ods
830: where ods.header_id = v_header_id
831: and ods.line_id = p_order_line_id

Line 840: 'no data found in po_headers_all for om header ' ||

836: exception
837: when others then
838: If PG_DEBUG <> 0 Then
839: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check',
840: 'no data found in po_headers_all for om header ' ||
841: to_char( v_header_id ) || ' line id ' ||
842: to_char( p_order_line_id ) || ' po header id ' ||
843: to_char( v_po_header_id ) ) ;
844: End if;