1673: l_rowid ROWID;
1674: l_counter NUMBER := 1 ;
1675: l_cost_cnt NUMBER := 1 ;
1676:
1677: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
1678: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
1679: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
1680: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
1681: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
1674: l_counter NUMBER := 1 ;
1675: l_cost_cnt NUMBER := 1 ;
1676:
1677: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
1678: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
1679: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
1680: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
1681: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
1682: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
1675: l_cost_cnt NUMBER := 1 ;
1676:
1677: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
1678: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
1679: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
1680: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
1681: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
1682: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
1683:
1676:
1677: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
1678: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
1679: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
1680: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
1681: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
1682: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
1683:
1684: l_period_name_flag VARCHAR2(1);
1677: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
1678: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
1679: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
1680: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
1681: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
1682: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
1683:
1684: l_period_name_flag VARCHAR2(1);
1685: l_period_name_tot_flag VARCHAR2(1);
1678: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
1679: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
1680: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
1681: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
1682: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
1683:
1684: l_period_name_flag VARCHAR2(1);
1685: l_period_name_tot_flag VARCHAR2(1);
1686: l_current_index PLS_INTEGER;