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_PLANNING_RESOURCE_PUB dependencies on PA_NUM_TBL_TYPE

Line 138: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

134: * Further details specified in the Body.
135: ****************************************************************/
136: PROCEDURE Create_Planning_Resource(
137: p_resource_list_id IN VARCHAR2,
138: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
139: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
140: p_person_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
141: -- Bug 3593613
142: p_person_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,

Line 140: p_person_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

136: PROCEDURE Create_Planning_Resource(
137: p_resource_list_id IN VARCHAR2,
138: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
139: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
140: p_person_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
141: -- Bug 3593613
142: p_person_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
143: p_job_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
144: -- Bug 3593613

Line 143: p_job_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

139: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
140: p_person_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
141: -- Bug 3593613
142: p_person_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
143: p_job_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
144: -- Bug 3593613
145: p_job_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
146: p_organization_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
147: -- Bug 3593613

Line 146: p_organization_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

142: p_person_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
143: p_job_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
144: -- Bug 3593613
145: p_job_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
146: p_organization_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
147: -- Bug 3593613
148: p_organization_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
149: p_vendor_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
150: --Bug 3592496

Line 149: p_vendor_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

145: p_job_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
146: p_organization_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
147: -- Bug 3593613
148: p_organization_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
149: p_vendor_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
150: --Bug 3592496
151: p_vendor_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
152: p_fin_category_name IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
153: p_non_labor_resource IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,

Line 154: p_project_role_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

150: --Bug 3592496
151: p_vendor_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
152: p_fin_category_name IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
153: p_non_labor_resource IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
154: p_project_role_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
155: -- Bug 3593613
156: p_project_role_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
157: p_resource_class_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
158: p_resource_class_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,

Line 157: p_resource_class_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

153: p_non_labor_resource IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
154: p_project_role_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
155: -- Bug 3593613
156: p_project_role_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
157: p_resource_class_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
158: p_resource_class_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
159: p_res_format_id IN SYSTEM.PA_NUM_TBL_TYPE ,
160: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
161: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,

Line 159: p_res_format_id IN SYSTEM.PA_NUM_TBL_TYPE ,

155: -- Bug 3593613
156: p_project_role_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
157: p_resource_class_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
158: p_resource_class_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
159: p_res_format_id IN SYSTEM.PA_NUM_TBL_TYPE ,
160: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
161: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
162: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
163: p_copy_from_rl_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,

Line 160: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

156: p_project_role_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
157: p_resource_class_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
158: p_resource_class_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
159: p_res_format_id IN SYSTEM.PA_NUM_TBL_TYPE ,
160: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
161: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
162: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
163: p_copy_from_rl_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,
164: p_resource_class_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,

Line 162: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

158: p_resource_class_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
159: p_res_format_id IN SYSTEM.PA_NUM_TBL_TYPE ,
160: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
161: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
162: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
163: p_copy_from_rl_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,
164: p_resource_class_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,
165: p_fc_res_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
166: p_inventory_item_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

Line 166: p_inventory_item_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

162: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
163: p_copy_from_rl_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,
164: p_resource_class_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,
165: p_fc_res_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
166: p_inventory_item_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
167: -- Bug 3593613
168: p_inventory_item_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
169: p_item_category_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
170: p_item_category_name IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,

Line 169: p_item_category_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

165: p_fc_res_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
166: p_inventory_item_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
167: -- Bug 3593613
168: p_inventory_item_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
169: p_item_category_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
170: p_item_category_name IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
171: p_migration_code IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE ,
172: p_attribute_category IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
173: p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,

Line 204: p_bom_resource_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

200: p_attribute28 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
201: p_attribute29 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
202: p_attribute30 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
203: p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
204: p_bom_resource_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
205: p_bom_resource_name IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
206: p_team_role IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
207: --p_named_role IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
208: p_incur_by_res_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,

Line 213: x_resource_list_member_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,

209: p_incur_by_res_type IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
210: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
211: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
212: p_project_id IN NUMBER DEFAULT NULL,
213: x_resource_list_member_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
214: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
215: x_return_status OUT NOCOPY VARCHAR2 ,
216: x_msg_count OUT NOCOPY NUMBER ,
217: x_error_msg_data OUT NOCOPY VARCHAR2 );

Line 214: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,

210: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
211: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
212: p_project_id IN NUMBER DEFAULT NULL,
213: x_resource_list_member_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
214: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
215: x_return_status OUT NOCOPY VARCHAR2 ,
216: x_msg_count OUT NOCOPY NUMBER ,
217: x_error_msg_data OUT NOCOPY VARCHAR2 );
218:

Line 239: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE,

235: x_error_msg_data OUT NOCOPY VARCHAR2 );
236:
237: PROCEDURE Update_Planning_Resource(
238: p_resource_list_id IN NUMBER,
239: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE,
240: p_enabled_flag IN VARCHAR2,
241: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE ,
242: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
243: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,

Line 242: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

238: p_resource_list_id IN NUMBER,
239: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE,
240: p_enabled_flag IN VARCHAR2,
241: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE ,
242: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
243: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
244: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
245: p_attribute_category IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
246: p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,

Line 244: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

240: p_enabled_flag IN VARCHAR2,
241: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE ,
242: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
243: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
244: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
245: p_attribute_category IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
246: p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
247: p_attribute2 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
248: p_attribute3 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,

Line 276: p_record_version_number IN SYSTEM.PA_NUM_TBL_TYPE ,

272: p_attribute27 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
273: p_attribute28 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
274: p_attribute29 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
275: p_attribute30 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
276: p_record_version_number IN SYSTEM.PA_NUM_TBL_TYPE ,
277: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
278: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
279: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
280: x_return_status OUT NOCOPY VARCHAR2 ,

Line 279: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,

275: p_attribute30 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
276: p_record_version_number IN SYSTEM.PA_NUM_TBL_TYPE ,
277: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
278: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
279: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
280: x_return_status OUT NOCOPY VARCHAR2 ,
281: x_msg_count OUT NOCOPY NUMBER ,
282: x_error_msg_data OUT NOCOPY VARCHAR2 );
283:

Line 293: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE ,

289: * being used, else disable it.
290: * Further details in the Body.
291: ***************************************************/
292: PROCEDURE Delete_Planning_Resource(
293: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE ,
294: p_commit IN VARCHAR2,
295: p_init_msg_list IN VARCHAR2,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,