[Home] [Help]
330: p_po_distribution_id => NULL
331: );
332:
333: d_position := 40;
334: PO_GA_ORG_ASSIGN_DRAFT_PKG.delete_rows
335: ( p_draft_id => p_draft_id,
336: p_org_assignment_id => NULL
337: );
338:
513:
514: d_position := 80;
515: -- check if any org assignment gets changed
516: x_draft_info.ga_org_assign_changed :=
517: PO_GA_ORG_ASSIGN_DRAFT_PVT.draft_changes_exist
518: ( p_draft_id => p_draft_id,
519: p_org_assignment_id => NULL
520: );
521:
1930:
1931: d_position := 50;
1932: -- check if any org assignment gets changed
1933: l_chg_exist_tbl :=
1934: PO_GA_ORG_ASSIGN_DRAFT_PVT.draft_changes_exist
1935: ( p_draft_id_tbl => p_draft_id_tbl,
1936: p_org_assignment_id_tbl => l_null_id_tbl
1937: );
1938:
2154:
2155: ELSIF (p_view_name = 'PO_GA_ORG_ASSIGN_MERGE_V') THEN
2156: d_position := 50;
2157:
2158: PO_GA_ORG_ASSIGN_DRAFT_PKG.lock_draft_record
2159: ( p_org_assignment_id => p_entity_id,
2160: p_draft_id => p_draft_id
2161: );
2162:
2159: ( p_org_assignment_id => p_entity_id,
2160: p_draft_id => p_draft_id
2161: );
2162:
2163: PO_GA_ORG_ASSIGN_DRAFT_PKG.lock_transaction_record
2164: ( p_org_assignment_id => p_entity_id
2165: );
2166:
2167: ELSIF (p_view_name = 'PO_PRICE_DIFF_MERGE_V') THEN
2899: (p_draft_info => p_draft_info
2900: );
2901:
2902: d_position := 40;
2903: PO_GA_ORG_ASSIGN_DRAFT_PVT.apply_changes
2904: (p_draft_info => p_draft_info
2905: );
2906:
2907: d_position := 50;
3244: WHERE draft_id = p_draft_id
3245: AND change_accepted_flag IS NULL;
3246:
3247: d_position := 70;
3248: UPDATE po_ga_org_assign_draft
3249: SET change_accepted_flag = l_change_accepted_flag
3250: WHERE draft_id = p_draft_id
3251: AND change_accepted_flag IS NULL;
3252: