2753: ,p_product_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
2754: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
2755: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
2756: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
2757: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
2758: ,px_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
2759: ,px_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
2760: ,px_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
2761: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2754: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
2755: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
2756: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
2757: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
2758: ,px_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
2759: ,px_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
2760: ,px_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
2761: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2762: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2755: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
2756: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
2757: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
2758: ,px_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
2759: ,px_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
2760: ,px_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
2761: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2762: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2763: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2756: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
2757: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
2758: ,px_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
2759: ,px_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
2760: ,px_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
2761: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2762: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2763: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2764: )
2774: l_data VARCHAR2(160) ;
2775: l_msg_data VARCHAR2(160) ;
2776: l_msg_index_out NUMBER;
2777:
2778: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2779: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2780: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2781: l_txn_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type() ;
2782:
2775: l_msg_data VARCHAR2(160) ;
2776: l_msg_index_out NUMBER;
2777:
2778: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2779: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2780: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2781: l_txn_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type() ;
2782:
2783: BEGIN
2776: l_msg_index_out NUMBER;
2777:
2778: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2779: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2780: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2781: l_txn_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type() ;
2782:
2783: BEGIN
2784:
3511:
3512: PROCEDURE CALL_CLIENT_EXTENSIONS
3513: ( p_project_id IN pa_projects_all.project_id%TYPE
3514: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
3515: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type
3516: ,p_res_list_member_id_tbl IN SYSTEM.pa_num_tbl_type
3517: ,p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
3518: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type
3519: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
3512: PROCEDURE CALL_CLIENT_EXTENSIONS
3513: ( p_project_id IN pa_projects_all.project_id%TYPE
3514: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
3515: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type
3516: ,p_res_list_member_id_tbl IN SYSTEM.pa_num_tbl_type
3517: ,p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
3518: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type
3519: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
3520: ,p_product_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
3514: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
3515: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type
3516: ,p_res_list_member_id_tbl IN SYSTEM.pa_num_tbl_type
3517: ,p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
3518: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type
3519: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
3520: ,p_product_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
3521: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
3522: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
3520: ,p_product_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
3521: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
3522: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
3523: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
3524: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
3525: ,px_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3526: ,px_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3527: ,px_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3528: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3521: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
3522: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
3523: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
3524: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
3525: ,px_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3526: ,px_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3527: ,px_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3528: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3529: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3522: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
3523: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
3524: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
3525: ,px_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3526: ,px_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3527: ,px_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3528: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3529: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3530: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3523: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
3524: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
3525: ,px_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3526: ,px_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3527: ,px_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_tbl_type
3528: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3529: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3530: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3531: )
3600: pa_debug.write('CALL_CLIENT_EXTENSIONS: ' || l_module_name,pa_debug.g_err_stage,3);
3601: END IF;
3602:
3603: IF nvl(px_raw_cost_tbl.last,0) = 0 THEN
3604: px_raw_cost_tbl := SYSTEM.pa_num_tbl_type();
3605: END IF;
3606:
3607: IF nvl(px_burdened_cost_tbl.last,0) = 0 THEN
3608: px_burdened_cost_tbl := SYSTEM.pa_num_tbl_type();
3604: px_raw_cost_tbl := SYSTEM.pa_num_tbl_type();
3605: END IF;
3606:
3607: IF nvl(px_burdened_cost_tbl.last,0) = 0 THEN
3608: px_burdened_cost_tbl := SYSTEM.pa_num_tbl_type();
3609: END IF;
3610:
3611: IF nvl(px_revenue_tbl.last,0) = 0 THEN
3612: px_revenue_tbl := SYSTEM.pa_num_tbl_type();
3608: px_burdened_cost_tbl := SYSTEM.pa_num_tbl_type();
3609: END IF;
3610:
3611: IF nvl(px_revenue_tbl.last,0) = 0 THEN
3612: px_revenue_tbl := SYSTEM.pa_num_tbl_type();
3613: END IF;
3614:
3615: FOR i IN nvl(px_raw_cost_tbl.last,1)..p_start_date_tbl.last LOOP
3616: px_raw_cost_tbl.extend(1);