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_FORECAST_HDR_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12


PROCEDURE insert_rows ( p_forecast_hdr_tab             IN  PA_FORECAST_GLOB.FIHdrTabTyp,
                        x_return_status                       OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
                        x_msg_count                           OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
                        x_msg_data                            OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS
 l_forecast_item_id                 PA_PLSQL_DATATYPES.IdTabTyp;

Line: 46


 l_delete_flag                      PA_PLSQL_DATATYPES.Char1TabTyp;

Line: 80


PA_DEBUG.Init_err_stack( 'PA_FORECAST_HDR_PKG.Insert_Rows');

Line: 236


 l_delete_flag(l_j)                      := p_forecast_hdr_tab(l_j).delete_flag;

Line: 256


 INSERT INTO PA_FORECAST_ITEMS
      (
	 forecast_item_id                 ,
   	 forecast_item_type               ,
 	 project_org_id                   ,
 	 expenditure_org_id               ,
 	 expenditure_organization_id      ,
 	 project_organization_id          ,
 	 project_id                       ,
 	 project_type_class               ,
 	 person_id                        ,
 	 resource_id                      ,
 	 borrowed_flag                    ,
 	 assignment_id                    ,
 	 item_date                        ,
 	 item_uom                         ,
 	 item_quantity                    ,
 	 pvdr_period_set_name             ,
 	 pvdr_pa_period_name              ,
 	 pvdr_gl_period_name              ,
 	 rcvr_period_set_name             ,
 	 rcvr_pa_period_name              ,
 	 rcvr_gl_period_name              ,
 	 global_exp_period_end_date       ,
 	 expenditure_type                 ,
 	 expenditure_type_class           ,
 	 cost_rejection_code              ,
 	 rev_rejection_code               ,
 	 tp_rejection_code                ,
 	 burden_rejection_code            ,
 	 other_rejection_code             ,
 	 delete_flag                      ,
 	 provisional_flag                 ,
 	 error_flag                       ,
   JOB_ID            ,
   TP_AMOUNT_TYPE            ,
   OVERPROVISIONAL_QTY            ,
   OVER_PROV_CONF_QTY            ,
   CONFIRMED_QTY            ,
   PROVISIONAL_QTY            ,
   asgmt_sys_status_code            ,
   capacity_quantity                ,
   overcommitment_quantity          ,
   availability_quantity            ,
   overcommitment_flag              ,
   availability_flag                ,
         creation_date              ,
         created_by                       ,
         last_update_date                 ,
         last_updated_by                  ,
         last_update_login                ,
         request_id                       ,
         program_application_id           ,
         program_id                       ,
         program_update_date,
         FORECAST_AMT_CALC_FLAG)
 VALUES (
        l_forecast_item_id(l_J)                                ,
        l_forecast_item_type(l_j)                              ,
        l_project_org_id(l_j)                                  ,
        l_expenditure_org_id(l_j)                              ,
        l_expenditure_organization_id(l_j)                     ,
        l_project_organization_id(l_j)                         ,
        l_project_id(l_j)                                      ,
        l_project_type_class(l_j)                              ,
        l_person_id(l_j)                                       ,
        l_resource_id(l_j)                                     ,
        l_borrowed_flag(l_j)                                   ,
        l_assignment_id(l_j)                                   ,
        l_item_date(l_j)                                       ,
        l_item_uom(l_j)                                        ,
        l_item_quantity(l_j)                                   ,
        l_pvdr_period_set_name(l_j)                            ,
        l_pvdr_pa_period_name(l_j)                             ,
        l_pvdr_gl_period_name(l_j)                             ,
        l_rcvr_period_set_name(l_j)                            ,
        l_rcvr_pa_period_name(l_j)                             ,
        l_rcvr_gl_period_name(l_j)                             ,
        l_global_exp_period_end_date(l_j)                      ,
        l_expenditure_type(l_j)                                ,
        l_expenditure_type_class(l_j)                          ,
        l_cost_rejection_code(l_j)                             ,
        l_rev_rejection_code(l_j)                              ,
        l_tp_rejection_code(l_j)                               ,
        l_burden_rejection_code(l_j)                           ,
        l_other_rejection_code(l_j)                            ,
        l_delete_flag(l_j)                                     ,
        l_provisional_flag(l_j)                                ,
        l_error_flag(l_j)                                      ,
        l_JOB_ID(l_j)                           ,
        l_TP_AMOUNT_TYPE(l_j)                           ,
        l_OVERPROVISIONAL_QTY(l_j)                           ,
        l_OVER_PROV_CONF_QTY(l_j)                           ,
        l_CONFIRMED_QTY(l_j)                           ,
        l_PROVISIONAL_QTY(l_j)                           ,
        l_asgmt_sys_status_code(l_j)                           ,
        nvl(l_capacity_quantity(l_j),0)                               ,
        l_overcommitment_quantity(l_j)                         ,
        l_availability_quantity(l_j)                           ,
        l_overcommitment_flag(l_j)                             ,
        l_availability_flag(l_j)                               ,
        sysdate                                              ,
        fnd_global.user_id                                   ,
        sysdate                                              ,
        fnd_global.user_id                                   ,
        fnd_global.login_id                                  ,
        fnd_global.conc_request_id()                         ,
        fnd_global.prog_appl_id   ()                         ,
        fnd_global.conc_program_id()                         ,
        trunc(sysdate)                                       ,
         'N');

Line: 419


       (p_pkg_name   => 'PA_FORECAST_HDR_PKG.Insert_Rows',
        p_procedure_name => PA_DEBUG.G_Err_Stack);

Line: 425


END insert_rows;

Line: 432


PROCEDURE update_rows ( p_forecast_hdr_tab             IN  PA_FORECAST_GLOB.FIHdrTabTyp,
                        x_return_status                       OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
                        x_msg_count                           OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
                        x_msg_data                            OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

IS
 l_forecast_item_id                 PA_PLSQL_DATATYPES.IdTabTyp;

Line: 467


 l_delete_flag                      PA_PLSQL_DATATYPES.Char1TabTyp;

Line: 501


  PA_DEBUG.Init_err_stack( 'PA_FORECAST_HDR_PKG.Update_Rows');

Line: 510


  PA_FORECASTITEM_PVT.print_message('start of the forecast update row .... ');

Line: 513


 if (p_forecast_hdr_tab(l_j).error_flag = 'Y' and nvl(p_forecast_hdr_tab(l_j).delete_flag,'N') <> 'Y') then -- added second condition for bug 4254376
    PA_FORECASTITEM_PVT.print_message('Errors');

Line: 656


 l_delete_flag(l_j)                      := p_forecast_hdr_tab(l_j).delete_flag;

Line: 675


 UPDATE PA_FORECAST_ITEMS
 SET
 	forecast_item_type               = l_forecast_item_type(l_j)		,
 	project_org_id                   = l_project_org_id(l_j)		,
 	expenditure_org_id               = l_expenditure_org_id(l_j)		,
 	expenditure_organization_id      = l_expenditure_organization_id(l_j)	,
 	project_organization_id          = l_project_organization_id(l_j)	,
 	project_id                       = l_project_id(l_j)			,
 	project_type_class               = l_project_type_class(l_j)		,
 	person_id                        = l_person_id(l_j)			,
 	resource_id                      = l_resource_id(l_j)			,
 	borrowed_flag                    = l_borrowed_flag(l_j)			,
 	assignment_id                    = l_assignment_id(l_j)			,
 	item_date                        = l_item_date(l_j)			,
 	item_uom                         = l_item_uom(l_j)			,
 	item_quantity                    = l_item_quantity(l_j)			,
 	pvdr_period_set_name             = l_pvdr_period_set_name(l_j)		,
 	pvdr_pa_period_name              = l_pvdr_pa_period_name(l_j)		,
 	pvdr_gl_period_name              = l_pvdr_gl_period_name(l_j)		,
 	rcvr_period_set_name             = l_rcvr_period_set_name(l_j)		,
 	rcvr_pa_period_name              = l_rcvr_pa_period_name(l_j)		,
 	rcvr_gl_period_name              = l_rcvr_gl_period_name(l_j)		,
 	global_exp_period_end_date       = l_global_exp_period_end_date(l_j)	,
 	expenditure_type                 = l_expenditure_type(l_j)		,
 	expenditure_type_class           = l_expenditure_type_class(l_j)	,
 	cost_rejection_code              = l_cost_rejection_code(l_j)		,
 	rev_rejection_code               = l_rev_rejection_code(l_j)		,
 	tp_rejection_code                = l_tp_rejection_code(l_j)		,
 	burden_rejection_code            = l_burden_rejection_code(l_j)		,
 	other_rejection_code             = l_other_rejection_code(l_j)		,
 	delete_flag                      = l_delete_flag(l_j)			,
 	provisional_flag                 = l_provisional_flag(l_j)		,
 	error_flag                       = l_error_flag(l_j)			,
   JOB_ID           = l_JOB_ID(l_j)      ,
   TP_AMOUNT_TYPE           = l_TP_AMOUNT_TYPE(l_j)      ,
   OVERPROVISIONAL_QTY           = l_OVERPROVISIONAL_QTY(l_j)      ,
   OVER_PROV_CONF_QTY           = l_OVER_PROV_CONF_QTY(l_j)      ,
   CONFIRMED_QTY           = l_CONFIRMED_QTY(l_j)      ,
   PROVISIONAL_QTY           = l_PROVISIONAL_QTY(l_j)      ,
   asgmt_sys_status_code           = l_asgmt_sys_status_code(l_j)      ,
   capacity_quantity               = nvl(l_capacity_quantity(l_j),0),
   overcommitment_quantity         = l_overcommitment_quantity(l_j),
   availability_quantity           = l_availability_quantity(l_j),
   overcommitment_flag             = l_overcommitment_flag(l_j),
   availability_flag               = l_availability_flag(l_j),
        last_update_date        	 = sysdate 				,
        last_updated_by          	 = fnd_global.user_id			,
        last_update_login       	 = fnd_global.login_id ,
         FORECAST_AMT_CALC_FLAG = 'N',
	       COST_TXN_CURRENCY_CODE = null,
	       REVENUE_TXN_CURRENCY_CODE = null,
	       TXN_RAW_COST = null,
	       TXN_BURDENED_COST = null,
	       TXN_REVENUE = null,
	       TP_TXN_CURRENCY_CODE = null,
	       TXN_TRANSFER_PRICE = null,
	       PROJECT_CURRENCY_CODE = null,
	       PROJECT_RAW_COST = null,
	       PROJECT_BURDENED_COST = null,
	       PROJECT_REVENUE = null	,
	       PROJECT_TRANSFER_PRICE = null	,
	       PROJFUNC_CURRENCY_CODE = null,
	       PROJFUNC_RAW_COST = null,
	       PROJFUNC_BURDENED_COST = null,
	       PROJFUNC_REVENUE = null,
	       PROJFUNC_TRANSFER_PRICE = null,
	       EXPFUNC_CURRENCY_CODE = null,
	       EXPFUNC_RAW_COST = null,
	       EXPFUNC_BURDENED_COST = null,
	       EXPFUNC_TRANSFER_PRICE = null
         WHERE  forecast_item_id                 = l_forecast_item_id(l_j);

Line: 747


 PA_FORECASTITEM_PVT.print_message('end of update row .... ');

Line: 799


       (p_pkg_name   => 'PA_FORECAST_HDR_PKG.Update_Rows',
        p_procedure_name => PA_DEBUG.G_Err_Stack);

Line: 804


 PA_FORECASTITEM_PVT.print_message('ERROR in update row '||sqlerrm);

Line: 805


END update_rows;

Line: 812


PROCEDURE update_schedule_rows ( p_schedule_tab                        IN  PA_FORECAST_GLOB.ScheduleTabTyp,
                                 x_return_status                       OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
                                 x_msg_count                           OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
                                 x_msg_data                            OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

IS
 l_schedule_id                      PA_PLSQL_DATATYPES.IdTabTyp;

Line: 823


  PA_DEBUG.Init_err_stack( 'PA_FORECAST_HDR_PKG.Update_Schedule_Rows');

Line: 843


 UPDATE PA_SCHEDULES
 SET
 	forecast_txn_version_number            = NVL(l_forecast_txn_version_number(l_j),0) + 1           ,
 	forecast_txn_generated_flag            = 'Y'                                        ,
        last_update_date                 = sysdate 			              ,
        last_update_by                   = fnd_global.user_id                         ,
        last_update_login                = fnd_global.login_id
 WHERE  schedule_id                      = l_schedule_id(l_j)
  AND   forecast_txn_version_number      = l_forecast_txn_version_number(l_j);

Line: 853


PA_FORECASTITEM_PVT.print_message('after update');

Line: 864


       (p_pkg_name   => 'PA_FORECAST_HDR_PKG.Update_Schedule_Rows',
        p_procedure_name => PA_DEBUG.G_Err_Stack);

Line: 868


 PA_FORECASTITEM_PVT.print_message('ERROR in update row '||sqlerrm);

Line: 869


END update_schedule_rows;

Line: 871


PROCEDURE update_rows(p_assignment_id IN NUMBER,
                 p_forecast_amt_calc_flag IN VARCHAR2,
                 x_return_status    OUT     NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
                 x_msg_count        OUT     NOCOPY NUMBER, --File.Sql.39 bug 4440895
                 x_msg_data         OUT     NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

 l_msg_index_out  NUMBER;

Line: 881


   update pa_forecast_items
   set
     forecast_amt_calc_flag = 'N'
   where assignment_id = p_assignment_id;

Line: 889


                  PA_FORECASTITEM_PVT.print_message('Failed in update_rows api');

Line: 896


                              'PA_FORECAST_HDR_PKG.update_rows',
                       p_procedure_name => PA_DEBUG.G_Err_Stack);

Line: 918


END update_rows;