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_LINE_COND

Line 2897: -- PA_ACTION_SET_LINE_COND

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:
2901: Procedure PA_ADVERTISEMENTS_PURGE ( p_purge_batch_id in NUMBER,

Line 3148: pa_debug.debug('Inserting Records into pa_action_set_line_cond_AR table ') ;

3144: The value will increase for each loop*/
3145:
3146: l_nos_set_lines_inserted := l_nos_set_lines_inserted + SQL%ROWCOUNT;
3147:
3148: pa_debug.debug('Inserting Records into pa_action_set_line_cond_AR table ') ;
3149: x_err_stage := 'Inserting Records into pa_action_set_line__cond_AR table for lines of action set id '||to_char(l_action_set_id) ;
3150:
3151: INSERT INTO PA_ACTN_SET_LN_COND_AR
3152: ( PURGE_BATCH_ID,

Line 3199: FROM PA_ACTION_SET_LINE_COND WHERE action_set_line_id IN (SELECT action_set_line_id

3195: Created_By,
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*/

Line 3287: pa_debug.debug('Deleting Records from PA_ACTION_SET_LINE_COND table ') ;

3283: WHERE action_set_id=l_action_set_id);
3284:
3285: l_nos_lines_aud_deleted := l_nos_lines_aud_deleted + SQL%ROWCOUNT;
3286:
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

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

3284:
3285: l_nos_lines_aud_deleted := l_nos_lines_aud_deleted + SQL%ROWCOUNT;
3286:
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);

Line 3290: DELETE PA_ACTION_SET_LINE_COND

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

Line 3342: 'PA_ACTION_SET_LINE_COND',

3338:
3339: pa_purge.CommitProcess(p_purge_batch_id,
3340: p_project_id,
3341: /* 'PA_ACTN_SET_LN_COND_AR', bug 2480653 */
3342: 'PA_ACTION_SET_LINE_COND',
3343: l_nos_lines_cond_inserted,
3344: l_nos_lines_cond_deleted,
3345: x_err_code,
3346: x_err_stack,