DBA Data[Home] [Help]

APPS.PO_AP_PURGE_UTIL_PVT dependencies on PO_DRAFTS

Line 112: PROCEDURE delete_po_drafts

108: p_range_low IN NUMBER,
109: p_range_high IN NUMBER
110: );
111:
112: PROCEDURE delete_po_drafts
113: ( x_return_status OUT NOCOPY VARCHAR2,
114: p_range_low IN NUMBER,
115: p_range_high IN NUMBER
116: );

Line 927: delete_po_drafts

923: l_progress := '120';
924:
925: --
926: -- Delete Draft documents when we purge pos
927: delete_po_drafts
928: ( x_return_status => l_return_status,
929: p_range_low => p_range_low,
930: p_range_high => p_range_high
931: );

Line 3291: --Name: delete_po_drafts

3287: --
3288:
3289: -----------------------------------------------------------------------
3290: --Start of Comments
3291: --Name: delete_po_drafts
3292: --Pre-reqs:
3293: --Modifies:
3294: --
3295: --Locks:

Line 3314: PROCEDURE delete_po_drafts

3310: --Testing:
3311: --End of Comments
3312: ------------------------------------------------------------------------
3313:
3314: PROCEDURE delete_po_drafts
3315: ( x_return_status OUT NOCOPY VARCHAR2,
3316: p_range_low IN NUMBER,
3317: p_range_high IN NUMBER
3318: ) IS

Line 3346: FROM po_drafts DFT,

3342:
3343: SELECT DFT.draft_id
3344: BULK COLLECT
3345: INTO l_dft_id_tbl
3346: FROM po_drafts DFT,
3347: po_purge_po_list PPL
3348: WHERE DFT.document_id = PPL.po_header_id
3349: AND PPL.po_header_id BETWEEN p_range_low AND p_range_high
3350: AND PPL.double_check_flag = 'Y';

Line 3354: PO_DRAFTS_PVT.remove_draft_changes

3350: AND PPL.double_check_flag = 'Y';
3351:
3352: -- Delete all drafts for documents in purge list
3353: FOR i IN 1..l_dft_id_tbl.COUNT LOOP
3354: PO_DRAFTS_PVT.remove_draft_changes
3355: ( p_draft_id => l_dft_id_tbl(i),
3356: p_exclude_ctrl_tbl => FND_API.G_FALSE,
3357: x_return_status => x_return_status
3358: );

Line 3380: END delete_po_drafts;

3376: ( p_pkg_name => g_pkg_name,
3377: p_procedure_name => l_api_name || '.' || l_progress
3378: );
3379:
3380: END delete_po_drafts;
3381:
3382: --
3383:
3384: --