eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DRAFTS_PVT dependencies on PO_LINES_ALL_EXT_B

Line 4012: -- po_headers_all_ext_b,po_lines_all_ext_b,po_line_locations_all_ext_b,

4008: --Modifies:
4009: -- po_entity_locks
4010: --Locks:
4011: -- po_headers_all, po_lines_all, po_line_locations_all, po_distributions_all,
4012: -- po_headers_all_ext_b,po_lines_all_ext_b,po_line_locations_all_ext_b,
4013: -- po_distributions_all_ext_b, tl tables
4014: --Function:
4015: -- This procedure generates the change data for the passed entities PKs,
4016: -- creates entries in po_entity_locks table corresponding to the modified

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 6771: -- Identify Line level locks required because of change in po_lines_all_ext_b

6767: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
6768: d_position NUMBER;
6769:
6770: BEGIN
6771: -- Identify Line level locks required because of change in po_lines_all_ext_b
6772: d_position:=0;
6773: IF (PO_LOG.d_proc) THEN
6774: PO_LOG.proc_begin(d_module);
6775: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

Line 6890: FROM po_lines_all_ext_b plb,

6886: NVL(plb.d_ext_attr9 ,G_NULL_DATE),
6887: NVL(plb.d_ext_attr10 ,G_NULL_DATE)
6888: ) p_lock_attrs,
6889: plb.attr_group_id
6890: FROM po_lines_all_ext_b plb,
6891: po_session_gt pogt
6892: WHERE plb.po_line_id = pogt.char1 -- po_line_id
6893: AND plb.draft_id = G_DRAFT_ID_MINUS_1
6894: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 7000: FROM po_lines_all_ext_b plbd,

6996: NVL(plbd.d_ext_attr9 ,G_NULL_DATE),
6997: NVL(plbd.d_ext_attr10 ,G_NULL_DATE)
6998: ) p_lock_attrs,
6999: plbd.attr_group_id
7000: FROM po_lines_all_ext_b plbd,
7001: po_session_gt pogt
7002: WHERE plbd.draft_id = p_draft_id
7003: AND plbd.po_line_id = pogt.char1 -- po_line_id
7004: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 7026: -- for such attribute groups are not created in po_lines_all_ext_b.

