APPS.PO_DRAFTS_PVT dependencies on PO_LINES_ALL_EXT_TL

Line 6749: -- po_lines_all_ext_b, po_lines_all_ext_tl, complex pricing attributes.

6745: --Pre-reqs: None
6746: --Modifies:
6747: -- po_entity_locks
6748: --Locks:
6749: -- po_lines_all_ext_b, po_lines_all_ext_tl, complex pricing attributes.
6750: --Function:
6751: -- This procedure generates the change data for the passed entities PKs,
6752: -- creates entries in po_entity_locks table corresponding to the modified
6753: -- attributes, and locks the required rows in transaction tables.

Line 7075: -- Identify Line level locks required because of change in po_lines_all_ext_tl

7071: PO_LOG.stmt_all_session_gt(d_module, d_position, G_LOCKS_REQUIRED_ID);
7072: PO_LOG.stmt(d_module,d_position ,'number of rows Inserted ',SQL%ROWCOUNT);
7073: END IF;
7074:
7075: -- Identify Line level locks required because of change in po_lines_all_ext_tl
7076: INSERT INTO po_session_gt(
7077: key,
7078: index_char1, -- records identifier
7079: index_char2, -- entity_name

Line 7139: FROM po_lines_all_ext_tl plt,

7135: NVL(plt.tl_ext_attr40 ,G_NULL_CHAR)
7136: ) p_lock_attrs,
7137: plt.attr_group_id,
7138: plt.language
7139: FROM po_lines_all_ext_tl plt,
7140: po_session_gt pogt
7141: where plt.po_line_id = pogt.char1 -- po_line_id
7142: AND plt.draft_id = G_DRAFT_ID_MINUS_1
7143: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 7192: FROM po_lines_all_ext_tl pltd,

7188: NVL(pltd.tl_ext_attr40 ,G_NULL_CHAR)
7189: ) p_lock_attrs,
7190: pltd.attr_group_id,
7191: pltd.language
7192: FROM po_lines_all_ext_tl pltd,
7193: po_session_gt pogt
7194: WHERE pltd.draft_id = p_draft_id
7195: AND pltd.po_line_id = pogt.char1 -- po_header_id
7196: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 8566: FROM po_lines_all_ext_tl

8562: AND pk1_value = -p_po_draft_id);
8563:
8564: FORALL i IN 1..po_line_ids_tbl.Count()
8565: DELETE
8566: FROM po_lines_all_ext_tl
8567: WHERE (po_line_id = po_line_ids_tbl(i) -- main record for Mod
8568: AND draft_id = p_po_draft_id)
8569: OR -- old record for Mod complex pricing attribute
8570: (po_line_id = po_line_ids_tbl(i)

Line 8687: DELETE FROM po_lines_all_ext_tl

8683: WHERE po_line_id = l_line_id_tbl(i)
8684: AND draft_id = p_draft_id;
8685:
8686: FORALL i IN 1..l_line_id_tbl.Count()
8687: DELETE FROM po_lines_all_ext_tl
8688: WHERE po_line_id = l_line_id_tbl(i)
8689: AND draft_id = p_draft_id;
8690:
8691: --Bug 13938456

Line 8869: -- po_lines_all_ext_tl --> cleans up extra records for PRICING attribute

8865: --Function:
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:

Line 8925: --Delete extra PRICING attribute record from po_lines_all_ext_tl

8921: PO_LOG.stmt(d_module,d_position ,'number of rows deleted ',SQL%ROWCOUNT);
8922: END IF;
8923:
8924: d_position := 10;
8925: --Delete extra PRICING attribute record from po_lines_all_ext_tl
8926: DELETE FROM po_lines_all_ext_tl ple
8927: where ( Abs(ple.po_line_id), Abs(ple.draft_id) ) IN ( SELECT po_line_id, Decode(draft_id,-1,1,draft_id)
8928: FROM po_lines_merge_v
8929: WHERE po_header_id = p_po_header_id

Line 8926: DELETE FROM po_lines_all_ext_tl ple

8922: END IF;
8923:
8924: d_position := 10;
8925: --Delete extra PRICING attribute record from po_lines_all_ext_tl
8926: DELETE FROM po_lines_all_ext_tl ple
8927: where ( Abs(ple.po_line_id), Abs(ple.draft_id) ) IN ( SELECT po_line_id, Decode(draft_id,-1,1,draft_id)
8928: FROM po_lines_merge_v
8929: WHERE po_header_id = p_po_header_id
8930: AND draft_id = p_draft_id

Line 8948: PO_LOG.stmt(d_module,d_position ,'Deleted extra prcing uda records from po_lines_all_ext_tl');

8944: )
8945: AND ple.attr_group_id = ptu.attribute_group_id
8946: );
8947: IF (PO_LOG.d_stmt) THEN
8948: PO_LOG.stmt(d_module,d_position ,'Deleted extra prcing uda records from po_lines_all_ext_tl');
8949: PO_LOG.stmt(d_module,d_position ,'number of rows deleted ',SQL%ROWCOUNT);
8950: END IF;
8951:
8952: d_position := 20;