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 155: * This API inserts a row in Plant Resource table (cr_rsrc_dtl)

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

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

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

Line 250: , p_resources IN cr_rsrc_dtl%ROWTYPE

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

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

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

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

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

Line 356: , p_organization_id IN cr_rsrc_dtl.organization_id%TYPE

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

Line 357: , p_resources IN cr_rsrc_dtl.resources%TYPE

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