APPS.GMP_RESOURCE_DTL_PUB dependencies on CR_RSRC_DTL

Line 62: * resource table - cr_rsrc_dtl

58:
59: /*#
60: * API for INSERT_RESOURCE_DTL
61: * This API to craete a new plant resource i.e. to insert a row in the plant
62: * resource table - cr_rsrc_dtl
63: * @param p_api_version Version Number of the API
64: * @param p_init_msg_list Flag for initializing message list BOOLEAN
65: * @param p_commit This is the commmit flag BOOLEAN.
66: * @param p_resources This is the information about the resource to be created

Line 67: * in the prescribed format - row type of cr_rsrc_dtl table.

63: * @param p_api_version Version Number of the API
64: * @param p_init_msg_list Flag for initializing message list BOOLEAN
65: * @param p_commit This is the commmit flag BOOLEAN.
66: * @param p_resources This is the information about the resource to be created
67: * in the prescribed format - row type of cr_rsrc_dtl table.
68: * @param p_rsrc_instances This is the information about the instances of the
69: * resource being created
70: * @param x_message_count Number of messages on message stack
71: * @param x_message_list Actual message data from message stack

Line 82: , p_resources IN cr_rsrc_dtl%ROWTYPE

78: PROCEDURE insert_resource_dtl
79: ( p_api_version IN NUMBER := 1
80: , p_init_msg_list IN BOOLEAN := TRUE
81: , p_commit IN BOOLEAN := FALSE
82: , p_resources IN cr_rsrc_dtl%ROWTYPE
83: , p_rsrc_instances IN resource_instances_tbl
84: , x_message_count OUT NOCOPY NUMBER
85: , x_message_list OUT NOCOPY VARCHAR2
86: , x_return_status IN OUT NOCOPY VARCHAR2

Line 157: * This API inserts a row in Plant Resource table (cr_rsrc_dtl)

153: );
154:
155: /*#
156: * API for INSERT_DETAIL_ROWS
157: * This API inserts a row in Plant Resource table (cr_rsrc_dtl)
158: * @param p_organization_id This is the Inventory Organization to which the Resource is Associated
159: * @param p_resources This is the Resource that needs to be inserted into the
160: * table.
161: * @param p_group_resource Resource Group - Resource can be grouped by this

Line 235: * This API updates a Plant Resource ie. a row in table cr_rsrc_dtl.

231: );
232:
233: /*#
234: * API for UPDATE_RESOURCE_DTL
235: * This API updates a Plant Resource ie. a row in table cr_rsrc_dtl.
236: * @param p_api_version Version Number of the API
237: * @param p_init_msg_list Flag for initializing message list BOOLEAN
238: * @param p_commit This is the commmit flag BOOLEAN.
239: * @param p_resources This is the resource information that needs to be updated

Line 253: , p_resources IN cr_rsrc_dtl%ROWTYPE

249: PROCEDURE update_resource_dtl
250: ( p_api_version IN NUMBER := 1
251: , p_init_msg_list IN BOOLEAN := TRUE
252: , p_commit IN BOOLEAN := FALSE
253: , p_resources IN cr_rsrc_dtl%ROWTYPE
254: , x_message_count OUT NOCOPY NUMBER
255: , x_message_list OUT NOCOPY VARCHAR2
256: , x_return_status OUT NOCOPY VARCHAR2
257: ) ;

Line 261: * This API updates a row in Plant Resource table (cr_rsrc_dtl)

257: ) ;
258:
259: /*#
260: * API for UPDATE_DETAIL_ROWS
261: * This API updates a row in Plant Resource table (cr_rsrc_dtl)
262: * @param p_organization_id This is the Inventory Organization to which the Resource is Associated
263: * @param p_resources This is the Resource that is to be updated .
264: * @param p_group_resource Resource Group - Resource can be grouped by this
265: * type

Line 342: * This API Deletes a row in Plant Resource table (cr_rsrc_dtl)

338: ) ;
339:
340: /*#
341: * API for DELETE_RESOURCES
342: * This API Deletes a row in Plant Resource table (cr_rsrc_dtl)
343: * @param p_api_version Version Number of the API
344: * @param p_init_msg_list Flag for initializing message list BOOLEAN
345: * @param p_commit This is the commmit flag BOOLEAN.
346: * @param p_organization_id This is the Inventory Organization to which the Resource is Associated

Line 360: , p_organization_id IN cr_rsrc_dtl.organization_id%TYPE

356: PROCEDURE delete_resources
357: ( p_api_version IN NUMBER := 1
358: , p_init_msg_list IN BOOLEAN := TRUE
359: , p_commit IN BOOLEAN := FALSE
360: , p_organization_id IN cr_rsrc_dtl.organization_id%TYPE
361: , p_resources IN cr_rsrc_dtl.resources%TYPE
362: , x_message_count OUT NOCOPY NUMBER
363: , x_message_list OUT NOCOPY VARCHAR2
364: , x_return_status OUT NOCOPY VARCHAR2

Line 361: , p_resources IN cr_rsrc_dtl.resources%TYPE

357: ( p_api_version IN NUMBER := 1
358: , p_init_msg_list IN BOOLEAN := TRUE
359: , p_commit IN BOOLEAN := FALSE
360: , p_organization_id IN cr_rsrc_dtl.organization_id%TYPE
361: , p_resources IN cr_rsrc_dtl.resources%TYPE
362: , x_message_count OUT NOCOPY NUMBER
363: , x_message_list OUT NOCOPY VARCHAR2
364: , x_return_status OUT NOCOPY VARCHAR2
365: );