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_VIEW_PLANS_TXN_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

Line 12: TABLE of pa_resource_assignments.project_id%TYPE index by BINARY_INTEGER;

8: End of Comments
9: */
10:
11: type vptxn_project_id_tab is
12: TABLE of pa_resource_assignments.project_id%TYPE index by BINARY_INTEGER;
13: type vptxn_task_id_tab is
14: TABLE of pa_resource_assignments.task_id%TYPE index by BINARY_INTEGER;
15: type vptxn_res_list_member_id_tab is
16: TABLE of pa_resource_assignments.resource_list_member_id%TYPE index by BINARY_INTEGER;

Line 14: TABLE of pa_resource_assignments.task_id%TYPE index by BINARY_INTEGER;

10:
11: type vptxn_project_id_tab is
12: TABLE of pa_resource_assignments.project_id%TYPE index by BINARY_INTEGER;
13: type vptxn_task_id_tab is
14: TABLE of pa_resource_assignments.task_id%TYPE index by BINARY_INTEGER;
15: type vptxn_res_list_member_id_tab is
16: TABLE of pa_resource_assignments.resource_list_member_id%TYPE index by BINARY_INTEGER;
17: type vptxn_res_assignment_id_tab is
18: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;

Line 16: TABLE of pa_resource_assignments.resource_list_member_id%TYPE index by BINARY_INTEGER;

12: TABLE of pa_resource_assignments.project_id%TYPE index by BINARY_INTEGER;
13: type vptxn_task_id_tab is
14: TABLE of pa_resource_assignments.task_id%TYPE index by BINARY_INTEGER;
15: type vptxn_res_list_member_id_tab is
16: TABLE of pa_resource_assignments.resource_list_member_id%TYPE index by BINARY_INTEGER;
17: type vptxn_res_assignment_id_tab is
18: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;
19: type vptxn_grouping_type_tab is
20: TABLE OF VARCHAR2(30) index by BINARY_INTEGER;

Line 18: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;

14: TABLE of pa_resource_assignments.task_id%TYPE index by BINARY_INTEGER;
15: type vptxn_res_list_member_id_tab is
16: TABLE of pa_resource_assignments.resource_list_member_id%TYPE index by BINARY_INTEGER;
17: type vptxn_res_assignment_id_tab is
18: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;
19: type vptxn_grouping_type_tab is
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;

Line 22: TABLE of pa_resource_assignments.unit_of_measure%TYPE index by BINARY_INTEGER;

18: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;
19: type vptxn_grouping_type_tab is
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;

Line 71: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE)

67: function Get_Rev_RV_Num return NUMBER;
68:
69: -- BUG FIX 2615852: need to recognize if all txn currencies entered for a ra
70: function all_txn_currencies_entered
71: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE)
72: return VARCHAR2;
73:
74: function get_task_name
75: (p_task_id IN pa_tasks.task_id%TYPE) return VARCHAR2;

Line 160: p_filter_task_id IN pa_resource_assignments.task_id%TYPE,

156: p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE,
157: p_both_version_id IN pa_budget_versions.budget_version_id%TYPE,
158: p_project_currency IN pa_projects_all.project_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

Line 162: p_filter_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,

158: p_project_currency IN pa_projects_all.project_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