7022: END IF;
7023:
7024: -- When a UDA attribute group does not have any attribute which has default
7025: -- value and user also does not enter any attribute value, then records
7026: -- for such attribute groups are not created in po_lines_all_ext_b.
7027: -- Now if user modifies such attribute groups in Mod, then a new record is
7028: -- created with the draft_id. We need to identify such records and lock the
7029: -- line as P lock.
7030: INSERT INTO po_session_gt(

Line 7051: FROM po_lines_all_ext_b draft,

7047: AND plbd.po_line_id = pogt.char1 -- po_line_id
7048: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
7049: AND pogt.index_char2 = G_LOCK_LINE_ENTITY
7050: AND EXISTS (SELECT draft.attr_group_id
7051: FROM po_lines_all_ext_b draft,
7052: po_uda_ag_template_usages uda_usg
7053: WHERE draft.po_line_id = plbd.po_line_id
7054: AND draft.draft_id = p_draft_id
7055: AND draft.uda_template_id = uda_usg.template_id

Line 7060: FROM po_lines_all_ext_b base,

7056: AND draft.attr_group_id = uda_usg.attribute_group_id
7057: AND uda_usg.attribute_category <> 'PRICING'
7058: MINUS
7059: SELECT base.attr_group_id
7060: FROM po_lines_all_ext_b base,
7061: po_uda_ag_template_usages uda_usg
7062: WHERE base.po_line_id = plbd.po_line_id
7063: AND base.draft_id = -1
7064: AND base.uda_template_id = uda_usg.template_id

Line 7227: FROM po_lines_all_ext_b polext_base,

7223: G_LOCK_LINE_ENTITY,
7224: polext_base.po_line_id,
7225: polext_draft.draft_id,
7226: 'S'
7227: FROM po_lines_all_ext_b polext_base,
7228: po_lines_all_ext_b polext_draft,
7229: po_session_gt pogt
7230: WHERE EXISTS (SELECT 'Is Complex Pricig Attribute'
7231: FROM po_uda_ag_template_usages agtu,

Line 7228: po_lines_all_ext_b polext_draft,

7224: polext_base.po_line_id,
7225: polext_draft.draft_id,
7226: 'S'
7227: FROM po_lines_all_ext_b polext_base,
7228: po_lines_all_ext_b polext_draft,
7229: po_session_gt pogt
7230: WHERE EXISTS (SELECT 'Is Complex Pricig Attribute'
7231: FROM po_uda_ag_template_usages agtu,
7232: po_lines_all pol

Line 7281: FROM po_lines_all_ext_b polext_base,

7277: G_LOCK_LINE_ENTITY,
7278: polext_base.po_line_id,
7279: polext_draft.draft_id,
7280: 'F'
7281: FROM po_lines_all_ext_b polext_base,
7282: po_lines_all_ext_b polext_draft,
7283: po_session_gt pogt
7284: WHERE EXISTS (SELECT 'Is Complex Pricig Attribute'
7285: FROM po_uda_ag_template_usages agtu,

Line 7282: po_lines_all_ext_b polext_draft,

7278: polext_base.po_line_id,
7279: polext_draft.draft_id,
7280: 'F'
7281: FROM po_lines_all_ext_b polext_base,
7282: po_lines_all_ext_b polext_draft,
7283: po_session_gt pogt
7284: WHERE EXISTS (SELECT 'Is Complex Pricig Attribute'
7285: FROM po_uda_ag_template_usages agtu,
7286: po_lines_all pol

Line 8552: FROM po_lines_all_ext_b

8548: END IF;
8549:
8550: FORALL i IN 1..po_line_ids_tbl.Count()
8551: DELETE
8552: FROM po_lines_all_ext_b
8553: WHERE (po_line_id = po_line_ids_tbl(i) -- main record for Mod
8554: AND draft_id = p_po_draft_id)
8555: OR -- old record for Mod complex pricing attribute
8556: (po_line_id = po_line_ids_tbl(i)

Line 8682: DELETE FROM po_lines_all_ext_b

8678: WHERE po_line_id = l_line_id_tbl(i)
8679: AND draft_id = p_draft_id;
8680:
8681: FORALL i IN 1..l_line_id_tbl.Count()
8682: DELETE FROM po_lines_all_ext_b
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()

Line 8867: -- po_lines_all_ext_b --> cleans up extra records for PRICING attribute

8863: --Name: clean_up_extra_uda
8864: -- Bug 13006217
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:

Line 8897: --Delete extra PRICING attribute record from po_lines_all_ext_b

8893: IF (PO_LOG.d_stmt) THEN
8894: PO_LOG.proc_begin(d_module, 'p_draft_id: ', p_draft_id);
8895: END IF;
8896:
8897: --Delete extra PRICING attribute record from po_lines_all_ext_b
8898: DELETE FROM po_lines_all_ext_b ple
8899: where ( Abs(ple.po_line_id), Abs(ple.draft_id) ) IN ( SELECT po_line_id, Decode(draft_id,-1,1,draft_id)
8900: FROM po_lines_merge_v
8901: WHERE po_header_id = p_po_header_id

Line 8898: DELETE FROM po_lines_all_ext_b ple

8894: PO_LOG.proc_begin(d_module, 'p_draft_id: ', p_draft_id);
8895: END IF;
8896:
8897: --Delete extra PRICING attribute record from po_lines_all_ext_b
8898: DELETE FROM po_lines_all_ext_b ple
8899: where ( Abs(ple.po_line_id), Abs(ple.draft_id) ) IN ( SELECT po_line_id, Decode(draft_id,-1,1,draft_id)
8900: FROM po_lines_merge_v
8901: WHERE po_header_id = p_po_header_id
8902: AND draft_id = p_draft_id

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

8916: AND ple.attr_group_id = ptu.attribute_group_id
8917: );
8918:
8919: IF (PO_LOG.d_stmt) THEN
8920: PO_LOG.stmt(d_module,d_position ,'Deleted extra prcing uda records from po_lines_all_ext_b');
8921: PO_LOG.stmt(d_module,d_position ,'number of rows deleted ',SQL%ROWCOUNT);
8922: END IF;
8923:
8924: d_position := 10;