APPS.CTO_WORKFLOW_API_PK dependencies on PO_HEADERS_ALL

Line 746: v_po_header_id po_headers_all.po_header_id%type ;

742:
743: l_stmt_num number;
744:
745: v_header_id oe_order_lines_all.header_id%type ;
746: v_po_header_id po_headers_all.po_header_id%type ;
747: v_authorization_status po_headers_all.authorization_status%type ;
748:
749:
750: DROPSHIP_EXCEPTION EXCEPTION ;

Line 747: v_authorization_status po_headers_all.authorization_status%type ;

743: l_stmt_num number;
744:
745: v_header_id oe_order_lines_all.header_id%type ;
746: v_po_header_id po_headers_all.po_header_id%type ;
747: v_authorization_status po_headers_all.authorization_status%type ;
748:
749:
750: DROPSHIP_EXCEPTION EXCEPTION ;
751:

Line 818: from po_headers_all poh,

814: -- to avoid too many rows exception
815:
816: select poh.authorization_status
817: into v_authorization_status
818: from po_headers_all poh,
819: po_lines_all pol,
820: oe_drop_ship_sources ods
821: where ods.header_id = v_header_id
822: and ods.line_id = p_order_line_id

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

827: exception
828: when others then
829: If PG_DEBUG <> 0 Then
830: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check',
831: 'no data found in po_headers_all for om header ' ||
832: to_char( v_header_id ) || ' line id ' ||
833: to_char( p_order_line_id ) || ' po header id ' ||
834: to_char( v_po_header_id ) ) ;
835: End if;