APPS.PO_ATTR_VALUES_DRAFT_PKG dependencies on PO_ATTRIBUTE_VALUES

Line 25: -- po attribute values unique identifier

21: --IN:
22: --p_draft_id
23: -- draft unique identifier
24: --p_attribute_values_id
25: -- po attribute values unique identifier
26: --IN OUT:
27: --OUT:
28: --Returns:
29: --Notes:

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 76: -- table of po attribute_values unique identifier

72: -- the draft record according to the parameter.
73: --Parameters:
74: --IN:
75: --p_attribute_values_id_tbl
76: -- table of po attribute_values unique identifier
77: --p_draft_id_tbl
78: -- table of draft ids this sync up will be done for
79: --p_delete_flag_tbl
80: -- table fo flags to indicate whether the draft record should be maked as

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 808: FROM po_attribute_values

804: request_id,
805: program_application_id,
806: program_id,
807: program_update_date
808: FROM po_attribute_values
809: WHERE attribute_values_id = p_attribute_values_id_tbl(i)
810: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
811: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
812:

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 966: DELETE FROM po_attribute_values PAV

962:
963: -- bug5187544
964: -- Delete only records that have not been rejected
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

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 978: MERGE INTO po_attribute_values PAV

974: -- During Update case, the following attributes will be skipped:
975: -- PAV.attribute_values_id = PAVDV.attribute_values_id,
976: -- PAV.created_by = PAVDV.created_by,
977: -- PAV.creation_date = PAVDV.creation_date,
978: MERGE INTO po_attribute_values PAV
979: USING (
980: SELECT
981: PAVD.draft_id,
982: PAVD.change_accepted_flag,

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 2319: -- id for po attribute values record

2315: -- Obtain database lock for the record in draft table
2316: --Parameters:
2317: --IN:
2318: --p_attribute_values_id
2319: -- id for po attribute values record
2320: --p_draft_id
2321: -- draft unique identifier
2322: --RETURN:
2323: --End of Comments

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:

Line 2388: FROM po_attribute_values

2384: END IF;
2385:
2386: SELECT 1
2387: INTO l_dummy
2388: FROM po_attribute_values
2389: WHERE attribute_values_id = p_attribute_values_id
2390: FOR UPDATE NOWAIT;
2391:
2392: IF (PO_LOG.d_proc) THEN