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_ASSIGNMENTS_HISTORY

Line 2682: From pa_assignments_history where assignment_id=l_assignment_id;

2678: Transfer_price_rate, -- Added for bug 3051110
2679: Transfer_pr_rate_curr,
2680: discount_percentage, -- Added for bug 3041583
2681: rate_disc_reason_code -- Added for bug 3041583
2682: From pa_assignments_history where assignment_id=l_assignment_id;
2683:
2684: /*Increase the value of l_assignments_his_inserted to indicate number of records inserted in assignments_history_ar
2685: table. The value will increase for each loop*/
2686:

Line 2691: /*To keep the count of no of records deleted from pa_project_assignments and pa_assignments_history, manipulate the

2687: l_nos_assignments_his_inserted := l_nos_assignments_his_inserted + SQL%ROWCOUNT;
2688:
2689: END IF;
2690:
2691: /*To keep the count of no of records deleted from pa_project_assignments and pa_assignments_history, manipulate the
2692: count of l_nos_assignments_deleted and l_nos_assignments_his_deleted. */
2693:
2694: pa_debug.debug('Deleting Records from pa_assignments_history table ') ;
2695: x_err_stage := 'Deleting Records from pa_assignments_history table for id '||to_char(l_assignment_id) ;

Line 2694: pa_debug.debug('Deleting Records from pa_assignments_history table ') ;

2690:
2691: /*To keep the count of no of records deleted from pa_project_assignments and pa_assignments_history, manipulate the
2692: count of l_nos_assignments_deleted and l_nos_assignments_his_deleted. */
2693:
2694: pa_debug.debug('Deleting Records from pa_assignments_history table ') ;
2695: x_err_stage := 'Deleting Records from pa_assignments_history table for id '||to_char(l_assignment_id) ;
2696:
2697: DELETE PA_ASSIGNMENTS_HISTORY
2698: WHERE assignment_id =l_assignment_id;

Line 2695: x_err_stage := 'Deleting Records from pa_assignments_history table for id '||to_char(l_assignment_id) ;

2691: /*To keep the count of no of records deleted from pa_project_assignments and pa_assignments_history, manipulate the
2692: count of l_nos_assignments_deleted and l_nos_assignments_his_deleted. */
2693:
2694: pa_debug.debug('Deleting Records from pa_assignments_history table ') ;
2695: x_err_stage := 'Deleting Records from pa_assignments_history table for id '||to_char(l_assignment_id) ;
2696:
2697: DELETE PA_ASSIGNMENTS_HISTORY
2698: WHERE assignment_id =l_assignment_id;
2699:

Line 2697: DELETE PA_ASSIGNMENTS_HISTORY

2693:
2694: pa_debug.debug('Deleting Records from pa_assignments_history table ') ;
2695: x_err_stage := 'Deleting Records from pa_assignments_history table for id '||to_char(l_assignment_id) ;
2696:
2697: DELETE PA_ASSIGNMENTS_HISTORY
2698: WHERE assignment_id =l_assignment_id;
2699:
2700: l_nos_assignments_his_deleted :=l_nos_assignments_his_deleted + SQL%ROWCOUNT;
2701:

Line 2725: 'PA_ASSIGNMENTS_HISTORY',

2721: ) ;
2722:
2723: pa_purge.CommitProcess(p_purge_batch_id,
2724: p_project_id,
2725: 'PA_ASSIGNMENTS_HISTORY',
2726: l_nos_assignments_his_inserted,
2727: l_nos_assignments_his_deleted,
2728: x_err_code,
2729: x_err_stack,