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_BUDGET_PUB dependencies on PA_BUDGET_LINES

Line 51: ,pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --Bug 3231587

47: ,burdened_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
48: ,revenue NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
49: ,quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50: ,pm_product_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: ,pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --Bug 3231587
52: ,attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53: ,attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54: ,attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: ,attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 75: ,projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

71: ,txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72: ,projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
73: ,projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE:=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74: ,projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
75: ,projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
76: ,projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
77: ,projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78: ,projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
79: ,projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 79: ,projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

75: ,projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
76: ,projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
77: ,projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78: ,projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
79: ,projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
80: ,project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
81: ,project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
82: ,project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
83: ,project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 83: ,project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

79: ,projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
80: ,project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
81: ,project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
82: ,project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
83: ,project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
84: ,project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
85: ,project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
86: ,project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
87: ,project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 87: ,project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

83: ,project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
84: ,project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
85: ,project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
86: ,project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
87: ,project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
88: ,change_reason_code pa_budget_lines.change_reason_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
89: );
90:
91: TYPE budget_line_in_tbl_type IS TABLE OF budget_line_in_rec_type

Line 88: ,change_reason_code pa_budget_lines.change_reason_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

84: ,project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
85: ,project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
86: ,project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
87: ,project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
88: ,change_reason_code pa_budget_lines.change_reason_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
89: );
90:
91: TYPE budget_line_in_tbl_type IS TABLE OF budget_line_in_rec_type
92: INDEX BY BINARY_INTEGER;

Line 96: TYPE budget_line_id_tbl_type IS TABLE OF pa_budget_lines.budget_line_id%TYPE

92: INDEX BY BINARY_INTEGER;
93:
94: TYPE row_id_tbl_type IS TABLE OF rowid
95: INDEX BY BINARY_INTEGER;
96: TYPE budget_line_id_tbl_type IS TABLE OF pa_budget_lines.budget_line_id%TYPE
97: INDEX BY BINARY_INTEGER;
98: TYPE res_assignment_id_tbl_type IS TABLE OF pa_budget_lines.resource_assignment_id%TYPE
99: INDEX BY BINARY_INTEGER;
100: TYPE date_tbl_type IS TABLE OF pa_budget_lines.start_date%TYPE

Line 98: TYPE res_assignment_id_tbl_type IS TABLE OF pa_budget_lines.resource_assignment_id%TYPE

94: TYPE row_id_tbl_type IS TABLE OF rowid
95: INDEX BY BINARY_INTEGER;
96: TYPE budget_line_id_tbl_type IS TABLE OF pa_budget_lines.budget_line_id%TYPE
97: INDEX BY BINARY_INTEGER;
98: TYPE res_assignment_id_tbl_type IS TABLE OF pa_budget_lines.resource_assignment_id%TYPE
99: INDEX BY BINARY_INTEGER;
100: TYPE date_tbl_type IS TABLE OF pa_budget_lines.start_date%TYPE
101: INDEX BY BINARY_INTEGER;
102: TYPE txn_currency_code_tbl_type IS TABLE OF pa_budget_lines.txn_currency_code%TYPE

Line 100: TYPE date_tbl_type IS TABLE OF pa_budget_lines.start_date%TYPE

96: TYPE budget_line_id_tbl_type IS TABLE OF pa_budget_lines.budget_line_id%TYPE
97: INDEX BY BINARY_INTEGER;
98: TYPE res_assignment_id_tbl_type IS TABLE OF pa_budget_lines.resource_assignment_id%TYPE
99: INDEX BY BINARY_INTEGER;
100: TYPE date_tbl_type IS TABLE OF pa_budget_lines.start_date%TYPE
101: INDEX BY BINARY_INTEGER;
102: TYPE txn_currency_code_tbl_type IS TABLE OF pa_budget_lines.txn_currency_code%TYPE
103: INDEX BY BINARY_INTEGER;
104: TYPE period_name_tbl_type IS TABLE OF pa_budget_lines.period_name%TYPE

Line 102: TYPE txn_currency_code_tbl_type IS TABLE OF pa_budget_lines.txn_currency_code%TYPE

