eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PURGE_PJR_TXNS dependencies on PA_ACTION_SET_LINES

Line 2896: -- PA_ACTION_SET_LINES,

2892: -- Type : Public
2893: -- Pre-reqs : None
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:

Line 3083: pa_debug.debug('Inserting Records into pa_action_set_lines_AR table ') ;

3079: The value will increase for each loop*/
3080:
3081: l_nos_action_sets_inserted := l_nos_action_sets_inserted + SQL%ROWCOUNT;
3082:
3083: pa_debug.debug('Inserting Records into pa_action_set_lines_AR table ') ;
3084: x_err_stage := 'Inserting Records into pa_action_setl_lines_AR table for action set id '||to_char(l_action_set_id) ;
3085:
3086:
3087: INSERT INTO PA_ACTION_SET_LINES_AR

Line 3087: INSERT INTO PA_ACTION_SET_LINES_AR

3083: pa_debug.debug('Inserting Records into pa_action_set_lines_AR table ') ;
3084: x_err_stage := 'Inserting Records into pa_action_setl_lines_AR table for action set id '||to_char(l_action_set_id) ;
3085:
3086:
3087: INSERT INTO PA_ACTION_SET_LINES_AR
3088: ( PURGE_BATCH_ID,
3089: PURGE_RELEASE,
3090: PURGE_PROJECT_ID,
3091: ACTION_SET_LINE_ID,

Line 3141: FROM Pa_Action_Set_Lines WHERE action_set_id=l_action_set_id;

3137: Created_By,
3138: Last_Update_Date,
3139: Last_Updated_By,
3140: Last_Update_Login
3141: FROM Pa_Action_Set_Lines WHERE action_set_id=l_action_set_id;
3142:
3143: /*Increase the value of l_nos_set_lines_inserted to indicate number of records inserted in action_set_lines_ar table.
3144: The value will increase for each loop*/
3145:

Line 3200: From pa_action_set_lines where action_set_id=l_action_set_id);

3196: Last_Update_Date,
3197: Last_Updated_By,
3198: Last_Update_Login
3199: FROM PA_ACTION_SET_LINE_COND WHERE action_set_line_id IN (SELECT action_set_line_id
3200: From pa_action_set_lines where action_set_id=l_action_set_id);
3201:
3202: /*Increase the value of l_l_nos_lines_cond_inserted to indicate number of records inserted in action_set_lines_acond_ar table.
3203: The value will increase for each loop*/
3204:

Line 3207: pa_debug.debug('Inserting Records into pa_action_set_lines_audit table ') ;

3203: The value will increase for each loop*/
3204:
3205: l_nos_lines_cond_inserted := l_nos_lines_cond_inserted + SQL%ROWCOUNT;
3206:
3207: pa_debug.debug('Inserting Records into pa_action_set_lines_audit table ') ;
3208: x_err_stage := 'Inserting Records into pa_action_set_lines_audit table for lines of action set id '||to_char(l_action_set_id) ;
3209:
3210: INSERT INTO PA_ACTN_SETLN_AUD_AR
3211: ( PURGE_BATCH_ID,

Line 3208: x_err_stage := 'Inserting Records into pa_action_set_lines_audit table for lines of action set id '||to_char(l_action_set_id) ;

3204:
3205: l_nos_lines_cond_inserted := l_nos_lines_cond_inserted + SQL%ROWCOUNT;
3206:
3207: pa_debug.debug('Inserting Records into pa_action_set_lines_audit table ') ;
3208: x_err_stage := 'Inserting Records into pa_action_set_lines_audit table for lines of action set id '||to_char(l_action_set_id) ;
3209:
3210: INSERT INTO PA_ACTN_SETLN_AUD_AR
3211: ( PURGE_BATCH_ID,
3212: PURGE_RELEASE,

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 3278: pa_debug.debug('Deleting Records from pa_action_set_lines_aud table ') ;

3274:
3275: /*To keep the count of no of records deleted from adcertisement related tables, manipulate the
3276: count of variables: */
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

Line 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) ;

3275: /*To keep the count of no of records deleted from adcertisement related tables, manipulate the
3276: count of variables: */
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);

Line 3282: WHERE action_set_line_ID IN (SELECT action_set_line_id From pa_action_set_lines

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;
3286:

Line 3291: WHERE action_set_line_ID IN (SELECT action_set_line_id From pa_action_set_lines

3287: pa_debug.debug('Deleting Records from PA_ACTION_SET_LINE_COND table ') ;
3288: x_err_stage := 'Deleting Records from PA_ACTION_SET_LINE_COND for id for lines of action set id'||to_char(l_action_set_id) ;
3289:
3290: DELETE PA_ACTION_SET_LINE_COND
3291: WHERE action_set_line_ID IN (SELECT action_set_line_id From pa_action_set_lines
3292: WHERE action_set_id=l_action_set_id);
3293:
3294: l_nos_lines_cond_deleted := l_nos_lines_cond_deleted + SQL%ROWCOUNT;
3295:

Line 3296: pa_debug.debug('Deleting Records from PA_ACTION_SET_LINES table ') ;

3292: WHERE action_set_id=l_action_set_id);
3293:
3294: l_nos_lines_cond_deleted := l_nos_lines_cond_deleted + SQL%ROWCOUNT;
3295:
3296: pa_debug.debug('Deleting Records from PA_ACTION_SET_LINES table ') ;
3297: x_err_stage := 'Deleting Records from PA_ACTION_SET_LINES for id for lines of action set id'||to_char(l_action_set_id) ;
3298:
3299: DELETE PA_ACTION_SET_LINES
3300: WHERE action_set_id=l_action_set_id;

Line 3297: x_err_stage := 'Deleting Records from PA_ACTION_SET_LINES for id for lines of action set id'||to_char(l_action_set_id) ;

3293:
3294: l_nos_lines_cond_deleted := l_nos_lines_cond_deleted + SQL%ROWCOUNT;
3295:
3296: pa_debug.debug('Deleting Records from PA_ACTION_SET_LINES table ') ;
3297: x_err_stage := 'Deleting Records from PA_ACTION_SET_LINES for id for lines of action set id'||to_char(l_action_set_id) ;
3298:
3299: DELETE PA_ACTION_SET_LINES
3300: WHERE action_set_id=l_action_set_id;
3301:

Line 3299: DELETE PA_ACTION_SET_LINES

3295:
3296: pa_debug.debug('Deleting Records from PA_ACTION_SET_LINES table ') ;
3297: x_err_stage := 'Deleting Records from PA_ACTION_SET_LINES for id for lines of action set id'||to_char(l_action_set_id) ;
3298:
3299: DELETE PA_ACTION_SET_LINES
3300: WHERE action_set_id=l_action_set_id;
3301:
3302: l_nos_set_lines_deleted := l_nos_set_lines_deleted + SQL%ROWCOUNT;
3303:

Line 3331: 'PA_ACTION_SET_LINES',

3327: ) ;
3328:
3329: pa_purge.CommitProcess(p_purge_batch_id,
3330: p_project_id,
3331: 'PA_ACTION_SET_LINES',
3332: l_nos_set_lines_inserted,
3333: l_nos_set_lines_deleted,
3334: x_err_code,
3335: x_err_stack,