APPS.PO_ATTR_VALUES_DRAFT_PKG dependencies on PO_ATTRIBUTE_VALUES_DRAFT

Line 48: DELETE FROM po_attribute_values_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_draft
49: WHERE draft_id = p_draft_id
50: AND attribute_values_id = NVL(p_attribute_values_id, attribute_values_id);
51:
52: d_position := 10;

Line 149: INSERT INTO po_attribute_values_draft

145: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
146: END IF;
147:
148: FORALL i IN 1..p_attribute_values_id_tbl.COUNT
149: INSERT INTO po_attribute_values_draft
150: ( draft_id,
151: delete_flag,
152: change_accepted_flag,
153: attribute_values_id,

Line 819: UPDATE po_attribute_values_draft

815: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
816: END IF;
817:
818: FORALL i IN 1..p_attribute_values_id_tbl.COUNT
819: UPDATE po_attribute_values_draft
820: SET delete_flag = p_delete_flag_tbl(i)
821: WHERE attribute_values_id = p_attribute_values_id_tbl(i)
822: AND draft_id = p_draft_id_tbl(i)
823: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 969: FROM po_attribute_values_draft PAVD

965:
966: DELETE FROM po_attribute_values PAV
967: WHERE PAV.attribute_values_id IN
968: ( SELECT PAVD.attribute_values_id
969: FROM po_attribute_values_draft PAVD
970: WHERE PAVD.draft_id = p_draft_id
971: AND PAVD.delete_flag = 'Y'
972: AND NVL(PAVD.change_accepted_flag, 'Y') = 'Y');
973:

Line 1309: FROM po_attribute_values_draft PAVD

1305: PAVD.request_id,
1306: PAVD.program_application_id,
1307: PAVD.program_id,
1308: PAVD.program_update_date
1309: FROM po_attribute_values_draft PAVD
1310: WHERE PAVD.draft_id = p_draft_id
1311: AND NVL(PAVD.change_accepted_flag, 'Y') = 'Y') PAVDV
1312: ON (PAV.attribute_values_id = PAVDV.attribute_values_id)
1313: WHEN MATCHED THEN

Line 2344: FROM po_attribute_values_draft

2340: END IF;
2341:
2342: SELECT 1
2343: INTO l_dummy
2344: FROM po_attribute_values_draft
2345: WHERE attribute_values_id = p_attribute_values_id
2346: AND draft_id = p_draft_id
2347: FOR UPDATE NOWAIT;
2348: