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_HEADERS_ALL_EXT_B

Line 98: -- updates the revision_num of po_headers_all_ext_b if draft_type is mod

94: --Pre-reqs: None
95: --Modifies:
96: --Locks:
97: --Function:
98: -- updates the revision_num of po_headers_all_ext_b if draft_type is mod
99: --Parameters:
100: --IN:p_draft_id IN NUMBER
101: -- p_po_header_id IN NUMBER
102: --IN OUT:

Line 157: UPDATE po_headers_all_ext_b phaeb

153: PO_LOG.stmt(d_module,d_position,'l_is_mod_document',l_is_mod_document);
154: END IF;
155:
156: IF l_is_mod_document ='Y' THEN
157: UPDATE po_headers_all_ext_b phaeb
158: SET revision_num = l_header_revision
159: WHERE EXISTS ( SELECT 'Lock exists for the address'
160: FROM po_entity_locks poel
161: WHERE poel.entity_pk1 = phaeb.po_header_id

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 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 5629: -- Identify Header level locks required because of change in po_headers_all_ext_b

5625: PO_LOG.proc_begin(d_module);
5626: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
5627: END IF;
5628:
5629: -- Identify Header level locks required because of change in po_headers_all_ext_b
5630: INSERT INTO po_session_gt(
5631: key,
5632: index_char1, -- records identifier
5633: index_char2, -- entity_name

Line 5742: FROM po_headers_all_ext_b phb,

5738: NVL(phb.d_ext_attr9 ,G_NULL_DATE),
5739: NVL(phb.d_ext_attr10 ,G_NULL_DATE)
5740: ) p_lock_attrs,
5741: phb.attr_group_id
5742: FROM po_headers_all_ext_b phb,
5743: po_session_gt pogt,
5744: ego_fnd_dsc_flx_ctx_ext ag
5745: WHERE phb.po_header_id = pogt.char1 -- po_header_id
5746: AND phb.draft_id = G_DRAFT_ID_MINUS_1

Line 5847: FROM po_headers_all_ext_b phbd,

5843: nvl(phbd.d_ext_attr9 ,g_null_date),
5844: NVL(phbd.d_ext_attr10 ,G_NULL_DATE)
5845: ) p_lock_attrs,
5846: phbd.attr_group_id
5847: FROM po_headers_all_ext_b phbd,
5848: po_session_gt pogt,
5849: ego_fnd_dsc_flx_ctx_ext ag
5850: WHERE phbd.draft_id = p_draft_id
5851: AND phbd.po_header_id = pogt.char1 -- po_header_id

Line 5873: -- for such attribute groups are not created in po_headers_all_ext_b.

