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 2275: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2271: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE
2272: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2273: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2274: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2275: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2276: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2277: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2278: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2279: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

Line 2276: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2272: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2273: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2274: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2275: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2276: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2277: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2278: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2279: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2280: ,x_return_status OUT NOCOPY VARCHAR2

Line 2481: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2477: ,p_plsql_index_tab IN SYSTEM.PA_NUM_TBL_TYPE
2478: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2479: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2480: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2481: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2482: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2483: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2484: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2485: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE

Line 2482: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2478: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE
2479: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
2480: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE
2481: ,p_txn_currency_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2482: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2483: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2484: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2485: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE
2486: ,x_return_status OUT NOCOPY VARCHAR2

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

2588: ,p_resource_list_member_Id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2589: ,p_ra_date_tab IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
2590: ,p_task_id_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2591: ,p_quantity_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2592: ,p_txn_currency_code_ovr_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
2593: ,p_cost_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2594: ,p_burden_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2595: ,p_bill_rate_override_tab IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
2596: ,x_resource_assignment_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 2605: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2601: ,x_burden_multiplier_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2602: ,x_ind_compiled_set_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2603: ,x_bill_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2604: ,x_markup_percent_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2605: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2606: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2607: ,x_rev_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2608: ,x_cost_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
2609: ,x_burden_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 2606: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2602: ,x_ind_compiled_set_id_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2603: ,x_bill_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2604: ,x_markup_percent_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2605: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2606: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2607: ,x_rev_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2608: ,x_cost_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
2609: ,x_burden_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
2610: ,x_revenue_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 2607: ,x_rev_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE

2603: ,x_bill_rate_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2604: ,x_markup_percent_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
2605: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2606: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2607: ,x_rev_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
2608: ,x_cost_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
2609: ,x_burden_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
2610: ,x_revenue_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
2611: ,x_return_status OUT NOCOPY VARCHAR2

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

2617: l_resource_assignment_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2618: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2619: l_task_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2620: l_quantity_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2621: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2622: l_txn_currency_code_ovr_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2623: l_curr_conv_reqd_flag_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2624: l_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2625: l_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

2618: l_resource_list_member_Id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2619: l_task_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2620: l_quantity_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2621: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2622: l_txn_currency_code_ovr_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2623: l_curr_conv_reqd_flag_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2624: l_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2625: l_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2626: l_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

2619: l_task_id_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2620: l_quantity_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2621: l_txn_currency_code_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2622: l_txn_currency_code_ovr_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2623: l_curr_conv_reqd_flag_tab SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2624: l_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2625: l_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2626: l_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2627: l_ra_date_tab SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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

3096: x_burden_multiplier_tab := SYSTEM.PA_NUM_TBL_TYPE();
3097: x_ind_compiled_set_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3098: x_bill_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3099: x_markup_percent_tab := SYSTEM.PA_NUM_TBL_TYPE();
3100: x_txn_currency_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3101: x_cost_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3102: x_rev_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3103: x_cost_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3104: x_burden_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

3097: x_ind_compiled_set_id_tab := SYSTEM.PA_NUM_TBL_TYPE();
3098: x_bill_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3099: x_markup_percent_tab := SYSTEM.PA_NUM_TBL_TYPE();
3100: x_txn_currency_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3101: x_cost_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3102: x_rev_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3103: x_cost_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3104: x_burden_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3105: x_revenue_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

3098: x_bill_rate_tab := SYSTEM.PA_NUM_TBL_TYPE();
3099: x_markup_percent_tab := SYSTEM.PA_NUM_TBL_TYPE();
3100: x_txn_currency_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3101: x_cost_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3102: x_rev_txn_curr_code_tab := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3103: x_cost_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3104: x_burden_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3105: x_revenue_rejection_code_tab := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3106: x_expenditure_ou_tab := SYSTEM.PA_NUM_TBL_TYPE();