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_FI_AMOUNT_DETAILS

Line 1045: INSERT INTO PA_FI_AMOUNT_DETAILS_AR

1041: /*Increase the value of l_nos_fis_inserted to indicate number of records inserted in forecast_items detail table.
1042: The value will increase for each loop(forecast item id*/
1043: l_nos_fid_inserted := l_nos_fid_inserted + SQL%ROWCOUNT;
1044:
1045: INSERT INTO PA_FI_AMOUNT_DETAILS_AR
1046: (PURGE_BATCH_ID,
1047: PURGE_RELEASE,
1048: PURGE_PROJECT_ID,
1049: FORECAST_ITEM_ID,

Line 1171: FROM PA_FI_AMOUNT_DETAILS Where forecast_item_id=l_forecast_item_id;

1167: Expfunc_Tp_Rate_Date,
1168: Expfunc_Tp_Rate_Type,
1169: Expfunc_Tp_Exchange_Rate,
1170: Expfunc_Transfer_Price
1171: FROM PA_FI_AMOUNT_DETAILS Where forecast_item_id=l_forecast_item_id;
1172:
1173: /*Increase the value of l_nos_fi_amt_inserted to reflct the number of records inserted */
1174:
1175: l_nos_fi_amt_inserted := l_nos_fi_amt_inserted + SQL%ROWCOUNT;

Line 1182: pa_debug.debug('Deleting Records from pa_fi_amount_details table ') ;

1178:
1179: /*To keep the count of no os records deleted from pa_forecast_items and pa_forecast_item_details, manipulate the
1180: count of l_nos_of fi_deleted and l_nos_fis_deleted. */
1181:
1182: pa_debug.debug('Deleting Records from pa_fi_amount_details table ') ;
1183: x_err_stage := 'Deleting Records from pa_fi_amount_details table for id '||to_char(l_forecast_item_id) ;
1184:
1185: DELETE PA_FI_AMOUNT_DETAILS
1186: WHERE forecast_item_id =l_forecast_item_id;

Line 1183: x_err_stage := 'Deleting Records from pa_fi_amount_details table for id '||to_char(l_forecast_item_id) ;

1179: /*To keep the count of no os records deleted from pa_forecast_items and pa_forecast_item_details, manipulate the
1180: count of l_nos_of fi_deleted and l_nos_fis_deleted. */
1181:
1182: pa_debug.debug('Deleting Records from pa_fi_amount_details table ') ;
1183: x_err_stage := 'Deleting Records from pa_fi_amount_details table for id '||to_char(l_forecast_item_id) ;
1184:
1185: DELETE PA_FI_AMOUNT_DETAILS
1186: WHERE forecast_item_id =l_forecast_item_id;
1187:

Line 1185: DELETE PA_FI_AMOUNT_DETAILS

1181:
1182: pa_debug.debug('Deleting Records from pa_fi_amount_details table ') ;
1183: x_err_stage := 'Deleting Records from pa_fi_amount_details table for id '||to_char(l_forecast_item_id) ;
1184:
1185: DELETE PA_FI_AMOUNT_DETAILS
1186: WHERE forecast_item_id =l_forecast_item_id;
1187:
1188: l_nos_fi_amt_deleted := l_nos_fi_amt_deleted + SQL%ROWCOUNT;
1189:

Line 1237: 'PA_FI_AMOUNT_DETAILS',

1233: ) ;
1234:
1235: pa_purge.CommitProcess(p_purge_batch_id,
1236: p_project_id,
1237: 'PA_FI_AMOUNT_DETAILS',
1238: /* l_nos_fid_inserted, bug 2480653 */
1239: /* l_nos_fid_deleted, bug 2480653 */
1240: l_nos_fi_amt_inserted,
1241: l_nos_fi_amt_deleted,