[Home] [Help]
336: p_org_assignment_id => NULL
337: );
338:
339: d_position := 50;
340: PO_PRICE_DIFF_DRAFT_PKG.delete_rows
341: ( p_draft_id => p_draft_id,
342: p_price_differential_id => NULL
343: );
344:
521:
522: d_position := 90;
523: -- check if price differentials gets changed
524: x_draft_info.price_diff_changed :=
525: PO_PRICE_DIFF_DRAFT_PVT.draft_changes_exist
526: ( p_draft_id => p_draft_id,
527: p_price_differential_id => NULL
528: );
529:
1944:
1945: d_position := 60;
1946: -- check if price differentials gets changed
1947: l_chg_exist_tbl :=
1948: PO_PRICE_DIFF_DRAFT_PVT.draft_changes_exist
1949: ( p_draft_id_tbl => p_draft_id_tbl,
1950: p_price_differential_id_tbl => l_null_id_tbl
1951: );
1952:
2166:
2167: ELSIF (p_view_name = 'PO_PRICE_DIFF_MERGE_V') THEN
2168: d_position := 60;
2169:
2170: PO_PRICE_DIFF_DRAFT_PKG.lock_draft_record
2171: ( p_price_differential_id => p_entity_id,
2172: p_draft_id => p_draft_id
2173: );
2174:
2171: ( p_price_differential_id => p_entity_id,
2172: p_draft_id => p_draft_id
2173: );
2174:
2175: PO_PRICE_DIFF_DRAFT_PKG.lock_transaction_record
2176: ( p_price_differential_id => p_entity_id
2177: );
2178:
2179: ELSIF (p_view_name = 'PO_NOTIFICATION_CTRL_MERGE_V') THEN
2904: (p_draft_info => p_draft_info
2905: );
2906:
2907: d_position := 50;
2908: PO_PRICE_DIFF_DRAFT_PVT.apply_changes
2909: (p_draft_info => p_draft_info
2910: );
2911:
2912: d_position := 60;
3250: WHERE draft_id = p_draft_id
3251: AND change_accepted_flag IS NULL;
3252:
3253: d_position := 80;
3254: UPDATE po_price_diff_draft
3255: SET change_accepted_flag = l_change_accepted_flag
3256: WHERE draft_id = p_draft_id
3257: AND change_accepted_flag IS NULL;
3258: