DBA Data[Home] [Help]

APPS.PO_DRAFTS_PVT dependencies on PO_GA_ORG_ASSIGN_DRAFT

Line 648: PO_GA_ORG_ASSIGN_DRAFT_PKG.delete_rows

644: p_po_distribution_id => NULL
645: );
646:
647: d_position := 40;
648: PO_GA_ORG_ASSIGN_DRAFT_PKG.delete_rows
649: ( p_draft_id => p_draft_id,
650: p_org_assignment_id => NULL
651: );
652:

Line 852: PO_GA_ORG_ASSIGN_DRAFT_PVT.draft_changes_exist

848:
849: d_position := 80;
850: -- check if any org assignment gets changed
851: x_draft_info.ga_org_assign_changed :=
852: PO_GA_ORG_ASSIGN_DRAFT_PVT.draft_changes_exist
853: ( p_draft_id => p_draft_id,
854: p_org_assignment_id => NULL
855: );
856:

Line 2357: PO_GA_ORG_ASSIGN_DRAFT_PVT.draft_changes_exist

2353:
2354: d_position := 50;
2355: -- check if any org assignment gets changed
2356: l_chg_exist_tbl :=
2357: PO_GA_ORG_ASSIGN_DRAFT_PVT.draft_changes_exist
2358: ( p_draft_id_tbl => p_draft_id_tbl,
2359: p_org_assignment_id_tbl => l_null_id_tbl
2360: );
2361:

Line 2597: PO_GA_ORG_ASSIGN_DRAFT_PKG.lock_draft_record

2593:
2594: ELSIF (p_view_name = 'PO_GA_ORG_ASSIGN_MERGE_V') THEN
2595: d_position := 50;
2596:
2597: PO_GA_ORG_ASSIGN_DRAFT_PKG.lock_draft_record
2598: ( p_org_assignment_id => p_entity_id,
2599: p_draft_id => p_draft_id
2600: );
2601:

Line 2602: PO_GA_ORG_ASSIGN_DRAFT_PKG.lock_transaction_record

2598: ( p_org_assignment_id => p_entity_id,
2599: p_draft_id => p_draft_id
2600: );
2601:
2602: PO_GA_ORG_ASSIGN_DRAFT_PKG.lock_transaction_record
2603: ( p_org_assignment_id => p_entity_id
2604: );
2605:
2606: ELSIF (p_view_name = 'PO_PRICE_DIFF_MERGE_V') THEN

Line 3399: PO_GA_ORG_ASSIGN_DRAFT_PVT.apply_changes

3395: (p_draft_info => p_draft_info
3396: );
3397:
3398: d_position := 40;
3399: PO_GA_ORG_ASSIGN_DRAFT_PVT.apply_changes
3400: (p_draft_info => p_draft_info
3401: );
3402:
3403: d_position := 50;

Line 3804: UPDATE po_ga_org_assign_draft

3800: WHERE draft_id = p_draft_id
3801: AND change_accepted_flag IS NULL;
3802:
3803: d_position := 70;
3804: UPDATE po_ga_org_assign_draft
3805: SET change_accepted_flag = l_change_accepted_flag
3806: WHERE draft_id = p_draft_id
3807: AND change_accepted_flag IS NULL;
3808:

Line 4397: FROM po_ga_org_assign_draft pgoad,

4393: NVL(pgoad.purchasing_org_id ,G_NULL_NUM),
4394: NVL(pgoad.vendor_site_id ,G_NULL_NUM)
4395: ) P_LOCK_ATTRS,
4396: pgoad.org_assignment_id
4397: FROM po_ga_org_assign_draft pgoad,
4398: po_session_gt pogt
4399: WHERE pgoad.draft_id = p_draft_id
4400: AND pgoad.po_header_id = pogt.char1 -- po_header_id
4401: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID