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_UNASGN_FI dependencies on PA_FORECAST_ITEM_DETAILS

Line 410: /* arpr_log('Inserting Records into pa_forecast_item_DETAILS_AR table ') ; */

406: /*Increase the value of l_nos_fi_inserted to indicate number of records inserted in forecast_items table.
407: The value will increase for each loop(forecast item id*/
408: l_nos_fi_inserted := SQL%ROWCOUNT; /* Bug#2510609 */
409:
410: /* arpr_log('Inserting Records into pa_forecast_item_DETAILS_AR table ') ; */
411: x_err_stage := 'Inserting Records into forecast_item_detail table for forecast item '||to_char(l_forecast_item_id) ;
412:
413: FORALL K IN l_forecast_item_id_tab.FIRST..l_forecast_item_id_tab.LAST -- Bug 5870223
414: INSERT INTO PA_FRCST_ITEM_DTLS_AR

Line 526: FROM PA_forecast_item_details

522: PROJECT_ID,
523: RESOURCE_ID,
524: EXPENDITURE_ORGANIZATION_ID,
525: PJI_SUMMARIZED_FLAG
526: FROM PA_forecast_item_details
527: WHERE forecast_item_id=l_forecast_item_id_tab(K);--l_forecast_item_id; bug 5870223
528:
529: /*Increase the value of l_nos_fis_inserted to indicate number of records inserted in forecast_items detail table.
530: The value will increase for each loop(forecast item id*/

Line 668: /*To keep the count of no os records deleted from pa_forecast_items and pa_forecast_item_details, manipulate the

664: l_nos_fi_amt_inserted := SQL%ROWCOUNT; /* Bug#2510609 */
665:
666: END IF;
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) ;

Line 681: /* arpr_log('Deleting Records from pa_forecast_item_details table ') ; */

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:
681: /* arpr_log('Deleting Records from pa_forecast_item_details table ') ; */
682: x_err_stage := 'Deleting Records from pa_forecast_item_details table for id '||to_char(l_forecast_item_id) ;
683:
684: FORALL K IN l_forecast_item_id_tab.FIRST..l_forecast_item_id_tab.LAST -- Bug 5870223
685:

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

678:
679: l_nos_fi_amt_deleted := SQL%ROWCOUNT; /* Bug#2510609 */
680:
681: /* arpr_log('Deleting Records from pa_forecast_item_details table ') ; */
682: x_err_stage := 'Deleting Records from pa_forecast_item_details table for id '||to_char(l_forecast_item_id) ;
683:
684: FORALL K IN l_forecast_item_id_tab.FIRST..l_forecast_item_id_tab.LAST -- Bug 5870223
685:
686: DELETE PA_FORECAST_ITEM_DETAILS

Line 686: DELETE PA_FORECAST_ITEM_DETAILS

682: x_err_stage := 'Deleting Records from pa_forecast_item_details table for id '||to_char(l_forecast_item_id) ;
683:
684: FORALL K IN l_forecast_item_id_tab.FIRST..l_forecast_item_id_tab.LAST -- Bug 5870223
685:
686: DELETE PA_FORECAST_ITEM_DETAILS
687: WHERE forecast_item_id =l_forecast_item_id_tab(K);--l_forecast_item_id; Bug 5870223
688:
689: l_nos_fid_deleted :=SQL%ROWCOUNT; /* Bug#2510609 */
690:

Line 704: The procedure is called once for pa_forecast_items and once for pa_forecast_item_details */

700:
701: -- END LOOP; /* Bug#2510609 */
702:
703: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
704: The procedure is called once for pa_forecast_items and once for pa_forecast_item_details */
705:
706:
707: pa_purge.CommitProcess (p_purge_batch_id,
708: l_project_id,

Line 718: 'PA_FORECAST_ITEM_DETAILS',

714: x_err_stage
715: ) ;
716: pa_purge.CommitProcess(p_purge_batch_id,
717: l_project_id,
718: 'PA_FORECAST_ITEM_DETAILS',
719: l_nos_fid_inserted,
720: l_nos_fid_deleted,
721: x_err_code,
722: x_err_stack,