DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_PUB dependencies on PA_VARCHAR2_80_TBL_TYPE

Line 139: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,

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

Line 156: p_project_role_name IN SYSTEM.PA_VARCHAR2_80_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,
159: p_res_format_id IN SYSTEM.PA_NUM_TBL_TYPE ,
160: p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,

Line 168: p_inventory_item_name IN SYSTEM.PA_VARCHAR2_80_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,
171: p_migration_code IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE ,
172: p_attribute_category IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,

Line 206: p_team_role IN SYSTEM.PA_VARCHAR2_80_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,
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,

Line 207: --p_named_role IN SYSTEM.PA_VARCHAR2_80_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,
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,

Line 241: p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE ,

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,
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,