98: TYPE res_assignment_id_tbl_type IS TABLE OF pa_budget_lines.resource_assignment_id%TYPE
99: INDEX BY BINARY_INTEGER;
100: TYPE date_tbl_type IS TABLE OF pa_budget_lines.start_date%TYPE
101: INDEX BY BINARY_INTEGER;
102: TYPE txn_currency_code_tbl_type IS TABLE OF pa_budget_lines.txn_currency_code%TYPE
103: INDEX BY BINARY_INTEGER;
104: TYPE period_name_tbl_type IS TABLE OF pa_budget_lines.period_name%TYPE
105: INDEX BY BINARY_INTEGER;
106: TYPE quantity_tbl_type IS TABLE OF pa_budget_lines.quantity%TYPE

Line 104: TYPE period_name_tbl_type IS TABLE OF pa_budget_lines.period_name%TYPE

100: TYPE date_tbl_type IS TABLE OF pa_budget_lines.start_date%TYPE
101: INDEX BY BINARY_INTEGER;
102: TYPE txn_currency_code_tbl_type IS TABLE OF pa_budget_lines.txn_currency_code%TYPE
103: INDEX BY BINARY_INTEGER;
104: TYPE period_name_tbl_type IS TABLE OF pa_budget_lines.period_name%TYPE
105: INDEX BY BINARY_INTEGER;
106: TYPE quantity_tbl_type IS TABLE OF pa_budget_lines.quantity%TYPE
107: INDEX BY BINARY_INTEGER;
108: TYPE display_quantity_tbl_type IS TABLE OF pa_budget_lines.display_quantity%TYPE --IPM Arch Enhancement Bug 4865563

Line 106: TYPE quantity_tbl_type IS TABLE OF pa_budget_lines.quantity%TYPE

102: TYPE txn_currency_code_tbl_type IS TABLE OF pa_budget_lines.txn_currency_code%TYPE
103: INDEX BY BINARY_INTEGER;
104: TYPE period_name_tbl_type IS TABLE OF pa_budget_lines.period_name%TYPE
105: INDEX BY BINARY_INTEGER;
106: TYPE quantity_tbl_type IS TABLE OF pa_budget_lines.quantity%TYPE
107: INDEX BY BINARY_INTEGER;
108: TYPE display_quantity_tbl_type IS TABLE OF pa_budget_lines.display_quantity%TYPE --IPM Arch Enhancement Bug 4865563
109: INDEX BY BINARY_INTEGER;
110: TYPE raw_cost_tbl_type IS TABLE OF pa_budget_lines.raw_cost%TYPE

Line 108: TYPE display_quantity_tbl_type IS TABLE OF pa_budget_lines.display_quantity%TYPE --IPM Arch Enhancement Bug 4865563

104: TYPE period_name_tbl_type IS TABLE OF pa_budget_lines.period_name%TYPE
105: INDEX BY BINARY_INTEGER;
106: TYPE quantity_tbl_type IS TABLE OF pa_budget_lines.quantity%TYPE
107: INDEX BY BINARY_INTEGER;
108: TYPE display_quantity_tbl_type IS TABLE OF pa_budget_lines.display_quantity%TYPE --IPM Arch Enhancement Bug 4865563
109: INDEX BY BINARY_INTEGER;
110: TYPE raw_cost_tbl_type IS TABLE OF pa_budget_lines.raw_cost%TYPE
111: INDEX BY BINARY_INTEGER;
112: TYPE burdened_cost_tbl_type IS TABLE OF pa_budget_lines.burdened_cost%TYPE

Line 110: TYPE raw_cost_tbl_type IS TABLE OF pa_budget_lines.raw_cost%TYPE

106: TYPE quantity_tbl_type IS TABLE OF pa_budget_lines.quantity%TYPE
107: INDEX BY BINARY_INTEGER;
108: TYPE display_quantity_tbl_type IS TABLE OF pa_budget_lines.display_quantity%TYPE --IPM Arch Enhancement Bug 4865563
109: INDEX BY BINARY_INTEGER;
110: TYPE raw_cost_tbl_type IS TABLE OF pa_budget_lines.raw_cost%TYPE
111: INDEX BY BINARY_INTEGER;
112: TYPE burdened_cost_tbl_type IS TABLE OF pa_budget_lines.burdened_cost%TYPE
113: INDEX BY BINARY_INTEGER;
114: TYPE revenue_tbl_type IS TABLE OF pa_budget_lines.revenue%TYPE

