APPS.PA_PURGE_UNASGN_FI dependencies on PA_FI_AMOUNT_DETAILS

Line 154: -- Function : Archive/purge records for pa_forecast_items, pa_forecast_items_details and pa_fi_amount_details table.

150: -- Start of comments
151: -- API name : DELETE_FI
152: -- Type : Public
153: -- Pre-reqs : None
154: -- Function : Archive/purge records for pa_forecast_items, pa_forecast_items_details and pa_fi_amount_details table.
155: -- Parameters :
156: -- records need to be archived
157: -- p_forecast_item_id_id_tab -> forecast items tab
158: -- End of comments

Line 534: INSERT INTO PA_FI_AMOUNT_DETAILS_AR

530: The value will increase for each loop(forecast item id*/
531: l_nos_fid_inserted := SQL%ROWCOUNT; /* Bug#2510609 */
532:
533: FORALL K IN l_forecast_item_id_tab.FIRST..l_forecast_item_id_tab.LAST -- Bug 5870223
534: INSERT INTO PA_FI_AMOUNT_DETAILS_AR
535: (PURGE_BATCH_ID,
536: PURGE_RELEASE,
537: PURGE_PROJECT_ID,
538: FORECAST_ITEM_ID,

Line 660: FROM PA_FI_AMOUNT_DETAILS Where forecast_item_id=l_forecast_item_id_tab(K); --l_forecast_item_id; Bug 5870223

656: Expfunc_Tp_Rate_Date,
657: Expfunc_Tp_Rate_Type,
658: Expfunc_Tp_Exchange_Rate,
659: Expfunc_Transfer_Price
660: FROM PA_FI_AMOUNT_DETAILS Where forecast_item_id=l_forecast_item_id_tab(K); --l_forecast_item_id; Bug 5870223
661:
662: /*Increase the value of l_nos_fi_amt_inserted to reflct the number of records inserted */
663:
664: l_nos_fi_amt_inserted := SQL%ROWCOUNT; /* Bug#2510609 */

Line 671: /* arpr_log('Deleting Records from pa_fi_amount_details table ') ; */

667:
668: /*To keep the count of no os records deleted from pa_forecast_items and pa_forecast_item_details, manipulate the
669: count of l_nos_of fi_deleted and l_nos_fis_deleted. */
670:
671: /* arpr_log('Deleting Records from pa_fi_amount_details table ') ; */
672: x_err_stage := 'Deleting Records from pa_fi_amount_details table for id '||to_char(l_forecast_item_id) ;
673:
674: FORALL K IN l_forecast_item_id_tab.FIRST..l_forecast_item_id_tab.LAST -- Bug 5870223
675:

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

668: /*To keep the count of no os records deleted from pa_forecast_items and pa_forecast_item_details, manipulate the
669: count of l_nos_of fi_deleted and l_nos_fis_deleted. */
670:
671: /* arpr_log('Deleting Records from pa_fi_amount_details table ') ; */
672: x_err_stage := 'Deleting Records from pa_fi_amount_details table for id '||to_char(l_forecast_item_id) ;
673:
674: FORALL K IN l_forecast_item_id_tab.FIRST..l_forecast_item_id_tab.LAST -- Bug 5870223
675:
676: DELETE PA_FI_AMOUNT_DETAILS

Line 676: DELETE PA_FI_AMOUNT_DETAILS

672: x_err_stage := 'Deleting Records from pa_fi_amount_details table for id '||to_char(l_forecast_item_id) ;
673:
674: FORALL K IN l_forecast_item_id_tab.FIRST..l_forecast_item_id_tab.LAST -- Bug 5870223
675:
676: DELETE PA_FI_AMOUNT_DETAILS
677: WHERE forecast_item_id = l_forecast_item_id_tab(K);--l_forecast_item_id; Bug 5870223
678:
679: l_nos_fi_amt_deleted := SQL%ROWCOUNT; /* Bug#2510609 */
680:

Line 728: 'PA_FI_AMOUNT_DETAILS',

724: ) ;
725:
726: pa_purge.CommitProcess(p_purge_batch_id,
727: l_project_id,
728: 'PA_FI_AMOUNT_DETAILS',
729: l_nos_fi_amt_inserted,
730: l_nos_fi_amt_deleted,
731: x_err_code,
732: x_err_stack,