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_FP_EDIT_LINE_PKG dependencies on PA_NUM_TBL_TYPE

Line 2757: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type

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

Line 2758: ,px_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_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
2762: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2759: ,px_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_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
2763: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2760: ,px_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_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
2764: )

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

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:

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

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

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

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:

Line 3515: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type

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

Line 3516: ,p_res_list_member_id_tbl IN SYSTEM.pa_num_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

Line 3518: ,p_resource_id_tbl IN SYSTEM.pa_num_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

Line 3524: ,p_quantity_tbl IN SYSTEM.pa_num_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

Line 3525: ,px_raw_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_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
3529: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 3526: ,px_burdened_cost_tbl IN OUT NOCOPY SYSTEM.pa_num_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
3530: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3527: ,px_revenue_tbl IN OUT NOCOPY SYSTEM.pa_num_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
3531: )

Line 3604: px_raw_cost_tbl := SYSTEM.pa_num_tbl_type();

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();

Line 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();

Line 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);