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 47: ,pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --Bug 3231587

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

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

67: ,txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68: ,projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: ,projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE:=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70: ,projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
71: ,projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
72: ,projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
73: ,projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74: ,projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
75: ,projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

71: ,projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
72: ,projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
73: ,projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74: ,projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
75: ,projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
76: ,project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
77: ,project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78: ,project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
79: ,project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

75: ,projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
76: ,project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
77: ,project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78: ,project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
79: ,project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
80: ,project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
81: ,project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
82: ,project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
83: ,project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

79: ,project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
80: ,project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
81: ,project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
82: ,project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
83: ,project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
84: ,change_reason_code pa_budget_lines.change_reason_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
85: );
86:
87: TYPE budget_line_in_tbl_type IS TABLE OF budget_line_in_rec_type

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

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

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

88: INDEX BY BINARY_INTEGER;
89:
90: TYPE row_id_tbl_type IS TABLE OF rowid
91: INDEX BY BINARY_INTEGER;
92: TYPE budget_line_id_tbl_type IS TABLE OF pa_budget_lines.budget_line_id%TYPE
93: INDEX BY BINARY_INTEGER;
94: TYPE res_assignment_id_tbl_type IS TABLE OF pa_budget_lines.resource_assignment_id%TYPE
95: INDEX BY BINARY_INTEGER;
96: TYPE date_tbl_type IS TABLE OF pa_budget_lines.start_date%TYPE

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

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

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

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

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

94: TYPE res_assignment_id_tbl_type IS TABLE OF pa_budget_lines.resource_assignment_id%TYPE
95: INDEX BY BINARY_INTEGER;
96: TYPE date_tbl_type IS TABLE OF pa_budget_lines.start_date%TYPE
97: INDEX BY BINARY_INTEGER;
98: TYPE txn_currency_code_tbl_type IS TABLE OF pa_budget_lines.txn_currency_code%TYPE
99: INDEX BY BINARY_INTEGER;
100: TYPE period_name_tbl_type IS TABLE OF pa_budget_lines.period_name%TYPE
101: INDEX BY BINARY_INTEGER;
102: TYPE quantity_tbl_type IS TABLE OF pa_budget_lines.quantity%TYPE

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

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

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

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

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

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

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

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

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

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

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

106: TYPE raw_cost_tbl_type IS TABLE OF pa_budget_lines.raw_cost%TYPE
107: INDEX BY BINARY_INTEGER;
108: TYPE burdened_cost_tbl_type IS TABLE OF pa_budget_lines.burdened_cost%TYPE
109: INDEX BY BINARY_INTEGER;
110: TYPE revenue_tbl_type IS TABLE OF pa_budget_lines.revenue%TYPE
111: INDEX BY BINARY_INTEGER;
112: TYPE task_id_tbl_type IS TABLE OF pa_tasks.task_id%TYPE
113: INDEX BY BINARY_INTEGER;
114: TYPE resource_list_id_tbl_type IS TABLE OF pa_resource_list_members.resource_list_id%TYPE

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

165: ,TASK_ID NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
166: ,PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
167: ,PM_RES_ASGMT_REFERENCE VARCHAR2(30) DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
168: ,RESOURCE_ALIAS PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --bug 3711693
169: ,CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
170: ,UNIT_OF_MEASURE_CODE PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
171: ,START_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_START_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
172: ,END_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_END_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
173: ,QUANTITY NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

649: ,p_txn_currency_code IN pa_fp_txn_currencies.txn_currency_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
650: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
651: ,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
652: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
653: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
654: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
655: ,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
656: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
657: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

653: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
654: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
655: ,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
656: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
657: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
658: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
659: ,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
660: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
661: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

657: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
658: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
659: ,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
660: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
661: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
662: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
663: ,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
664: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
665: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

661: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
662: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
663: ,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
664: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
665: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
666: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
667: );
668:
669: /*#

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

662: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
663: ,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
664: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
665: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
666: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
667: );
668:
669: /*#
670: * 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 1261: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1257: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1258: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1259: ,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
1260: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1261: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1262: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1263: ,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
1264: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1265: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

1261: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1262: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1263: ,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
1264: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1265: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1266: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1267: ,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
1268: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1269: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

1265: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1266: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1267: ,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
1268: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1269: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1270: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1271: ,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
1272: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1273: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

1269: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1270: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1271: ,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
1272: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1273: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1274: /* Plan Amount Entry flags introduced by bug 6408139 */
1275: ,p_raw_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1276: ,p_burdened_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1277: ,p_revenue_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1399: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1400: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1401: ,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
1402: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1403: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1404: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1405: ,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
1406: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1407: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

1403: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1404: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1405: ,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
1406: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1407: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1408: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1409: ,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
1410: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1411: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

1407: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1408: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1409: ,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
1410: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1411: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1412: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1413: ,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
1414: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1415: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM );

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

1411: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1412: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1413: ,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
1414: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1415: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM );
1416:
1417: /*#
1418: * This API is used to update an existing budget line of a working budget in Oracle Projects for a given project and budget type.
1419: * @param p_api_version_number API standard: version number

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

2025: ,P_TASK_ID PA_TASKS.TASK_ID%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2026: ,P_PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2027: ,P_PM_RES_ASGMT_REFERENCE VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2028: ,P_RESOURCE_ALIAS VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2029: ,P_CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2030: ,P_UNIT_OF_MEASURE_CODE PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2031: ,P_START_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_START_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2032: ,P_END_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_END_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2033: ,P_QUANTITY NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM