DBA Data[Home] [Help]

APPS.PA_FP_VIEW_PLANS_TXN_PUB dependencies on PA_NUM_TBL_TYPE

Line 3225: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3221: l_debug_level4 CONSTANT NUMBER := 4;
3222: l_debug_level5 CONSTANT NUMBER := 5;
3223:
3224: l_project_id pa_projects_all.project_id%TYPE ;
3225: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3226: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3227: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE ;
3228: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3229: l_txn_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type ;

Line 3226: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3222: l_debug_level5 CONSTANT NUMBER := 5;
3223:
3224: l_project_id pa_projects_all.project_id%TYPE ;
3225: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3226: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3227: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE ;
3228: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3229: l_txn_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type ;
3230: l_product_code_tbl SYSTEM.pa_varchar2_30_tbl_type ;

Line 3228: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3224: l_project_id pa_projects_all.project_id%TYPE ;
3225: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3226: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3227: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE ;
3228: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3229: l_txn_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type ;
3230: l_product_code_tbl SYSTEM.pa_varchar2_30_tbl_type ;
3231: l_start_date_tbl SYSTEM.pa_date_tbl_type ;
3232: l_end_date_tbl SYSTEM.pa_date_tbl_type ;

Line 3234: l_quantity_tbl SYSTEM.pa_num_tbl_type ;

3230: l_product_code_tbl SYSTEM.pa_varchar2_30_tbl_type ;
3231: l_start_date_tbl SYSTEM.pa_date_tbl_type ;
3232: l_end_date_tbl SYSTEM.pa_date_tbl_type ;
3233: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type ;
3234: l_quantity_tbl SYSTEM.pa_num_tbl_type ;
3235: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type ;
3236: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type ;
3237: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type ;
3238:

Line 3235: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type ;

3231: l_start_date_tbl SYSTEM.pa_date_tbl_type ;
3232: l_end_date_tbl SYSTEM.pa_date_tbl_type ;
3233: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type ;
3234: l_quantity_tbl SYSTEM.pa_num_tbl_type ;
3235: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type ;
3236: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type ;
3237: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type ;
3238:
3239: l_budget_line_id_tbl SYSTEM.pa_num_tbl_type ;

Line 3236: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type ;

3232: l_end_date_tbl SYSTEM.pa_date_tbl_type ;
3233: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type ;
3234: l_quantity_tbl SYSTEM.pa_num_tbl_type ;
3235: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type ;
3236: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type ;
3237: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type ;
3238:
3239: l_budget_line_id_tbl SYSTEM.pa_num_tbl_type ;
3240: l_ra_id_tbl SYSTEM.pa_num_tbl_type ;

Line 3237: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type ;

3233: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type ;
3234: l_quantity_tbl SYSTEM.pa_num_tbl_type ;
3235: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type ;
3236: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type ;
3237: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type ;
3238:
3239: l_budget_line_id_tbl SYSTEM.pa_num_tbl_type ;
3240: l_ra_id_tbl SYSTEM.pa_num_tbl_type ;
3241: l_task_id pa_tasks.task_id%TYPE;

Line 3239: l_budget_line_id_tbl SYSTEM.pa_num_tbl_type ;

3235: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type ;
3236: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type ;
3237: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type ;
3238:
3239: l_budget_line_id_tbl SYSTEM.pa_num_tbl_type ;
3240: l_ra_id_tbl SYSTEM.pa_num_tbl_type ;
3241: l_task_id pa_tasks.task_id%TYPE;
3242: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
3243: l_resource_id pa_resource_list_members.resource_id%TYPE;

Line 3240: l_ra_id_tbl SYSTEM.pa_num_tbl_type ;

3236: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type ;
3237: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type ;
3238:
3239: l_budget_line_id_tbl SYSTEM.pa_num_tbl_type ;
3240: l_ra_id_tbl SYSTEM.pa_num_tbl_type ;
3241: l_task_id pa_tasks.task_id%TYPE;
3242: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
3243: l_resource_id pa_resource_list_members.resource_id%TYPE;
3244: l_prev_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -99;