5869: WHERE draft_id = p_draft_id;
5870:
5871: -- When a UDA attribute group does not have any attribute which has default
5872: -- value and user also does not enter any attribute value, then records
5873: -- for such attribute groups are not created in po_headers_all_ext_b.
5874: -- Now if user modifies such attribute groups in Mod, then a new record is
5875: -- created with the draft_id. We need to identify such records and lock the
5876: -- header as P lock.
5877: INSERT INTO po_session_gt(

Line 5898: FROM po_headers_all_ext_b draft,

5894: AND phda.po_header_id = pogt.char1 -- po_header_id
5895: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
5896: AND pogt.index_char2 = G_LOCK_HEADER_ENTITY
5897: AND EXISTS (SELECT draft.attr_group_id
5898: FROM po_headers_all_ext_b draft,
5899: po_uda_ag_template_usages uda_usg,
5900: ego_fnd_dsc_flx_ctx_ext ag
5901: WHERE draft.po_header_id = l_po_header_id
5902: AND draft.draft_id = p_draft_id

Line 5910: FROM po_headers_all_ext_b base,

5906: AND draft.attr_group_id = ag.attr_group_id
5907: AND ag.multi_row = 'N'
5908: MINUS
5909: SELECT base.attr_group_id
5910: FROM po_headers_all_ext_b base,
5911: po_uda_ag_template_usages uda_usg,
5912: ego_fnd_dsc_flx_ctx_ext ag
5913: WHERE base.po_header_id = l_po_header_id
5914: AND base.draft_id = -1

Line 5929: -- attribute groups in po_headers_all_ext_b.

5925: PO_LOG.stmt(d_module,d_position ,'number of rows Inserted ',SQL%ROWCOUNT);
5926: END IF;
5927:
5928: -- Identify Header level locks required because of change in multi-row
5929: -- attribute groups in po_headers_all_ext_b.
5930: -- Ignore the addresses.
5931: INSERT INTO po_session_gt(
5932: key,
5933: index_char1, -- records identifier

Line 6042: FROM po_headers_all_ext_b pohextb,

6038: d_ext_attr7,
6039: d_ext_attr8,
6040: d_ext_attr9,
6041: d_ext_attr10
6042: FROM po_headers_all_ext_b pohextb,
6043: ego_fnd_dsc_flx_ctx_ext ag
6044: WHERE pohextb.po_header_id = pohd.po_header_id
6045: AND pohextb.draft_id = p_draft_id
6046: AND pohextb.attr_group_id = ag.attr_group_id

Line 6141: FROM po_headers_all_ext_b pohextb,

6137: d_ext_attr7,
6138: d_ext_attr8,
6139: d_ext_attr9,
6140: d_ext_attr10
6141: FROM po_headers_all_ext_b pohextb,
6142: ego_fnd_dsc_flx_ctx_ext ag
6143: WHERE pohextb.po_header_id = pohd.po_header_id
6144: AND pohextb.draft_id = G_DRAFT_ID_MINUS_1
6145: AND pohextb.attr_group_id = ag.attr_group_id

Line 6241: FROM po_headers_all_ext_b pohextb,

6237: d_ext_attr7,
6238: d_ext_attr8,
6239: d_ext_attr9,
6240: d_ext_attr10
6241: FROM po_headers_all_ext_b pohextb,
6242: ego_fnd_dsc_flx_ctx_ext ag
6243: WHERE pohextb.po_header_id = pohd.po_header_id
6244: AND pohextb.draft_id = G_DRAFT_ID_MINUS_1
6245: AND pohextb.attr_group_id = ag.attr_group_id

Line 6340: FROM po_headers_all_ext_b pohextb,

6336: d_ext_attr7,
6337: d_ext_attr8,
6338: d_ext_attr9,
6339: d_ext_attr10
6340: FROM po_headers_all_ext_b pohextb,
6341: ego_fnd_dsc_flx_ctx_ext ag
6342: WHERE pohextb.po_header_id = pohd.po_header_id
6343: AND pohextb.draft_id = p_draft_id
6344: AND pohextb.attr_group_id = ag.attr_group_id

Line 6604: FROM po_headers_all_ext_b phb,

6600: NVL(phb.d_ext_attr10 ,G_NULL_DATE)
6601: ) P_LOCK_ATTRS,
6602: phb.attr_group_id,
6603: phb.c_ext_attr39
6604: FROM po_headers_all_ext_b phb,
6605: po_session_gt pogt
6606: WHERE phb.po_header_id = pogt.char1 -- po_header_id
6607: AND phb.draft_id = G_DRAFT_ID_MINUS_1
6608: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 6708: FROM po_headers_all_ext_b phbd,

6704: NVL(phbd.d_ext_attr10 ,G_NULL_DATE)
6705: ) p_lock_attrs,
6706: phbd.attr_group_id,
6707: phbd.c_ext_attr39
6708: FROM po_headers_all_ext_b phbd,
6709: po_session_gt pogt
6710: WHERE phbd.draft_id = p_draft_id
6711: AND phbd.po_header_id = pogt.char1 -- po_header_id
6712: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 8868: -- po_headers_all_ext_b --> cleans up extra records for FORMS attribute

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:
8872: --IN:

Line 8953: --Delete extra FORMS attribute record from po_headers_all_ext_b

8949: PO_LOG.stmt(d_module,d_position ,'number of rows deleted ',SQL%ROWCOUNT);
8950: END IF;
8951:
8952: d_position := 20;
8953: --Delete extra FORMS attribute record from po_headers_all_ext_b
8954: DELETE FROM po_headers_all_ext_b phe
8955: where phe.po_header_id = p_po_header_id
8956: AND Nvl(phe.draft_id,-1) = p_draft_id
8957:

Line 8954: DELETE FROM po_headers_all_ext_b phe

8950: END IF;
8951:
8952: d_position := 20;
8953: --Delete extra FORMS attribute record from po_headers_all_ext_b
8954: DELETE FROM po_headers_all_ext_b phe
8955: where phe.po_header_id = p_po_header_id
8956: AND Nvl(phe.draft_id,-1) = p_draft_id
8957:
8958: AND EXISTS ( SELECT 1

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

8964: AND Nvl(ptu.attribute1, '*') <> Nvl(phm.clm_standard_form, '*')
8965: AND phe.attr_group_id = ptu.attribute_group_id
8966: );
8967: IF (PO_LOG.d_stmt) THEN
8968: PO_LOG.stmt(d_module,d_position ,'Deleted extra forms uda records from po_headers_all_ext_b');
8969: PO_LOG.stmt(d_module,d_position ,'number of rows deleted ',SQL%ROWCOUNT);
8970: END IF;
8971:
8972: d_position := 30;