DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS2 dependencies on PA_VARCHAR2_15_TBL_TYPE

Line 1060: l_txn_currency_code_tab system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();

1056: l_etc_start_date Date;
1057: l_plan_version_type Varchar2(100);
1058:
1059: l_resource_assignment_tab system.pa_num_tbl_type := system.pa_num_tbl_type();
1060: l_txn_currency_code_tab system.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
1061: l_line_start_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1062: l_line_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1063:
1064: /* Bug fix: 3964805 Declare the local variables as IN params cannot be assigned */

Line 2268: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2264: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE
2265: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2266: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2267: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2268: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2269: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2270: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2271: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2272: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

Line 2269: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2265: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2266: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2267: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2268: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2269: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2270: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2271: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2272: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2273: ,x_return_status OUT NOCOPY VARCHAR2

Line 2474: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2470: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE
2471: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2472: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2473: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2474: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2475: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2476: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2477: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2478: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

Line 2475: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2471: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2472: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2473: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2474: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2475: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2476: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2477: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2478: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2479: ,x_return_status OUT NOCOPY VARCHAR2

Line 2585: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()

2581: ,p_resource_list_member_Id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2582: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
2583: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2584: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2585: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
2586: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2587: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2588: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2589: ,x_resource_assignment_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 2598: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2594: ,x_burden_multiplier_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2595: ,x_ind_compiled_set_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2596: ,x_bill_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2597: ,x_markup_percent_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2598: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2599: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2600: ,x_rev_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2601: ,x_cost_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
2602: ,x_burden_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 2599: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2595: ,x_ind_compiled_set_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2596: ,x_bill_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2597: ,x_markup_percent_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2598: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2599: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2600: ,x_rev_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2601: ,x_cost_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
2602: ,x_burden_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
2603: ,x_revenue_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 2600: ,x_rev_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2596: ,x_bill_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2597: ,x_markup_percent_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2598: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2599: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2600: ,x_rev_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2601: ,x_cost_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
2602: ,x_burden_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
2603: ,x_revenue_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
2604: ,x_return_status OUT NOCOPY VARCHAR2

Line 2614: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

2610: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2611: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2612: l_task_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2613: l_quantity_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2614: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2615: l_txn_currency_code_ovr_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2616: l_curr_conv_reqd_flag_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2617: l_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2618: l_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2615: l_txn_currency_code_ovr_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

2611: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2612: l_task_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2613: l_quantity_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2614: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2615: l_txn_currency_code_ovr_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2616: l_curr_conv_reqd_flag_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2617: l_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2618: l_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2619: l_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2616: l_curr_conv_reqd_flag_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

2612: l_task_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2613: l_quantity_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2614: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2615: l_txn_currency_code_ovr_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2616: l_curr_conv_reqd_flag_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2617: l_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2618: l_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2619: l_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2620: l_ra_date_tab SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 3093: x_txn_currency_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

3089: x_burden_multiplier_tab := SYSTEM.PA_NUM_TBL_TYPE();
3090: x_ind_compiled_set_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3091: x_bill_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3092: x_markup_percent_tab := SYSTEM.PA_NUM_TBL_TYPE();
3093: x_txn_currency_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3094: x_cost_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3095: x_rev_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3096: x_cost_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3097: x_burden_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 3094: x_cost_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

3090: x_ind_compiled_set_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3091: x_bill_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3092: x_markup_percent_tab := SYSTEM.PA_NUM_TBL_TYPE();
3093: x_txn_currency_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3094: x_cost_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3095: x_rev_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3096: x_cost_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3097: x_burden_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3098: x_revenue_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 3095: x_rev_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

3091: x_bill_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3092: x_markup_percent_tab := SYSTEM.PA_NUM_TBL_TYPE();
3093: x_txn_currency_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3094: x_cost_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3095: x_rev_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3096: x_cost_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3097: x_burden_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3098: x_revenue_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3099: x_expenditure_ou_tab := SYSTEM.PA_NUM_TBL_TYPE();