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.

[Home] [Help]

APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_DRAFTS_PVT

Line 1216: AND entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY

1212: SELECT lock_type
1213: INTO l_lock_type
1214: FROM po_entity_locks
1215: WHERE lock_by_draft_id = p_draft_id
1216: AND entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY
1217: AND entity_pk1 = l_po_header_id;
1218: EXCEPTION
1219: WHEN NO_DATA_FOUND THEN
1220: l_lock_type := NULL;

Line 1643: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_LINE_ENTITY

1639: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
1640: AND NOT EXISTS (SELECT 'F locks'
1641: FROM po_entity_locks pel
1642: WHERE pel.entity_pk1 = plda.po_line_id
1643: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_LINE_ENTITY
1644: AND pel.lock_by_draft_id = plda.draft_id
1645: AND pel.lock_type = 'F');
1646:
1647: d_position := 20;

Line 1674: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_LINE_ENTITY

1670: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
1671: AND NOT EXISTS (SELECT 'F/P locks'
1672: FROM po_entity_locks pel
1673: WHERE pel.entity_pk1 = plda.po_line_id
1674: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_LINE_ENTITY
1675: AND pel.lock_by_draft_id = plda.draft_id
1676: AND pel.lock_type IN ('F', 'P'));
1677: d_position := 40;
1678: IF (PO_LOG.d_stmt) THEN

Line 1696: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_LINE_ENTITY

1692: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
1693: AND NOT EXISTS (SELECT 'F locks'
1694: FROM po_entity_locks pel
1695: WHERE pel.entity_pk1 = plda.po_line_id
1696: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_LINE_ENTITY
1697: AND pel.lock_by_draft_id = plda.draft_id
1698: AND pel.lock_type ='F');
1699:
1700: -- 3. Delete lines identified in #2 above.

Line 2056: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_SHIPMENT_ENTITY

2052: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
2053: AND NOT EXISTS (SELECT 'F locks'
2054: FROM po_entity_locks pel
2055: WHERE pel.entity_pk1 = plda.line_location_id
2056: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_SHIPMENT_ENTITY
2057: AND pel.lock_by_draft_id = plda.draft_id
2058: AND pel.lock_type = 'F')
2059: AND pla.shipment_type <> 'PRICE BREAK';
2060:

Line 2089: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_SHIPMENT_ENTITY

2085: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
2086: AND NOT EXISTS (SELECT 'P/F locks'
2087: FROM po_entity_locks pel
2088: WHERE pel.entity_pk1 = plda.line_location_id
2089: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_SHIPMENT_ENTITY
2090: AND pel.lock_by_draft_id = plda.draft_id
2091: AND pel.lock_type IN ('F','P'))
2092: AND pla.shipment_type <> 'PRICE BREAK';
2093:

Line 2276: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_DIST_ENTITY

2272: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
2273: AND NOT EXISTS (SELECT 'F locks'
2274: FROM po_entity_locks pel
2275: WHERE pel.entity_pk1 = plda.po_distribution_id
2276: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_DIST_ENTITY
2277: AND pel.lock_by_draft_id = plda.draft_id
2278: AND pel.lock_type = 'F')
2279: AND pla.distribution_type <> 'AGREEMENT';
2280:

Line 2309: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_DIST_ENTITY

2305: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
2306: AND NOT EXISTS (SELECT 'P/F locks'
2307: FROM po_entity_locks pel
2308: WHERE pel.entity_pk1 = plda.po_distribution_id
2309: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_DIST_ENTITY
2310: AND pel.lock_by_draft_id = plda.draft_id
2311: AND pel.lock_type IN ('F','P'))
2312: AND pla.distribution_type <> 'AGREEMENT';
2313:

Line 2553: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY

2549: AND NOT EXISTS (SELECT 'only S or Null Locks'
2550: FROM po_entity_locks pel
2551: WHERE pel.lock_type IN ('P','F')
2552: AND pel.entity_pk1= phb1.po_header_id
2553: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY
2554: AND pel.lock_by_draft_id = p_draft_id )
2555: -- exclude multi-row attribute groups
2556: AND EXISTS (SELECT 'Single row attr grp'
2557: FROM ego_fnd_dsc_flx_ctx_ext ag

Line 2895: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY

2891: AND NOT EXISTS (SELECT 'only S or Null Locks'
2892: FROM po_entity_locks pel
2893: WHERE pel.lock_type IN ('P','F')
2894: AND pel.entity_pk1= pheb.po_header_id
2895: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY
2896: AND pel.lock_by_draft_id = p_draft_id )
2897: AND EXISTS (SELECT 'if multi row attr grp'
2898: FROM ego_fnd_dsc_flx_ctx_ext ag
2899: WHERE pheb.attr_group_id = ag.attr_group_id

Line 3131: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY

3127: AND NOT EXISTS (SELECT 'only S or Null Locks'
3128: FROM po_entity_locks pel
3129: WHERE pel.lock_type IN ('P','F')
3130: AND pel.entity_pk1= phb.po_header_id
3131: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY
3132: AND pel.lock_by_draft_id = p_draft_id )
3133: AND EXISTS (SELECT 'Multi row attr grp'
3134: FROM ego_fnd_dsc_flx_ctx_ext ag
3135: WHERE phb.attr_group_id = ag.attr_group_id

Line 3172: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY

3168: AND NOT EXISTS (SELECT 'only S or Null Locks'
3169: FROM po_entity_locks pel
3170: WHERE pel.lock_type IN ('P','F')
3171: AND pel.entity_pk1= phaet.po_header_id
3172: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY
3173: AND pel.lock_by_draft_id = p_draft_id )
3174: AND NOT EXISTS (SELECT 'Exclude Uda attributes'
3175: FROM po_headers_all_ext_b phb
3176: WHERE PHB.EXTENSION_ID = phaet.EXTENSION_ID

Line 4682: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_ADDRESS_ENTITY

4678: FROM po_entity_locks pel
4679: WHERE pel.lock_type IN ('P','F')
4680: AND pel.entity_pk1= phbd.po_header_id
4681: AND pel.entity_pk2= phbd.c_ext_attr39
4682: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_ADDRESS_ENTITY
4683: AND pel.lock_by_draft_id = p_draft_id )
4684: AND EXISTS (SELECT 'base.rev_num>draft.rev_num'
4685: FROM po_headers_all_ext_b phb,
4686: po_drafts dft

Line 4840: -- PO_DRAFTS_PVT.update_draft_status which is called from

4836:
4837: --commit the code upto this point,because po_drafts table is getting updated
4838: --for the row corresponding to draft_id=p_draft_id
4839: --and this table will again get updated for the same row in
4840: -- PO_DRAFTS_PVT.update_draft_status which is called from
4841: -- PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous,an autonoumous transaction,
4842: -- via a call to TRANSFER_DRAFT_TO_TXN.
4843: -- this results in deadlock ERROR
4844: --similarly other tables also create deadlock error if the code isnt commited till this point.