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_EXHIBIT_DETAILS

Line 432: UPDATE po_exhibit_details pex

428: )
429: AND pda.po_header_id=p_po_header_id;
430:
431: -- Update the revision number for all exhibits locked/modofied by the current mod
432: UPDATE po_exhibit_details pex
433: SET revision_num = l_header_revision
434: WHERE EXISTS ( SELECT 'Lock exists for the exhibit'
435: FROM po_entity_locks poel
436: WHERE poel.entity_pk1 = pex.po_exhibit_details_id

Line 436: WHERE poel.entity_pk1 = pex.po_exhibit_details_id

432: UPDATE po_exhibit_details pex
433: SET revision_num = l_header_revision
434: WHERE EXISTS ( SELECT 'Lock exists for the exhibit'
435: FROM po_entity_locks poel
436: WHERE poel.entity_pk1 = pex.po_exhibit_details_id
437: AND poel.lock_by_draft_id = p_draft_id
438: --AND poel.entity_name = G_LOCK_EXHIBIT_ENTITY
439: )
440: -- : Stamping revision_num for newly added shipment on mod.

Line 442: FROM po_exhibit_details_draft pexd

438: --AND poel.entity_name = G_LOCK_EXHIBIT_ENTITY
439: )
440: -- : Stamping revision_num for newly added shipment on mod.
441: OR EXISTS ( SELECT 'New Exhibit'
442: FROM po_exhibit_details_draft pexd
443: WHERE pexd.po_exhibit_details_id = pex.po_exhibit_details_id
444: AND pexd.draft_id = p_draft_id
445: AND pexd.change_status = 'NEW'
446: )

Line 443: WHERE pexd.po_exhibit_details_id = pex.po_exhibit_details_id

439: )
440: -- : Stamping revision_num for newly added shipment on mod.
441: OR EXISTS ( SELECT 'New Exhibit'
442: FROM po_exhibit_details_draft pexd
443: WHERE pexd.po_exhibit_details_id = pex.po_exhibit_details_id
444: AND pexd.draft_id = p_draft_id
445: AND pexd.change_status = 'NEW'
446: )
447: AND pex.po_header_id=p_po_header_id;

Line 689: p_po_exhibit_details_id => NULL

685: --
686: d_position := 85;
687: PO_EXHIBITS_PVT.delete_rows
688: ( p_draft_id => p_draft_id,
689: p_po_exhibit_details_id => NULL
690: );
691: --
692:
693: d_position := 90;

Line 905: p_po_exhibit_details_id => NULL

901:
902: x_draft_info.exhibits_changed :=
903: PO_EXHIBITS_PVT.draft_changes_exist
904: ( p_draft_id => p_draft_id,
905: p_po_exhibit_details_id => NULL
906: );
907: --
908:
909:

Line 2669: ELSIF (p_view_name = 'PO_EXHIBIT_DETAILS_MERGE_V') THEN

2665: );
2666: --
2667:
2668: --
2669: ELSIF (p_view_name = 'PO_EXHIBIT_DETAILS_MERGE_V') THEN
2670: d_position := 100;
2671:
2672: PO_EXHIBITS_PVT.lock_draft_record
2673: ( p_po_exhibit_details_id => p_entity_id,

Line 2673: ( p_po_exhibit_details_id => p_entity_id,

2669: ELSIF (p_view_name = 'PO_EXHIBIT_DETAILS_MERGE_V') THEN
2670: d_position := 100;
2671:
2672: PO_EXHIBITS_PVT.lock_draft_record
2673: ( p_po_exhibit_details_id => p_entity_id,
2674: p_draft_id => p_draft_id
2675: );
2676:
2677: PO_EXHIBITS_PVT.lock_transaction_record

Line 2678: ( p_po_exhibit_details_id => p_entity_id

2674: p_draft_id => p_draft_id
2675: );
2676:
2677: PO_EXHIBITS_PVT.lock_transaction_record
2678: ( p_po_exhibit_details_id => p_entity_id
2679: );
2680: --
2681:
2682:

Line 9140: --This procedure will insert the exhibit details into po_exhibit_details for the new Elins created for that dicument.

9136: --Start of Comments
9137: --Name: modify_exhibit_details
9138: -- CLM Phase 4 - Elins project
9139: --Function:
9140: --This procedure will insert the exhibit details into po_exhibit_details for the new Elins created for that dicument.
9141: --Parameters:
9142: --IN:
9143: --p_draft_id:
9144: -- draft id of the PO/Modification

Line 9167: po_exhibit_details_id_tbl PO_TBL_NUMBER;

9163:
9164: po_header_id_tbl PO_TBL_NUMBER;
9165: po_draft_id_tbl PO_TBL_NUMBER;
9166: clm_exhibit_name_tbl PO_TBL_VARCHAR30;
9167: po_exhibit_details_id_tbl PO_TBL_NUMBER;
9168:
9169:
9170: BEGIN
9171:

Line 9193: AND NOT EXISTS (SELECT 1 FROM po_exhibit_details_merge_v ex

9189: WHERE pl.clm_exhibit_name IS NOT NULL
9190: AND pl.po_header_id = p_po_header_id
9191: AND pl.draft_id = p_draft_id
9192: AND Nvl(pl.delete_flag,'N') <> 'Y'
9193: AND NOT EXISTS (SELECT 1 FROM po_exhibit_details_merge_v ex
9194: WHERE ex.exhibit_name = pl.clm_exhibit_name
9195: AND ex.po_header_id = pl.po_header_id
9196: AND ex.draft_id = pl.draft_id
9197: AND Nvl(ex.delete_flag,'N') <> 'Y');

Line 9207: -- Insert the exhibits that are created in document but does not exist in the PO_EXHIBIT_DETAILS

9203: PO_LOG.stmt(d_module,d_position ,'Fetched the new exhibit details',clm_exhibit_name_tbl.count);
9204: PO_LOG.stmt(d_module,d_position ,'number of rows selected ',SQL%ROWCOUNT);
9205: END IF;
9206:
9207: -- Insert the exhibits that are created in document but does not exist in the PO_EXHIBIT_DETAILS
9208: FORALL idx IN 1..clm_exhibit_name_tbl.Count
9209: INSERT INTO po_exhibit_details_draft
9210: (
9211: po_exhibit_details_id,

Line 9209: INSERT INTO po_exhibit_details_draft

9205: END IF;
9206:
9207: -- Insert the exhibits that are created in document but does not exist in the PO_EXHIBIT_DETAILS
9208: FORALL idx IN 1..clm_exhibit_name_tbl.Count
9209: INSERT INTO po_exhibit_details_draft
9210: (
9211: po_exhibit_details_id,
9212: exhibit_name,
9213: exhibit_description,

Line 9211: po_exhibit_details_id,

9207: -- Insert the exhibits that are created in document but does not exist in the PO_EXHIBIT_DETAILS
9208: FORALL idx IN 1..clm_exhibit_name_tbl.Count
9209: INSERT INTO po_exhibit_details_draft
9210: (
9211: po_exhibit_details_id,
9212: exhibit_name,
9213: exhibit_description,
9214: is_cdrl,
9215: po_header_id,

Line 9227: po_exhibit_details_s.nextval,

9223: LAST_UPDATE_LOGIN
9224: )
9225: (
9226: SELECT
9227: po_exhibit_details_s.nextval,
9228: clm_exhibit_name_tbl(idx),
9229: null, -- Description
9230: 'N', -- IsCdrl (Cdrl is inserted by contracts team)
9231: po_header_id_tbl(idx),

Line 9252: po_exhibit_details_id,

9248: PO_LOG.stmt(d_module,d_position ,'number of rows selected ',SQL%ROWCOUNT);
9249: END IF;
9250:
9251: SELECT DISTINCT
9252: po_exhibit_details_id,
9253: exhibit_name,
9254: po_header_id,
9255: draft_id
9256: BULK COLLECT INTO

Line 9257: po_exhibit_details_id_tbl,

9253: exhibit_name,
9254: po_header_id,
9255: draft_id
9256: BULK COLLECT INTO
9257: po_exhibit_details_id_tbl,
9258: clm_exhibit_name_tbl,
9259: po_header_id_tbl,
9260: po_draft_id_tbl
9261: FROM po_exhibit_details_merge_v ex

Line 9261: FROM po_exhibit_details_merge_v ex

9257: po_exhibit_details_id_tbl,
9258: clm_exhibit_name_tbl,
9259: po_header_id_tbl,
9260: po_draft_id_tbl
9261: FROM po_exhibit_details_merge_v ex
9262: WHERE ex.po_header_id = p_po_header_id
9263: AND ex.draft_id = p_draft_id
9264: AND ex.is_cdrl = 'N'
9265: AND Nvl(ex.delete_flag,'N') <> 'Y'

Line 9279: PO_LOG.stmt(d_module,d_position ,'Fetched the exhibit details for deletion',po_exhibit_details_id_tbl.count);

9275: AND NVL(pd.delete_flag, 'N') = 'Y')
9276: );
9277:
9278: IF (PO_LOG.d_stmt) THEN
9279: PO_LOG.stmt(d_module,d_position ,'Fetched the exhibit details for deletion',po_exhibit_details_id_tbl.count);
9280: PO_LOG.stmt(d_module,d_position ,'number of rows selected ',SQL%ROWCOUNT);
9281: END IF;
9282:
9283: -- Delete the exhibits that does not exists in document but exist in the PO_EXHIBIT_DETAILS

Line 9283: -- Delete the exhibits that does not exists in document but exist in the PO_EXHIBIT_DETAILS

9279: PO_LOG.stmt(d_module,d_position ,'Fetched the exhibit details for deletion',po_exhibit_details_id_tbl.count);
9280: PO_LOG.stmt(d_module,d_position ,'number of rows selected ',SQL%ROWCOUNT);
9281: END IF;
9282:
9283: -- Delete the exhibits that does not exists in document but exist in the PO_EXHIBIT_DETAILS
9284: FORALL idx IN 1..po_exhibit_details_id_tbl.Count
9285: INSERT INTO po_exhibit_details_draft
9286: (
9287: po_exhibit_details_id,

Line 9284: FORALL idx IN 1..po_exhibit_details_id_tbl.Count

9280: PO_LOG.stmt(d_module,d_position ,'number of rows selected ',SQL%ROWCOUNT);
9281: END IF;
9282:
9283: -- Delete the exhibits that does not exists in document but exist in the PO_EXHIBIT_DETAILS
9284: FORALL idx IN 1..po_exhibit_details_id_tbl.Count
9285: INSERT INTO po_exhibit_details_draft
9286: (
9287: po_exhibit_details_id,
9288: exhibit_name,

Line 9285: INSERT INTO po_exhibit_details_draft

9281: END IF;
9282:
9283: -- Delete the exhibits that does not exists in document but exist in the PO_EXHIBIT_DETAILS
9284: FORALL idx IN 1..po_exhibit_details_id_tbl.Count
9285: INSERT INTO po_exhibit_details_draft
9286: (
9287: po_exhibit_details_id,
9288: exhibit_name,
9289: exhibit_description,

Line 9287: po_exhibit_details_id,

9283: -- Delete the exhibits that does not exists in document but exist in the PO_EXHIBIT_DETAILS
9284: FORALL idx IN 1..po_exhibit_details_id_tbl.Count
9285: INSERT INTO po_exhibit_details_draft
9286: (
9287: po_exhibit_details_id,
9288: exhibit_name,
9289: exhibit_description,
9290: is_cdrl,
9291: po_header_id,

Line 9302: SELECT po_exhibit_details_id_tbl(idx),

9298: CREATED_BY,
9299: LAST_UPDATE_LOGIN
9300: )
9301: (
9302: SELECT po_exhibit_details_id_tbl(idx),
9303: clm_exhibit_name_tbl(idx),
9304: null,
9305: 'N',--DummyValue
9306: po_header_id_tbl(idx),

Line 9316: WHERE NOT EXISTS (SELECT 1 FROM po_exhibit_details_draft exd

9312: SYSDATE,
9313: fnd_global.user_id,
9314: fnd_global.login_id
9315: FROM dual
9316: WHERE NOT EXISTS (SELECT 1 FROM po_exhibit_details_draft exd
9317: WHERE exd.po_exhibit_details_id = po_exhibit_details_id_tbl(idx)
9318: )
9319: );
9320:

Line 9317: WHERE exd.po_exhibit_details_id = po_exhibit_details_id_tbl(idx)

9313: fnd_global.user_id,
9314: fnd_global.login_id
9315: FROM dual
9316: WHERE NOT EXISTS (SELECT 1 FROM po_exhibit_details_draft exd
9317: WHERE exd.po_exhibit_details_id = po_exhibit_details_id_tbl(idx)
9318: )
9319: );
9320:
9321: d_position := 20;

Line 9327: UPDATE po_exhibit_details_draft ex

9323: IF (PO_LOG.d_stmt) THEN
9324: PO_LOG.stmt(d_module,d_position ,'number of rows inserted for deletion ',SQL%ROWCOUNT);
9325: END IF;
9326:
9327: UPDATE po_exhibit_details_draft ex
9328: SET ex.delete_flag = 'Y'
9329: WHERE ex.po_exhibit_details_id IN (SELECT column_value FROM TABLE(po_exhibit_details_id_tbl));
9330:
9331: IF (PO_LOG.d_stmt) THEN

Line 9329: WHERE ex.po_exhibit_details_id IN (SELECT column_value FROM TABLE(po_exhibit_details_id_tbl));

9325: END IF;
9326:
9327: UPDATE po_exhibit_details_draft ex
9328: SET ex.delete_flag = 'Y'
9329: WHERE ex.po_exhibit_details_id IN (SELECT column_value FROM TABLE(po_exhibit_details_id_tbl));
9330:
9331: IF (PO_LOG.d_stmt) THEN
9332: PO_LOG.stmt(d_module,d_position ,'number of rows set for deletion ',SQL%ROWCOUNT);
9333: END IF;

Line 9466: -- po_exhibit_details

9462: --Pre-reqs: None
9463: --Modifies:
9464: -- po_entity_locks
9465: --Locks:
9466: -- po_exhibit_details
9467: --Function:
9468: -- This procedure generates the change data for the passed entities PKs,
9469: -- creates entries in po_entity_locks table corresponding to the modified
9470: -- attributes, and locks the required rows in transaction tables.

Line 9507: draft.po_exhibit_details_id, -- po_exhibit_details_id

9503: )
9504: SELECT po_session_gt_s.NEXTVAL,
9505: G_LOCKS_REQUIRED_ID,
9506: G_LOCK_EXHIBIT_ENTITY,
9507: draft.po_exhibit_details_id, -- po_exhibit_details_id
9508: draft.draft_id,
9509: CASE
9510: WHEN base.p_lock_attrs <> draft.p_lock_attrs THEN 'P'
9511: ELSE NULL

Line 9513: FROM (SELECT pex.po_exhibit_details_id,

9509: CASE
9510: WHEN base.p_lock_attrs <> draft.p_lock_attrs THEN 'P'
9511: ELSE NULL
9512: END lock_type
9513: FROM (SELECT pex.po_exhibit_details_id,
9514: G_DRAFT_ID_MINUS_1 draft_id,
9515: po_exhibit_mod_p_lock_attrs(
9516: NVL(pex.exhibit_description ,G_NULL_CHAR),
9517: NVL(pex.reference_line_id ,G_NULL_NUM)

Line 9519: FROM po_exhibit_details pex,

9515: po_exhibit_mod_p_lock_attrs(
9516: NVL(pex.exhibit_description ,G_NULL_CHAR),
9517: NVL(pex.reference_line_id ,G_NULL_NUM)
9518: ) p_lock_attrs
9519: FROM po_exhibit_details pex,
9520: po_session_gt pogt
9521: WHERE pex.po_exhibit_details_id = pogt.char1 -- po_exhibit_details_id
9522: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
9523: AND pogt.index_char2 = G_LOCK_EXHIBIT_ENTITY

Line 9521: WHERE pex.po_exhibit_details_id = pogt.char1 -- po_exhibit_details_id

9517: NVL(pex.reference_line_id ,G_NULL_NUM)
9518: ) p_lock_attrs
9519: FROM po_exhibit_details pex,
9520: po_session_gt pogt
9521: WHERE pex.po_exhibit_details_id = pogt.char1 -- po_exhibit_details_id
9522: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
9523: AND pogt.index_char2 = G_LOCK_EXHIBIT_ENTITY
9524: ) base,
9525: (SELECT pexd.po_exhibit_details_id,

Line 9525: (SELECT pexd.po_exhibit_details_id,

9521: WHERE pex.po_exhibit_details_id = pogt.char1 -- po_exhibit_details_id
9522: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
9523: AND pogt.index_char2 = G_LOCK_EXHIBIT_ENTITY
9524: ) base,
9525: (SELECT pexd.po_exhibit_details_id,
9526: pexd.draft_id,
9527: po_exhibit_mod_p_lock_attrs(
9528: NVL(pexd.exhibit_description ,G_NULL_CHAR),
9529: NVL(pexd.reference_line_id ,G_NULL_NUM)

Line 9531: FROM po_exhibit_details_draft pexd,

9527: po_exhibit_mod_p_lock_attrs(
9528: NVL(pexd.exhibit_description ,G_NULL_CHAR),
9529: NVL(pexd.reference_line_id ,G_NULL_NUM)
9530: ) p_lock_attrs
9531: FROM po_exhibit_details_draft pexd,
9532: po_session_gt pogt
9533: WHERE pexd.draft_id = p_draft_id
9534: AND pexd.po_exhibit_details_id = pogt.char1 -- po_exhibit_details_id
9535: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 9534: AND pexd.po_exhibit_details_id = pogt.char1 -- po_exhibit_details_id

9530: ) p_lock_attrs
9531: FROM po_exhibit_details_draft pexd,
9532: po_session_gt pogt
9533: WHERE pexd.draft_id = p_draft_id
9534: AND pexd.po_exhibit_details_id = pogt.char1 -- po_exhibit_details_id
9535: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
9536: AND pogt.index_char2 = G_LOCK_EXHIBIT_ENTITY
9537: ) draft
9538: WHERE base.po_exhibit_details_id = draft.po_exhibit_details_id

Line 9538: WHERE base.po_exhibit_details_id = draft.po_exhibit_details_id

9534: AND pexd.po_exhibit_details_id = pogt.char1 -- po_exhibit_details_id
9535: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
9536: AND pogt.index_char2 = G_LOCK_EXHIBIT_ENTITY
9537: ) draft
9538: WHERE base.po_exhibit_details_id = draft.po_exhibit_details_id
9539: AND base.p_lock_attrs <> draft.p_lock_attrs;
9540:
9541:
9542: d_position:=10;