APPS.PO_COPY_DOCUMENTS_S dependencies on PO_HEADERS

Line 149: l_unique_id_tbl_name := 'PO_HEADERS';

145: -- bug5176308 START
146: -- Use API to get the new document number
147:
148: IF (x_new_document_type IN ('STANDARD', 'BLANKET', 'CONTRACT')) THEN
149: l_unique_id_tbl_name := 'PO_HEADERS';
150: ELSIF (x_new_document_type = 'QUOTATION') THEN
151: l_unique_id_tbl_name := 'PO_HEADERS_QUOTE';
152: ELSIF (x_new_document_type = 'RFQ') THEN
153: l_unique_id_tbl_name := 'PO_HEADERS_RFQ';

Line 151: l_unique_id_tbl_name := 'PO_HEADERS_QUOTE';

147:
148: IF (x_new_document_type IN ('STANDARD', 'BLANKET', 'CONTRACT')) THEN
149: l_unique_id_tbl_name := 'PO_HEADERS';
150: ELSIF (x_new_document_type = 'QUOTATION') THEN
151: l_unique_id_tbl_name := 'PO_HEADERS_QUOTE';
152: ELSIF (x_new_document_type = 'RFQ') THEN
153: l_unique_id_tbl_name := 'PO_HEADERS_RFQ';
154: END IF;
155:

Line 153: l_unique_id_tbl_name := 'PO_HEADERS_RFQ';

149: l_unique_id_tbl_name := 'PO_HEADERS';
150: ELSIF (x_new_document_type = 'QUOTATION') THEN
151: l_unique_id_tbl_name := 'PO_HEADERS_QUOTE';
152: ELSIF (x_new_document_type = 'RFQ') THEN
153: l_unique_id_tbl_name := 'PO_HEADERS_RFQ';
154: END IF;
155:
156: x_actual_document_num :=
157: PO_CORE_SV1.default_po_unique_identifier

Line 183: select po_headers_s.nextval

179: END IF;
180:
181: x_progress:= '005';
182:
183: select po_headers_s.nextval
184: into x_local_po_header_id
185: from dual;
186:
187: x_new_po_header_id:= x_local_po_header_id;

Line 191: insert into po_headers(

187: x_new_po_header_id:= x_local_po_header_id;
188:
189: x_progress:= '006';
190:
191: insert into po_headers(
192: PO_HEADER_ID
193: ,AGENT_ID
194: ,TYPE_LOOKUP_CODE
195: ,LAST_UPDATE_DATE

Line 394: from po_headers

390: -- Bug 3648268. Using lookup code instead of hardcoded value
391: ,'COPY_DOCUMENT' --
392: ,STYLE_ID --
393: ,decode(x_new_document_type, 'QUOTATION', nvl(created_language, PO_ATTRIBUTE_VALUES_PVT.get_base_lang), created_language) --Bug#5401155
394: from po_headers
395: where po_header_id = x_po_header_id;
396:
397: IF(x_copy_attachments = 'Y') THEN
398:

Line 403: copy_attachments('PO_HEADERS',

399: x_progress:= '007';
400:
401: --API to copy attachments from requisition line to po line
402: fnd_attached_documents2_pkg.
403: copy_attachments('PO_HEADERS',
404: x_po_header_id,
405: '',
406: '',
407: '',

Line 409: 'PO_HEADERS',

405: '',
406: '',
407: '',
408: '',
409: 'PO_HEADERS',
410: x_local_po_header_id,
411: '',
412: '',
413: '',

Line 529: x_ship_to_location_id po_headers.ship_to_location_id%type;

525:
526: /* Additional tax variables for R11 tax defaulting functionality */
527: x_tax_id ap_tax_codes.tax_id%type;
528: x_allow_tax_code_override_flag gl_tax_option_accounts.allow_tax_code_override_flag%type;
529: x_ship_to_location_id po_headers.ship_to_location_id%type;
530: x_ship_to_loc_org_id hr_locations.inventory_organization_id%type;
531: x_item_id mtl_system_items.inventory_item_id%type;
532: x_new_tax_flag varchar2(1):=null;
533:

Line 598: FROM po_headers poh

594:
595: BEGIN
596: SELECT poh.ship_to_location_id
597: INTO x_ship_to_location_id
598: FROM po_headers poh
599: WHERE poh.po_header_id = x_from_po_header_id;
600: EXCEPTION
601: WHEN NO_DATA_FOUND THEN
602: x_ship_to_location_id := NULL;