DBA Data[Home] [Help]

APPS.PO_DRAFTS_PVT dependencies on PO_PRICE_DIFF_DRAFT

Line 654: PO_PRICE_DIFF_DRAFT_PKG.delete_rows

650: p_org_assignment_id => NULL
651: );
652:
653: d_position := 50;
654: PO_PRICE_DIFF_DRAFT_PKG.delete_rows
655: ( p_draft_id => p_draft_id,
656: p_price_differential_id => NULL
657: );
658:

Line 860: PO_PRICE_DIFF_DRAFT_PVT.draft_changes_exist

856:
857: d_position := 90;
858: -- check if price differentials gets changed
859: x_draft_info.price_diff_changed :=
860: PO_PRICE_DIFF_DRAFT_PVT.draft_changes_exist
861: ( p_draft_id => p_draft_id,
862: p_price_differential_id => NULL
863: );
864:

Line 2371: PO_PRICE_DIFF_DRAFT_PVT.draft_changes_exist

2367:
2368: d_position := 60;
2369: -- check if price differentials gets changed
2370: l_chg_exist_tbl :=
2371: PO_PRICE_DIFF_DRAFT_PVT.draft_changes_exist
2372: ( p_draft_id_tbl => p_draft_id_tbl,
2373: p_price_differential_id_tbl => l_null_id_tbl
2374: );
2375:

Line 2609: PO_PRICE_DIFF_DRAFT_PKG.lock_draft_record

2605:
2606: ELSIF (p_view_name = 'PO_PRICE_DIFF_MERGE_V') THEN
2607: d_position := 60;
2608:
2609: PO_PRICE_DIFF_DRAFT_PKG.lock_draft_record
2610: ( p_price_differential_id => p_entity_id,
2611: p_draft_id => p_draft_id
2612: );
2613:

Line 2614: PO_PRICE_DIFF_DRAFT_PKG.lock_transaction_record

2610: ( p_price_differential_id => p_entity_id,
2611: p_draft_id => p_draft_id
2612: );
2613:
2614: PO_PRICE_DIFF_DRAFT_PKG.lock_transaction_record
2615: ( p_price_differential_id => p_entity_id
2616: );
2617:
2618: ELSIF (p_view_name = 'PO_NOTIFICATION_CTRL_MERGE_V') THEN

Line 3404: PO_PRICE_DIFF_DRAFT_PVT.apply_changes

3400: (p_draft_info => p_draft_info
3401: );
3402:
3403: d_position := 50;
3404: PO_PRICE_DIFF_DRAFT_PVT.apply_changes
3405: (p_draft_info => p_draft_info
3406: );
3407:
3408: d_position := 60;

Line 3810: UPDATE po_price_diff_draft

3806: WHERE draft_id = p_draft_id
3807: AND change_accepted_flag IS NULL;
3808:
3809: d_position := 80;
3810: UPDATE po_price_diff_draft
3811: SET change_accepted_flag = l_change_accepted_flag
3812: WHERE draft_id = p_draft_id
3813: AND change_accepted_flag IS NULL;
3814:

Line 4959: FROM po_price_diff_draft ppdr,

4955: NVL(ppdr.min_multiplier ,G_NULL_NUM),
4956: NVL(ppdr.max_multiplier ,G_NULL_NUM)
4957: ) p_lock_attrs,
4958: ppdr.price_differential_id
4959: FROM po_price_diff_draft ppdr,
4960: po_session_gt pogt
4961: WHERE ppdr.draft_id = p_draft_id
4962: AND ppdr.entity_id = pogt.char1 -- po_header_id
4963: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID