[Home] [Help]
342: p_price_differential_id => NULL
343: );
344:
345: d_position := 60;
346: PO_NOTIFICATION_CTRL_DRAFT_PKG.delete_rows
347: ( p_draft_id => p_draft_id,
348: p_notification_id => NULL
349: );
350:
529:
530: d_position := 100;
531: -- check if any notification control gets changed
532: x_draft_info.notification_ctrl_changed :=
533: PO_NOTIFICATION_CTRL_DRAFT_PVT.draft_changes_exist
534: ( p_draft_id => p_draft_id,
535: p_notification_id => NULL
536: );
537:
1958:
1959: d_position := 70;
1960: -- check if any notification control gets changed
1961: l_chg_exist_tbl :=
1962: PO_NOTIFICATION_CTRL_DRAFT_PVT.draft_changes_exist
1963: ( p_draft_id_tbl => p_draft_id_tbl,
1964: p_notification_id_tbl => l_null_id_tbl
1965: );
1966:
2178:
2179: ELSIF (p_view_name = 'PO_NOTIFICATION_CTRL_MERGE_V') THEN
2180: d_position := 70;
2181:
2182: PO_NOTIFICATION_CTRL_DRAFT_PKG.lock_draft_record
2183: ( p_notification_id => p_entity_id,
2184: p_draft_id => p_draft_id
2185: );
2186:
2183: ( p_notification_id => p_entity_id,
2184: p_draft_id => p_draft_id
2185: );
2186:
2187: PO_NOTIFICATION_CTRL_DRAFT_PKG.lock_transaction_record
2188: ( p_notification_id => p_entity_id
2189: );
2190:
2191: ELSIF (p_view_name = 'PO_ATTR_VALUES_MERGE_V') THEN
2909: (p_draft_info => p_draft_info
2910: );
2911:
2912: d_position := 60;
2913: PO_NOTIFICATION_CTRL_DRAFT_PVT.apply_changes
2914: (p_draft_info => p_draft_info
2915: );
2916:
2917: d_position := 70;
3256: WHERE draft_id = p_draft_id
3257: AND change_accepted_flag IS NULL;
3258:
3259: d_position := 90;
3260: UPDATE po_notification_ctrl_draft
3261: SET change_accepted_flag = l_change_accepted_flag
3262: WHERE draft_id = p_draft_id
3263: AND change_accepted_flag IS NULL;
3264: