DBA Data[Home] [Help]

APPS.PA_FP_VIEW_PLANS_TXN_PUB dependencies on PA_BUDGET_LINES

Line 24: TABLE of pa_budget_lines.quantity%TYPE index by BINARY_INTEGER;

20: TABLE OF VARCHAR2(30) index by BINARY_INTEGER;
21: type vptxn_unit_of_measure_tab is
22: TABLE of pa_resource_assignments.unit_of_measure%TYPE index by BINARY_INTEGER;
23: type vptxn_quantity_tab is
24: TABLE of pa_budget_lines.quantity%TYPE index by BINARY_INTEGER;
25: type vptxn_txn_currency_code_tab is
26: TABLE of pa_budget_lines.txn_currency_code%TYPE index by BINARY_INTEGER;
27: type vptxn_txn_revenue_tab is
28: TABLE of pa_budget_lines.txn_revenue%TYPE index by BINARY_INTEGER;

Line 26: TABLE of pa_budget_lines.txn_currency_code%TYPE index by BINARY_INTEGER;

22: TABLE of pa_resource_assignments.unit_of_measure%TYPE index by BINARY_INTEGER;
23: type vptxn_quantity_tab is
24: TABLE of pa_budget_lines.quantity%TYPE index by BINARY_INTEGER;
25: type vptxn_txn_currency_code_tab is
26: TABLE of pa_budget_lines.txn_currency_code%TYPE index by BINARY_INTEGER;
27: type vptxn_txn_revenue_tab is
28: TABLE of pa_budget_lines.txn_revenue%TYPE index by BINARY_INTEGER;
29: type vptxn_txn_burdened_cost_tab is
30: TABLE of pa_budget_lines.txn_burdened_cost%TYPE index by BINARY_INTEGER;

Line 28: TABLE of pa_budget_lines.txn_revenue%TYPE index by BINARY_INTEGER;

24: TABLE of pa_budget_lines.quantity%TYPE index by BINARY_INTEGER;
25: type vptxn_txn_currency_code_tab is
26: TABLE of pa_budget_lines.txn_currency_code%TYPE index by BINARY_INTEGER;
27: type vptxn_txn_revenue_tab is
28: TABLE of pa_budget_lines.txn_revenue%TYPE index by BINARY_INTEGER;
29: type vptxn_txn_burdened_cost_tab is
30: TABLE of pa_budget_lines.txn_burdened_cost%TYPE index by BINARY_INTEGER;
31: type vptxn_txn_raw_cost_tab is
32: TABLE of pa_budget_lines.txn_raw_cost%TYPE index by BINARY_INTEGER;

Line 30: TABLE of pa_budget_lines.txn_burdened_cost%TYPE index by BINARY_INTEGER;

26: TABLE of pa_budget_lines.txn_currency_code%TYPE index by BINARY_INTEGER;
27: type vptxn_txn_revenue_tab is
28: TABLE of pa_budget_lines.txn_revenue%TYPE index by BINARY_INTEGER;
29: type vptxn_txn_burdened_cost_tab is
30: TABLE of pa_budget_lines.txn_burdened_cost%TYPE index by BINARY_INTEGER;
31: type vptxn_txn_raw_cost_tab is
32: TABLE of pa_budget_lines.txn_raw_cost%TYPE index by BINARY_INTEGER;
33:
34:

Line 32: TABLE of pa_budget_lines.txn_raw_cost%TYPE index by BINARY_INTEGER;

28: TABLE of pa_budget_lines.txn_revenue%TYPE index by BINARY_INTEGER;
29: type vptxn_txn_burdened_cost_tab is
30: TABLE of pa_budget_lines.txn_burdened_cost%TYPE index by BINARY_INTEGER;
31: type vptxn_txn_raw_cost_tab is
32: TABLE of pa_budget_lines.txn_raw_cost%TYPE index by BINARY_INTEGER;
33:
34:
35: G_MULTI_CURR_FLAG VARCHAR2(30); --Y/N
36: G_PLAN_TYPE_ID NUMBER(15);

Line 163: p_filter_txncurrency IN pa_budget_lines.txn_currency_code%TYPE,

159: p_get_display_from IN VARCHAR2, -- 'COST', 'REVENUE', 'BOTH', 'ANY'
160: p_filter_task_id IN pa_resource_assignments.task_id%TYPE,
161: p_filter_resource_id IN pa_resource_list_members.resource_id%TYPE,
162: p_filter_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,
163: p_filter_txncurrency IN pa_budget_lines.txn_currency_code%TYPE,
164: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
165: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
166: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
167: