187: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
188: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
189: ,p_incident_id IN NUMBER
190: ,p_object_name IN VARCHAR2
191: ,x_ext_attr_grp_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
192: ,x_ext_attr_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
193: ,x_return_status OUT NOCOPY VARCHAR2
194: ,x_msg_count OUT NOCOPY NUMBER
195: ,x_msg_data OUT NOCOPY VARCHAR2);
188: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
189: ,p_incident_id IN NUMBER
190: ,p_object_name IN VARCHAR2
191: ,x_ext_attr_grp_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
192: ,x_ext_attr_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
193: ,x_return_status OUT NOCOPY VARCHAR2
194: ,x_msg_count OUT NOCOPY NUMBER
195: ,x_msg_data OUT NOCOPY VARCHAR2);
196:
212: p_api_version IN NUMBER
213: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
214: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
215: ,p_incident_id IN NUMBER
216: ,p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
217: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
218: ,p_modified_by IN NUMBER := FND_GLOBAL.USER_ID
219: ,p_modified_on IN DATE := SYSDATE
220: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
213: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
214: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
215: ,p_incident_id IN NUMBER
216: ,p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
217: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
218: ,p_modified_by IN NUMBER := FND_GLOBAL.USER_ID
219: ,p_modified_on IN DATE := SYSDATE
220: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
221: ,x_return_status OUT NOCOPY VARCHAR2
249: -- This procedure is created to merge the group table and the attr. table in to one table structure.
250: -- -----------------------------------------------------------------------------
251:
252: Procedure Merge_Ext_Attrs_Details
253: (p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
254: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
255: ,x_ext_grp_attr_tbl OUT NOCOPY EXT_GRP_ATTR_TBL_TYPE
256: ,x_return_status OUT NOCOPY VARCHAR2
257: ,x_msg_count OUT NOCOPY NUMBER
250: -- -----------------------------------------------------------------------------
251:
252: Procedure Merge_Ext_Attrs_Details
253: (p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
254: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
255: ,x_ext_grp_attr_tbl OUT NOCOPY EXT_GRP_ATTR_TBL_TYPE
256: ,x_return_status OUT NOCOPY VARCHAR2
257: ,x_msg_count OUT NOCOPY NUMBER
258: ,x_msg_data OUT NOCOPY VARCHAR2);