APPS.PO_DRAFTS_PVT dependencies on PO_NOTIFICATION_CTRL_DRAFT

Line 660: PO_NOTIFICATION_CTRL_DRAFT_PKG.delete_rows

656: p_price_differential_id => NULL
657: );
658:
659: d_position := 60;
660: PO_NOTIFICATION_CTRL_DRAFT_PKG.delete_rows
661: ( p_draft_id => p_draft_id,
662: p_notification_id => NULL
663: );
664:

Line 868: PO_NOTIFICATION_CTRL_DRAFT_PVT.draft_changes_exist

864:
865: d_position := 100;
866: -- check if any notification control gets changed
867: x_draft_info.notification_ctrl_changed :=
868: PO_NOTIFICATION_CTRL_DRAFT_PVT.draft_changes_exist
869: ( p_draft_id => p_draft_id,
870: p_notification_id => NULL
871: );
872:

Line 2385: PO_NOTIFICATION_CTRL_DRAFT_PVT.draft_changes_exist

2381:
2382: d_position := 70;
2383: -- check if any notification control gets changed
2384: l_chg_exist_tbl :=
2385: PO_NOTIFICATION_CTRL_DRAFT_PVT.draft_changes_exist
2386: ( p_draft_id_tbl => p_draft_id_tbl,
2387: p_notification_id_tbl => l_null_id_tbl
2388: );
2389:

Line 2621: PO_NOTIFICATION_CTRL_DRAFT_PKG.lock_draft_record

2617:
2618: ELSIF (p_view_name = 'PO_NOTIFICATION_CTRL_MERGE_V') THEN
2619: d_position := 70;
2620:
2621: PO_NOTIFICATION_CTRL_DRAFT_PKG.lock_draft_record
2622: ( p_notification_id => p_entity_id,
2623: p_draft_id => p_draft_id
2624: );
2625:

Line 2626: PO_NOTIFICATION_CTRL_DRAFT_PKG.lock_transaction_record

2622: ( p_notification_id => p_entity_id,
2623: p_draft_id => p_draft_id
2624: );
2625:
2626: PO_NOTIFICATION_CTRL_DRAFT_PKG.lock_transaction_record
2627: ( p_notification_id => p_entity_id
2628: );
2629:
2630: ELSIF (p_view_name = 'PO_ATTR_VALUES_MERGE_V') THEN

Line 3409: PO_NOTIFICATION_CTRL_DRAFT_PVT.apply_changes

3405: (p_draft_info => p_draft_info
3406: );
3407:
3408: d_position := 60;
3409: PO_NOTIFICATION_CTRL_DRAFT_PVT.apply_changes
3410: (p_draft_info => p_draft_info
3411: );
3412:
3413: d_position := 70;

Line 3816: UPDATE po_notification_ctrl_draft

3812: WHERE draft_id = p_draft_id
3813: AND change_accepted_flag IS NULL;
3814:
3815: d_position := 90;
3816: UPDATE po_notification_ctrl_draft
3817: SET change_accepted_flag = l_change_accepted_flag
3818: WHERE draft_id = p_draft_id
3819: AND change_accepted_flag IS NULL;
3820:

Line 4457: FROM po_notification_ctrl_draft pncd,

4453: NVL(pncd.start_date_active ,G_NULL_DATE),
4454: NVL(pncd.end_date_active ,G_NULL_DATE)
4455: ) p_lock_attrs,
4456: pncd.notification_id
4457: FROM po_notification_ctrl_draft pncd,
4458: po_session_gt pogt
4459: WHERE pncd.draft_id = p_draft_id
4460: AND pncd.po_header_id = pogt.char1 -- po_header_id
4461: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID