APPS.PO_EXHIBITS_PVT dependencies on PO_EXHIBIT_DETAILS_DRAFT

Line 269: FROM po_exhibit_details_draft

265: END IF;
266:
267: SELECT 1
268: INTO l_dummy
269: FROM po_exhibit_details_draft
270: WHERE po_exhibit_details_id = p_po_exhibit_details_id
271: AND draft_id = p_draft_id
272: FOR UPDATE NOWAIT;
273:

Line 414: INSERT INTO po_exhibit_details_draft

410: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
411: END IF;
412:
413: FORALL i IN 1..p_po_exhibit_details_id_tbl.Count
414: INSERT INTO po_exhibit_details_draft
415: (
416: po_exhibit_details_id,
417: po_header_id,
418: draft_id,

Line 459: UPDATE po_exhibit_details_draft

455: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
456: END IF;
457:
458: FORALL i IN 1..p_po_exhibit_details_id_tbl.COUNT
459: UPDATE po_exhibit_details_draft
460: SET delete_flag = p_delete_flag_tbl(i)
461: WHERE po_exhibit_details_id = p_po_exhibit_details_id_tbl(i)
462: AND draft_id = p_draft_id_tbl(i)
463: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 634: FROM po_exhibit_details_draft PDD

630: SELECT l_key,
631: l_index_tbl(i)
632: FROM DUAL
633: WHERE EXISTS (SELECT 1
634: FROM po_exhibit_details_draft PDD
635: WHERE PDD.draft_id = p_draft_id_tbl(i)
636: AND PDD.po_exhibit_details_id =
637: NVL(p_po_exhibit_details_id_tbl(i),
638: PDD.po_exhibit_details_id)

Line 785: FROM po_exhibit_details_draft ped

781:
782: DELETE FROM po_exhibit_details pe
783: WHERE pe.po_exhibit_details_id IN
784: ( SELECT ped.po_exhibit_details_id -- Bug 5292573
785: FROM po_exhibit_details_draft ped
786: WHERE ped.draft_id = p_draft_id
787: AND ped.delete_flag = 'Y'
788: AND NVL(ped.change_accepted_flag, 'Y') = 'Y' );
789:

Line 808: FROM po_exhibit_details_draft PED

804: PED.last_updated_by,
805: PED.creation_date,
806: PED.created_by,
807: PED.last_update_login
808: FROM po_exhibit_details_draft PED
809: WHERE PED.draft_id = p_draft_id
810: AND NVL(PED.change_accepted_flag, 'Y') = 'Y'
811: ) PEDV
812: ON (PE.po_exhibit_details_id = PEDV.po_exhibit_details_id)

Line 972: DELETE FROM po_exhibit_details_draft

968: IF (PO_LOG.d_proc) THEN
969: PO_LOG.proc_begin(d_module);
970: END IF;
971:
972: DELETE FROM po_exhibit_details_draft
973: WHERE draft_id = p_draft_id
974: AND po_exhibit_details_id = NVL(p_po_exhibit_details_id, po_exhibit_details_id);
975:
976: d_position := 10;

Line 1111: INSERT INTO po_exhibit_details_draft

1107: END;
1108:
1109: -- No records exists for this exhibit for given document
1110: IF( l_is_valid_exhibit = 'Y') THEN
1111: INSERT INTO po_exhibit_details_draft
1112: (
1113: po_exhibit_details_id,
1114: po_header_id,
1115: draft_id,

Line 1239: DELETE po_exhibit_details_draft mex

1235: AND ex.is_cdrl = p_is_cdrl_tbl(i);
1236:
1237: ELSIF( p_document_type_tbl(i) IN ('PO_STANDARD_MOD', 'PA_CONTRACT_MOD', 'PA_BLANKET_MOD') ) THEN
1238:
1239: DELETE po_exhibit_details_draft mex
1240: WHERE mex.exhibit_name = p_exhibit_name_tbl(i)
1241: AND mex.draft_id = p_document_id_tbl(i)
1242: AND mex.is_cdrl = p_is_cdrl_tbl(i);
1243:

Line 1382: INSERT INTO po_exhibit_details_draft

1378: END IF;
1379:
1380: l_docid := p_po_draft_id;
1381:
1382: INSERT INTO po_exhibit_details_draft
1383: (
1384: po_exhibit_details_id,
1385: po_header_id,
1386: draft_id,

Line 1412: FROM po_exhibit_details_draft dft

1408: fnd_global.user_id,
1409: SYSDATE,
1410: fnd_global.user_id,
1411: fnd_global.login_id
1412: FROM po_exhibit_details_draft dft
1413: WHERE po_header_id = p_po_header_id
1414: AND draft_id = p_po_draft_id
1415: AND exhibit_name = p_exhibit_name;
1416: