APPS.PO_DRAFTS_PVT dependencies on PO_HEADERS_ALL_EXT_TL

Line 5601: -- po_headers_all_ext_b, header multi-row, po_headers_all_ext_tl, addresses

5597: --Pre-reqs: None
5598: --Modifies:
5599: -- po_entity_locks
5600: --Locks:
5601: -- po_headers_all_ext_b, header multi-row, po_headers_all_ext_tl, addresses
5602: --Function:
5603: -- This procedure generates the change data for the passed entities PKs,
5604: -- creates entries in po_entity_locks table corresponding to the modified
5605: -- attributes, and locks the required rows in transaction tables.

Line 6355: -- Identify Header level locks required because of change in po_headers_all_ext_tl

6351: PO_LOG.stmt_all_session_gt(d_module, d_position, G_LOCKS_REQUIRED_ID);
6352: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
6353: END IF;
6354:
6355: -- Identify Header level locks required because of change in po_headers_all_ext_tl
6356: INSERT INTO po_session_gt(
6357: key,
6358: index_char1, -- records identifier
6359: index_char2, -- entity_name

Line 6419: FROM po_headers_all_ext_tl put,

6415: NVL(put.tl_ext_attr40 ,G_NULL_CHAR)
6416: ) p_lock_attrs,
6417: put.attr_group_id,
6418: put.language
6419: FROM po_headers_all_ext_tl put,
6420: po_session_gt pogt
6421: where put.po_header_id = pogt.char1 -- po_header_id
6422: AND put.draft_id =G_DRAFT_ID_MINUS_1
6423: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 6472: FROM po_headers_all_ext_tl putd,

6468: NVL(putd.tl_ext_attr40 ,G_NULL_CHAR)
6469: ) p_lock_attrs,
6470: putd.attr_group_id,
6471: putd.language
6472: FROM po_headers_all_ext_tl putd,
6473: po_session_gt pogt
6474: WHERE putd.draft_id = p_draft_id
6475: AND putd.po_header_id = pogt.char1 -- po_header_id
6476: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 8870: -- po_headers_all_ext_tl --> cleans up extra records for FORMS attribute

8866: --This procedure deletes extra uda from ext tables
8867: -- po_lines_all_ext_b --> cleans up extra records for PRICING attribute
8868: -- po_headers_all_ext_b --> cleans up extra records for FORMS attribute
8869: -- po_lines_all_ext_tl --> cleans up extra records for PRICING attribute
8870: -- po_headers_all_ext_tl --> cleans up extra records for FORMS attribute
8871: --Parameters:
8872: --IN:
8873: --p_draft_id:
8874: -- draft id of the PO/Modification

Line 8973: --Delete extra FORMS attribute record from po_headers_all_ext_tl

8969: PO_LOG.stmt(d_module,d_position ,'number of rows deleted ',SQL%ROWCOUNT);
8970: END IF;
8971:
8972: d_position := 30;
8973: --Delete extra FORMS attribute record from po_headers_all_ext_tl
8974: DELETE FROM po_headers_all_ext_tl phe
8975: where phe.po_header_id = p_po_header_id
8976: AND Nvl(phe.draft_id,-1) = p_draft_id
8977:

Line 8974: DELETE FROM po_headers_all_ext_tl phe

8970: END IF;
8971:
8972: d_position := 30;
8973: --Delete extra FORMS attribute record from po_headers_all_ext_tl
8974: DELETE FROM po_headers_all_ext_tl phe
8975: where phe.po_header_id = p_po_header_id
8976: AND Nvl(phe.draft_id,-1) = p_draft_id
8977:
8978: AND EXISTS ( SELECT 1

Line 8988: PO_LOG.stmt(d_module,d_position ,'Deleted extra forms uda records from po_headers_all_ext_tl');

8984: AND Nvl(ptu.attribute1, '*') <> Nvl(phm.clm_standard_form, '*')
8985: AND phe.attr_group_id = ptu.attribute_group_id
8986: );
8987: IF (PO_LOG.d_stmt) THEN
8988: PO_LOG.stmt(d_module,d_position ,'Deleted extra forms uda records from po_headers_all_ext_tl');
8989: PO_LOG.stmt(d_module,d_position ,'number of rows deleted ',SQL%ROWCOUNT);
8990: END IF;
8991:
8992: d_position := 40;