DBA Data[Home] [Help]

APPS.PO_DATATEMPLATE_PKG dependencies on PO_DRAFTS

Line 871: ' po_drafts pd where pd.draft_id = :1 and pd.document_id = pla.po_header_id)';

867: return(true);
868: end;
869:
870: l_sql_o := '(SELECT pla.line_location_id from po_line_locations_draft_all pla,' ||
871: ' po_drafts pd where pd.draft_id = :1 and pd.document_id = pla.po_header_id)';
872: l_first_bind := draftId;
873: l_draftId := draftId;
874: end if;
875:

Line 1064: SELECT document_id INTO l_header_id FROM po_drafts WHERE draft_id = draftId;

1060: l_header_id NUMBER;
1061: BEGIN
1062:
1063: IF is_doc_mod = 'Y' THEN
1064: SELECT document_id INTO l_header_id FROM po_drafts WHERE draft_id = draftId;
1065: pt_headerId := l_header_id;
1066: ELSE
1067: pt_headerId := headerId;
1068: END IF;