74: -- the draft record according to the parameter.
75: --Parameters:
76: --IN:
77: --p_price_differential_id_tbl
78: -- table of po price differentials 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
186: created_by,
187: last_update_date,
188: last_updated_by,
189: last_update_login
190: FROM po_price_differentials
191: WHERE price_differential_id = p_price_differential_id_tbl(i)
192: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
193: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
194:
346:
347: -- bug5187544
348: -- Delete only records that have not been rejected
349:
350: DELETE FROM po_price_differentials PPD
351: WHERE PPD.price_differential_id IN
352: ( SELECT PPDD.price_differential_id
353: FROM po_price_diff_draft PPDD
354: WHERE PPDD.draft_id = p_draft_id
363: --PPD.entity_id
364: --PPD.entity_type
365: --PPD.creation_date
366: --PPD.created_by
367: MERGE INTO po_price_differentials PPD
368: USING (
369: SELECT
370: PPDD.draft_id,
371: PPDD.delete_flag,
524: END IF;
525:
526: SELECT 1
527: INTO l_dummy
528: FROM po_price_differentials
529: WHERE price_differential_id = p_price_differential_id
530: FOR UPDATE NOWAIT;
531:
532: IF (PO_LOG.d_proc) THEN