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_MOD_SYNC_PROCESS_PVT dependencies on PO_ENTITY_LOCKS

Line 1214: FROM po_entity_locks

1210: /*fetch the lock_type */
1211: BEGIN
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

Line 1641: FROM po_entity_locks pel

1637: WHERE pla.po_line_id = plda.po_line_id
1638: AND plda.draft_id = p_draft_id
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');

Line 1672: FROM po_entity_locks pel

1668: WHERE plda.draft_id = p_draft_id
1669: AND pla.po_line_id = plda.po_line_id
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'));

Line 1694: FROM po_entity_locks pel

1690: WHERE plda.draft_id = p_draft_id
1691: AND pla.po_line_id = plda.po_line_id
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');

Line 2054: FROM po_entity_locks pel

2050: WHERE pla.line_location_id = plda.line_location_id
2051: AND plda.draft_id = p_draft_id
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')

Line 2087: FROM po_entity_locks pel

2083: WHERE plda.draft_id = p_draft_id
2084: AND pla.line_location_id = plda.line_location_id
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'))

Line 2274: FROM po_entity_locks pel

2270: WHERE pla.po_distribution_id = plda.po_distribution_id
2271: AND plda.draft_id = p_draft_id
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')

Line 2307: FROM po_entity_locks pel

2303: WHERE plda.draft_id = p_draft_id
2304: AND pla.po_distribution_id = plda.po_distribution_id
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'))

Line 2550: FROM po_entity_locks pel

2546: AND usg.attribute_group_id = phb1.attr_group_id
2547: AND usg.attribute_category IN ('DOCUMENT_NUMBERING', 'MODIFICATIONS')
2548: )
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 )

Line 2892: FROM po_entity_locks pel

2888: AND pheb.draft_id = p_draft_id
2889: AND (pheb.c_ext_attr40 NOT IN ('PO_UDA_ADDRESS_TYPES', 'PO_MOD_UDA_ADDRESS_TYPES')
2890: OR pheb.c_ext_attr40 IS NULL)
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 )

Line 3128: FROM po_entity_locks pel

3124: AND phb.po_header_id = l_po_header_id
3125: AND (phb.c_ext_attr40 NOT IN ('PO_UDA_ADDRESS_TYPES', 'PO_MOD_UDA_ADDRESS_TYPES')
3126: OR phb.c_ext_attr40 IS NULL)
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 )

Line 3169: FROM po_entity_locks pel

3165: FROM ego_fnd_dsc_flx_ctx_ext ag
3166: WHERE phaet.attr_group_id = ag.attr_group_id
3167: AND ag.multi_row = 'Y')
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 )

Line 4678: FROM po_entity_locks pel

4674: FROM ego_fnd_dsc_flx_ctx_ext ag
4675: WHERE phbd.attr_group_id = ag.attr_group_id
4676: AND ag.multi_row = 'Y')
4677: AND NOT EXISTS (SELECT 'only S or Null Locks'
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

Line 4986: --insert a row in po entity locks table

4982: IF (g_po_wf_debug = 'Y') THEN
4983: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4984: END IF;
4985:
4986: --insert a row in po entity locks table
4987:
4988: INSERT INTO po_entity_locks(
4989: po_entity_lock_id,
4990: entity_name,

Line 4988: INSERT INTO po_entity_locks(

4984: END IF;
4985:
4986: --insert a row in po entity locks table
4987:
4988: INSERT INTO po_entity_locks(
4989: po_entity_lock_id,
4990: entity_name,
4991: entity_pk1,
4992: lock_by_draft_id,

Line 5000: po_entity_locks_s.NEXTVAL,

4996: creation_date,
4997: created_by
4998: )
4999: VALUES(
5000: po_entity_locks_s.NEXTVAL,
5001: G_MOD_SYNC_LOCK,
5002: l_po_header_id,
5003: l_draft_id,
5004: 'F',

Line 5052: FROM po_entity_locks

5048: WHERE draft_id = l_draft_id;
5049:
5050: SELECT 'N'
5051: INTO l_is_lock_available
5052: FROM po_entity_locks
5053: WHERE entity_pk1 = l_po_header_id
5054: AND entity_name = G_MOD_SYNC_LOCK
5055: AND lock_by_draft_id <> l_draft_id;
5056:

Line 5301: FROM po_entity_locks

5297: FROM po_drafts
5298: WHERE draft_id = l_draft_id;
5299:
5300: delete
5301: FROM po_entity_locks
5302: WHERE lock_by_draft_id = l_draft_id
5303: AND entity_pk1 = l_po_header_id
5304: AND entity_name = G_MOD_SYNC_LOCK;
5305:

Line 5306: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: No Of rows deleted from po_entity_locks table : ' || SQL%ROWCOUNT;

5302: WHERE lock_by_draft_id = l_draft_id
5303: AND entity_pk1 = l_po_header_id
5304: AND entity_name = G_MOD_SYNC_LOCK;
5305:
5306: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: No Of rows deleted from po_entity_locks table : ' || SQL%ROWCOUNT;
5307: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5308:
5309: FOR item_key IN waiting_process_wf_keys(l_draft_id) LOOP
5310: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Item keys of waiting process : ' || item_key.item_key;