APPS.PO_CLM_UPG_PVT dependencies on PO_ENTITY_LOCKS

Line 126: -- create rows in po_entity_locks table with highest level of locks

122: -- Pre-reqs : None.
123: -- Function : This Procedure creates locks for all the entities modified by the open Modifications for
124: -- the given style_id.
125: -- Also,For records existing in all draft tables corresponding to open Modifications,
126: -- create rows in po_entity_locks table with highest level of locks
127: -- partial lock for header and addresses,
128: -- and full locks for lines, shipments, distributions and attachments.
129: -- Parameters :
130: -- IN :p_style_id IN NUMBER

Line 450: -- make an entry in po_entity_locks table

446: WHEN 'PO_HEADER' THEN
447:
448: --fetch header attachments
449: FOR l_rec IN fetch_attachment_ids(p_pk1_tbl(itr),p_draft_id,'PO_HEADERS') LOOP
450: -- make an entry in po_entity_locks table
451: INSERT INTO po_entity_locks(
452: po_entity_lock_id,
453: entity_name,
454: entity_pk1,

Line 451: INSERT INTO po_entity_locks(

447:
448: --fetch header attachments
449: FOR l_rec IN fetch_attachment_ids(p_pk1_tbl(itr),p_draft_id,'PO_HEADERS') LOOP
450: -- make an entry in po_entity_locks table
451: INSERT INTO po_entity_locks(
452: po_entity_lock_id,
453: entity_name,
454: entity_pk1,
455: entity_pk2,

Line 464: po_entity_locks_s.NEXTVAL,

460: creation_date,
461: created_by
462: )
463: VALUES(
464: po_entity_locks_s.NEXTVAL,
465: PO_DRAFTS_PVT.G_LOCK_HEADER_ATTACH_ENTITY,
466: p_pk1_tbl(itr),
467: l_rec.attached_document_id,
468: p_draft_id,

Line 481: -- make an entry in po_entity_locks table

477: WHEN 'PO_LINE' THEN
478:
479: --fetch line attachments
480: FOR l_rec IN fetch_attachment_ids(p_pk1_tbl(itr),p_draft_id,'PO_LINES') LOOP
481: -- make an entry in po_entity_locks table
482: INSERT INTO po_entity_locks(
483: po_entity_lock_id,
484: entity_name,
485: entity_pk1,

Line 482: INSERT INTO po_entity_locks(

478:
479: --fetch line attachments
480: FOR l_rec IN fetch_attachment_ids(p_pk1_tbl(itr),p_draft_id,'PO_LINES') LOOP
481: -- make an entry in po_entity_locks table
482: INSERT INTO po_entity_locks(
483: po_entity_lock_id,
484: entity_name,
485: entity_pk1,
486: entity_pk2,

Line 495: po_entity_locks_s.NEXTVAL,

491: creation_date,
492: created_by
493: )
494: VALUES(
495: po_entity_locks_s.NEXTVAL,
496: PO_DRAFTS_PVT.G_LOCK_LINE_ATTACH_ENTITY,
497: p_pk1_tbl(itr),
498: l_rec.attached_document_id,
499: p_draft_id,

Line 514: -- make an entry in po_entity_locks table

510:
511: --Fetch line location level attachments
512: FOR l_rec IN fetch_attachment_ids(p_pk1_tbl(itr),p_draft_id,'PO_SHIPMENTS') LOOP
513:
514: -- make an entry in po_entity_locks table
515: INSERT INTO po_entity_locks(
516: po_entity_lock_id,
517: entity_name,
518: entity_pk1,

Line 515: INSERT INTO po_entity_locks(

511: --Fetch line location level attachments
512: FOR l_rec IN fetch_attachment_ids(p_pk1_tbl(itr),p_draft_id,'PO_SHIPMENTS') LOOP
513:
514: -- make an entry in po_entity_locks table
515: INSERT INTO po_entity_locks(
516: po_entity_lock_id,
517: entity_name,
518: entity_pk1,
519: entity_pk2,

Line 528: po_entity_locks_s.NEXTVAL,

524: creation_date,
525: created_by
526: )
527: VALUES(
528: po_entity_locks_s.NEXTVAL,
529: PO_DRAFTS_PVT.G_LOCK_SHIPMENT_ATTACH_ENTITY,
530: p_pk1_tbl(itr),
531: l_rec.attached_document_id,
532: p_draft_id,