APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_HEADERS_ALL_EXT_B

Line 4651: --Check if doc_numbering record exists in po_headers_all_ext_b

4647: IF (PO_LOG.d_stmt) THEN
4648: PO_LOG.stmt(d_module, d_position, 'l_source_org_owned : ' || l_source_org_owned);
4649: END IF;
4650:
4651: --Check if doc_numbering record exists in po_headers_all_ext_b
4652: SELECT Count(attr_group_id)
4653: INTO l_count
4654: FROM po_headers_all_ext_b
4655: WHERE po_header_id = p_doc_rec.po_header_id

Line 4654: FROM po_headers_all_ext_b

4650:
4651: --Check if doc_numbering record exists in po_headers_all_ext_b
4652: SELECT Count(attr_group_id)
4653: INTO l_count
4654: FROM po_headers_all_ext_b
4655: WHERE po_header_id = p_doc_rec.po_header_id
4656: AND Nvl(draft_id,-1) = -1
4657: AND UDA_TEMPLATE_ID = l_template_id
4658: AND ATTR_GROUP_ID = ( SELECT ATTRIBUTE_GROUP_ID FROM po_uda_ag_template_usages

Line 4666: PO_LOG.stmt(d_module, d_position, 'l_count to indicate whether doc_numbering record exists in po_headers_all_ext_b: ' || l_count);

4662: AND ATTRIBUTE2 = l_source_org_owned
4663: AND ATTRIBUTE3 = 'DEFAULT'
4664: );
4665: IF (PO_LOG.d_stmt) THEN
4666: PO_LOG.stmt(d_module, d_position, 'l_count to indicate whether doc_numbering record exists in po_headers_all_ext_b: ' || l_count);
4667: END IF;
4668: --Default doc number only if user has not input any data in uda_interface table
4669: IF l_count = 0
4670: THEN

Line 4690: FROM po_headers_all_ext_b

4686: --Stamp the clm doc number
4687: UPDATE po_headers_all SET
4688: CLM_DOCUMENT_NUMBER = l_doc_number,
4689: SEGMENT1 = (SELECT REPLACE(l_doc_number, l_delimiter, '')
4690: FROM po_headers_all_ext_b
4691: WHERE po_header_id = p_doc_rec.po_header_id
4692: AND Nvl(draft_id,-1) = -1
4693: AND UDA_TEMPLATE_ID = l_template_id
4694: AND ATTR_GROUP_ID = ( SELECT ATTRIBUTE_GROUP_ID FROM po_uda_ag_template_usages