APPS.PO_ATTR_VALUES_TLP_DRAFT_PKG dependencies on PO_ATTRIBUTE_VALUES_TLP_DRAFT

Line 48: DELETE FROM po_attribute_values_tlp_draft

44: IF (PO_LOG.d_proc) THEN
45: PO_LOG.proc_begin(d_module);
46: END IF;
47:
48: DELETE FROM po_attribute_values_tlp_draft
49: WHERE draft_id = p_draft_id
50: AND attribute_values_tlp_id = NVL(p_attribute_values_tlp_id,
51: attribute_values_tlp_id);
52:

Line 151: INSERT INTO po_attribute_values_tlp_draft

147: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
148: END IF;
149:
150: FORALL i IN 1..p_attribute_values_tlp_id_tbl.COUNT
151: INSERT INTO po_attribute_values_tlp_draft
152: ( draft_id,
153: delete_flag,
154: change_accepted_flag,
155: attribute_values_tlp_id,

Line 515: UPDATE po_attribute_values_tlp_draft

511: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
512: END IF;
513:
514: FORALL i IN 1..p_attribute_values_tlp_id_tbl.COUNT
515: UPDATE po_attribute_values_tlp_draft
516: SET delete_flag = p_delete_flag_tbl(i)
517: WHERE attribute_values_tlp_id = p_attribute_values_tlp_id_tbl(i)
518: AND draft_id = p_draft_id_tbl(i)
519: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 669: FROM po_attribute_values_tlp_draft PAVTD

665:
666: DELETE FROM po_attribute_values_tlp PAVT
667: WHERE PAVT.attribute_values_tlp_id IN
668: ( SELECT PAVTD.attribute_values_tlp_id
669: FROM po_attribute_values_tlp_draft PAVTD
670: WHERE PAVTD.draft_id = p_draft_id
671: AND PAVTD.delete_flag = 'Y'
672: AND NVL(PAVTD.change_accepted_flag, 'Y') = 'Y');
673:

Line 857: FROM po_attribute_values_tlp_draft PAVTD

853: PAVTD.request_id,
854: PAVTD.program_application_id,
855: PAVTD.program_id,
856: PAVTD.program_update_date
857: FROM po_attribute_values_tlp_draft PAVTD
858: WHERE PAVTD.draft_id = p_draft_id
859: AND NVL(PAVTD.change_accepted_flag, 'Y') = 'Y') PAVTDV
860: ON (PAVT.attribute_values_tlp_id = PAVTDV.attribute_values_tlp_id)
861: WHEN MATCHED THEN

Line 1432: FROM po_attribute_values_tlp_draft

1428: END IF;
1429:
1430: SELECT 1
1431: INTO l_dummy
1432: FROM po_attribute_values_tlp_draft
1433: WHERE attribute_values_tlp_id = p_attribute_values_tlp_id
1434: AND draft_id = p_draft_id
1435: FOR UPDATE NOWAIT;
1436: