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 148: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

144: * Calls Prog : pa_Planning_resource_pvt.Create_Planning_Resource
145: ****************************************************************/
146: PROCEDURE Create_Planning_Resource(
147: p_resource_list_id IN VARCHAR2,
148: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
149: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
150: p_person_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
151: --Bug 3593613
152: p_person_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,

Line 150: p_person_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

146: PROCEDURE Create_Planning_Resource(
147: p_resource_list_id IN VARCHAR2,
148: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
149: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
150: p_person_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
151: --Bug 3593613
152: p_person_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
153: p_job_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
154: -- Bug 3593613

Line 153: p_job_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

149: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
150: p_person_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
151: --Bug 3593613
152: p_person_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
153: p_job_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
154: -- Bug 3593613
155: p_job_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
156: p_organization_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
157: p_organization_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,

Line 156: p_organization_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

152: p_person_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
153: p_job_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
154: -- Bug 3593613
155: p_job_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
156: p_organization_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
157: p_organization_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
158: p_vendor_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
159: --Bug 3592496
160: p_vendor_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,

Line 158: p_vendor_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

154: -- Bug 3593613
155: p_job_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
156: p_organization_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
157: p_organization_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
158: p_vendor_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
159: --Bug 3592496
160: p_vendor_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
161: p_fin_category_name IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
162: p_non_labor_resource IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,

Line 163: p_project_role_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

159: --Bug 3592496
160: p_vendor_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
161: p_fin_category_name IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
162: p_non_labor_resource IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
163: p_project_role_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
164: p_project_role_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
165: p_resource_class_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
166: p_resource_class_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
167: p_res_format_id IN SYSTEM.PA_NUM_TBL_TYPE ,

Line 165: p_resource_class_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

161: p_fin_category_name IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
162: p_non_labor_resource IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
163: p_project_role_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
164: p_project_role_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
165: p_resource_class_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
166: p_resource_class_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
167: p_res_format_id IN SYSTEM.PA_NUM_TBL_TYPE ,
168: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
169: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,

Line 167: p_res_format_id IN SYSTEM.PA_NUM_TBL_TYPE ,

163: p_project_role_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
164: p_project_role_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
165: p_resource_class_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
166: p_resource_class_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
167: p_res_format_id IN SYSTEM.PA_NUM_TBL_TYPE ,
168: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
169: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
170: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
171: p_copy_from_rl_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,

Line 168: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

164: p_project_role_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
165: p_resource_class_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
166: p_resource_class_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
167: p_res_format_id IN SYSTEM.PA_NUM_TBL_TYPE ,
168: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
169: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
170: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
171: p_copy_from_rl_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,
172: p_resource_class_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,

Line 170: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

166: p_resource_class_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
167: p_res_format_id IN SYSTEM.PA_NUM_TBL_TYPE ,
168: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
169: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
170: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
171: p_copy_from_rl_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,
172: p_resource_class_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,
173: p_fc_res_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
174: p_inventory_item_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

Line 174: p_inventory_item_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

170: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
171: p_copy_from_rl_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,
172: p_resource_class_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,
173: p_fc_res_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
174: p_inventory_item_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
175: p_inventory_item_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
176: p_item_category_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
177: p_item_category_name IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
178: p_migration_code IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE ,

Line 176: p_item_category_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

172: p_resource_class_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,
173: p_fc_res_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
174: p_inventory_item_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
175: p_inventory_item_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
176: p_item_category_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
177: p_item_category_name IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
178: p_migration_code IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE ,
179: p_attribute_category IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
180: p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,

Line 211: p_bom_resource_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

207: p_attribute28 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
208: p_attribute29 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
209: p_attribute30 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
210: p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
211: p_bom_resource_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
212: p_bom_resource_name IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
213: p_team_role IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
214: p_incur_by_res_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
215: p_incur_by_res_type IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,

Line 219: x_resource_list_member_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,

215: p_incur_by_res_type IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
216: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
217: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
218: p_project_id IN NUMBER DEFAULT NULL,
219: x_resource_list_member_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
220: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
221: x_return_status OUT NOCOPY VARCHAR2 ,
222: x_msg_count OUT NOCOPY NUMBER ,
223: x_error_msg_data OUT NOCOPY VARCHAR2 )

Line 220: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,

216: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
217: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
218: p_project_id IN NUMBER DEFAULT NULL,
219: x_resource_list_member_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
220: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
221: x_return_status OUT NOCOPY VARCHAR2 ,
222: x_msg_count OUT NOCOPY NUMBER ,
223: x_error_msg_data OUT NOCOPY VARCHAR2 )
224: IS

Line 226: x_record_version_number := SYSTEM.PA_NUM_TBL_TYPE();

222: x_msg_count OUT NOCOPY NUMBER ,
223: x_error_msg_data OUT NOCOPY VARCHAR2 )
224: IS
225: BEGIN
226: x_record_version_number := SYSTEM.PA_NUM_TBL_TYPE();
227: x_resource_list_member_id := SYSTEM.PA_NUM_TBL_TYPE();
228: x_record_version_number.extend(p_res_format_id.count) ;
229: x_resource_list_member_id.extend(p_res_format_id.count) ;
230:

Line 227: x_resource_list_member_id := SYSTEM.PA_NUM_TBL_TYPE();

223: x_error_msg_data OUT NOCOPY VARCHAR2 )
224: IS
225: BEGIN
226: x_record_version_number := SYSTEM.PA_NUM_TBL_TYPE();
227: x_resource_list_member_id := SYSTEM.PA_NUM_TBL_TYPE();
228: x_record_version_number.extend(p_res_format_id.count) ;
229: x_resource_list_member_id.extend(p_res_format_id.count) ;
230:
231: -- First clear the message stack.

Line 445: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE,

441: /************************************/
442:
443: PROCEDURE Update_Planning_Resource(
444: p_resource_list_id IN NUMBER,
445: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE,
446: p_enabled_flag IN VARCHAR2,
447: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE ,
448: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
449: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,

Line 448: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

444: p_resource_list_id IN NUMBER,
445: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE,
446: p_enabled_flag IN VARCHAR2,
447: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE ,
448: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
449: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
450: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
451: p_attribute_category IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
452: p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,

Line 450: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

446: p_enabled_flag IN VARCHAR2,
447: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE ,
448: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
449: p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
450: p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
451: p_attribute_category IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
452: p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
453: p_attribute2 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
454: p_attribute3 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,

Line 482: p_record_version_number IN SYSTEM.PA_NUM_TBL_TYPE ,

478: p_attribute27 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
479: p_attribute28 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
480: p_attribute29 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
481: p_attribute30 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
482: p_record_version_number IN SYSTEM.PA_NUM_TBL_TYPE ,
483: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
484: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
485: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
486: x_return_status OUT NOCOPY VARCHAR2 ,

Line 485: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,

481: p_attribute30 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
482: p_record_version_number IN SYSTEM.PA_NUM_TBL_TYPE ,
483: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
484: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
485: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
486: x_return_status OUT NOCOPY VARCHAR2 ,
487: x_msg_count OUT NOCOPY NUMBER ,
488: x_error_msg_data OUT NOCOPY VARCHAR2 )
489: IS

Line 496: x_record_version_number := SYSTEM.PA_NUM_TBL_TYPE();

492: IF FND_API.to_boolean( p_init_msg_list )
493: THEN
494: FND_MSG_PUB.initialize;
495: END IF;
496: x_record_version_number := SYSTEM.PA_NUM_TBL_TYPE();
497: x_record_version_number.extend(p_resource_list_member_id.count) ;
498:
499: /***************************************************************
500: * For Loop. To loop through the table of records and

Line 576: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE,

572: * Further details in the Body.
573: * Calls prog : pa_planning_resource_pub.delete_row
574: ***************************************************/
575: PROCEDURE Delete_Planning_Resource(
576: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE,
577: p_commit IN VARCHAR2,
578: p_init_msg_list IN VARCHAR2,
579: x_return_status OUT NOCOPY VARCHAR2,
580: x_msg_count OUT NOCOPY NUMBER,