APPS.PA_PURGE_PJR_TXNS dependencies on PA_ACTION_SET_LINE_AUD

Line 2898: -- PA_ACTION_SET_LINE_AUD

2894: -- Function : Main purge procedure for Purging records from Advertisements related tables:
2895: -- PA_ACTION_SETS,
2896: -- PA_ACTION_SET_LINES,
2897: -- PA_ACTION_SET_LINE_COND
2898: -- PA_ACTION_SET_LINE_AUD
2899:
2900:
2901: Procedure PA_ADVERTISEMENTS_PURGE ( p_purge_batch_id in NUMBER,
2902: p_project_id in NUMBER,

Line 3264: From PA_ACTION_SET_LINE_AUD WHERE action_set_line_ID IN (SELECT action_set_line_id From pa_action_set_lines

3260: Request_Id,
3261: Program_Application_Id,
3262: Program_Id,
3263: Program_Update_Date
3264: From PA_ACTION_SET_LINE_AUD WHERE action_set_line_ID IN (SELECT action_set_line_id From pa_action_set_lines
3265: WHERE action_set_id=l_action_set_id);
3266:
3267:
3268: /*Increase the value of l_nos_lines_aud_inserted to indicate number of records inserted in action_set_lines_aud_ar

Line 3281: DELETE PA_ACTION_SET_LINE_AUD

3277:
3278: pa_debug.debug('Deleting Records from pa_action_set_lines_aud table ') ;
3279: x_err_stage := 'Deleting Records from pa_action_set_lines_aud for id for lines of action set id'||to_char(l_action_set_id) ;
3280:
3281: DELETE PA_ACTION_SET_LINE_AUD
3282: WHERE action_set_line_ID IN (SELECT action_set_line_id From pa_action_set_lines
3283: WHERE action_set_id=l_action_set_id);
3284:
3285: l_nos_lines_aud_deleted := l_nos_lines_aud_deleted + SQL%ROWCOUNT;

Line 3353: 'PA_ACTION_SET_LINE_AUD',

3349:
3350: pa_purge.CommitProcess(p_purge_batch_id,
3351: p_project_id,
3352: /* 'PA_ACTN_SETLN_AUD_AR', bug 2480653 */
3353: 'PA_ACTION_SET_LINE_AUD',
3354: l_nos_lines_aud_inserted,
3355: l_nos_lines_aud_deleted,
3356: x_err_code,
3357: x_err_stack,