Line 112: TYPE burdened_cost_tbl_type IS TABLE OF pa_budget_lines.burdened_cost%TYPE

108: TYPE display_quantity_tbl_type IS TABLE OF pa_budget_lines.display_quantity%TYPE --IPM Arch Enhancement Bug 4865563
109: INDEX BY BINARY_INTEGER;
110: TYPE raw_cost_tbl_type IS TABLE OF pa_budget_lines.raw_cost%TYPE
111: INDEX BY BINARY_INTEGER;
112: TYPE burdened_cost_tbl_type IS TABLE OF pa_budget_lines.burdened_cost%TYPE
113: INDEX BY BINARY_INTEGER;
114: TYPE revenue_tbl_type IS TABLE OF pa_budget_lines.revenue%TYPE
115: INDEX BY BINARY_INTEGER;
116: TYPE task_id_tbl_type IS TABLE OF pa_tasks.task_id%TYPE

Line 114: TYPE revenue_tbl_type IS TABLE OF pa_budget_lines.revenue%TYPE

110: TYPE raw_cost_tbl_type IS TABLE OF pa_budget_lines.raw_cost%TYPE
111: INDEX BY BINARY_INTEGER;
112: TYPE burdened_cost_tbl_type IS TABLE OF pa_budget_lines.burdened_cost%TYPE
113: INDEX BY BINARY_INTEGER;
114: TYPE revenue_tbl_type IS TABLE OF pa_budget_lines.revenue%TYPE
115: INDEX BY BINARY_INTEGER;
116: TYPE task_id_tbl_type IS TABLE OF pa_tasks.task_id%TYPE
117: INDEX BY BINARY_INTEGER;
118: TYPE resource_list_id_tbl_type IS TABLE OF pa_resource_list_members.resource_list_id%TYPE

Line 178: ,CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

174: ,TASK_ID NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
175: ,PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
176: ,PM_RES_ASGMT_REFERENCE VARCHAR2(30) DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
177: ,RESOURCE_ALIAS PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --bug 3711693
178: ,CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
179: ,UNIT_OF_MEASURE_CODE PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
180: ,START_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_START_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
181: ,END_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_END_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
182: ,QUANTITY NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 681: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

677: ,p_txn_currency_code IN pa_fp_txn_currencies.txn_currency_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
678: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
679: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
680: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
681: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
682: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
683: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
684: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
685: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 685: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

681: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
682: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
683: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
684: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
685: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
686: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
687: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
688: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
689: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 689: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

685: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
686: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
687: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
688: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
689: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
690: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
691: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
693: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 693: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

689: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
690: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
691: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
693: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
694: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
695: );
696:
697: /*#

Line 694: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

690: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
691: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
692: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
693: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
694: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
695: );
696:
697: /*#
698: * This API is used to create a budget and its budget lines using the data stored in the global tables during the load process.

Line 1301: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1297: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1298: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1299: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1300: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1301: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1302: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1303: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1304: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1305: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1305: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1301: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1302: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1303: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1304: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1305: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1306: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1307: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1308: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1309: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1309: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1305: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1306: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1307: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1308: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1309: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1310: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1311: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1312: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1313: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1313: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1309: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1310: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1311: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1312: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1313: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1314: /* Plan Amount Entry flags introduced by bug 6408139 */
1315: ,p_raw_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1316: ,p_burdened_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1317: ,p_revenue_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 1443: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1439: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1440: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1441: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1442: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1443: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1444: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1445: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1446: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1447: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1447: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1443: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1444: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1445: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1446: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1447: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1448: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1449: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1450: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1451: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1451: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1447: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1448: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1449: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1450: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1451: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1452: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1453: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1454: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1455: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM );

Line 1455: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM );

1451: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1452: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1453: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1454: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1455: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM );
1456:
1457: /*#
1458: * This API is used to update an existing budget line of a working budget in Oracle Projects for a given project and budget type.
1459: * @param p_api_version_number API standard: version number

Line 2080: ,P_CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2076: ,P_TASK_ID PA_TASKS.TASK_ID%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2077: ,P_PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2078: ,P_PM_RES_ASGMT_REFERENCE VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2079: ,P_RESOURCE_ALIAS VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2080: ,P_CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2081: ,P_UNIT_OF_MEASURE_CODE PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2082: ,P_START_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_START_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2083: ,P_END_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_END_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2084: ,P_QUANTITY NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM