APPS.PO_ATTR_VALUES_TLP_DRAFT_PKG dependencies on PO_ATTRIBUTE_VALUES_TLP

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 78: -- table of po attribute values tlp unique identifier

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

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 504: FROM po_attribute_values_tlp

500: request_id,
501: program_application_id,
502: program_id,
503: program_update_date
504: FROM po_attribute_values_tlp
505: WHERE attribute_values_tlp_id = p_attribute_values_tlp_id_tbl(i)
506: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
507: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
508:

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 666: DELETE FROM po_attribute_values_tlp PAVT

662:
663: -- bug5187544
664: -- Delete only records that have not been rejected
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

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 679: MERGE INTO po_attribute_values_tlp PAVT

675: -- PAVT.attribute_values_tlp_id = PAVTDV.attribute_values_tlp_id,
676: -- PAVT.created_by = PAVTDV.created_by,
677: -- PAVT.creation_date = PAVTDV.creation_date,
678:
679: MERGE INTO po_attribute_values_tlp PAVT
680: USING (
681: SELECT
682: PAVTD.draft_id,
683: PAVTD.delete_flag,

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:

Line 1476: FROM po_attribute_values_tlp

1472: END IF;
1473:
1474: SELECT 1
1475: INTO l_dummy
1476: FROM po_attribute_values_tlp
1477: WHERE attribute_values_tlp_id = p_attribute_values_tlp_id
1478: FOR UPDATE NOWAIT;
1479:
1480: IF (PO_LOG.d_proc) THEN