DBA Data[Home] [Help]

APPS.GMD_OPERATION_RESOURCES_PUB dependencies on GMD_OPERATION_RESOURCES_PUB

Line 1: PACKAGE BODY GMD_OPERATION_RESOURCES_PUB AS

1: PACKAGE BODY GMD_OPERATION_RESOURCES_PUB AS
2: /* $Header: GMDPOPRB.pls 120.1.12010000.2 2008/11/06 21:48:32 rpatangy ship $
3: +=========================================================================+
4: | FILENAME |
5: | GMDPOPRB.pls |

Line 26: API Name : GMD_OPERATION_RESOURCES_PUB

22: | 26-MAY-2008 KBANDDYO Bug#7118558: column um_code is replaced |
23: | with uom_code and table sy_uoms_mst is |
24: | replaced with mtl_units_of_measure |
25: +=========================================================================+
26: API Name : GMD_OPERATION_RESOURCES_PUB
27: Type : Public
28: Function : This package contains public procedures used to create, modify, and delete operation resources
29: Pre-reqs : N/A
30: Parameters: Per function

Line 114: , p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type

110: ( p_api_version IN NUMBER
111: , p_init_msg_list IN BOOLEAN
112: , p_commit IN BOOLEAN
113: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
114: , p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type
115: , x_message_count OUT NOCOPY NUMBER
116: , x_message_list OUT NOCOPY VARCHAR2
117: , x_return_status OUT NOCOPY VARCHAR2) IS
118:

Line 166: l_oprn_rsrc_tbl gmd_operation_resources_pub.gmd_oprn_resources_tbl_type;

162: WHERE resources = V_resources;
163:
164: l_cost_cmpntcls_id cm_cmpt_mst.cost_cmpntcls_id%TYPE;
165: l_oprn_id NUMBER;
166: l_oprn_rsrc_tbl gmd_operation_resources_pub.gmd_oprn_resources_tbl_type;
167: l_rsrc_count NUMBER(5);
168: l_usage_uom VARCHAR2(4);
169: BEGIN
170: SAVEPOINT insert_oprn_rsrc;

Line 186: ,'gmd_operation_resources_pub') THEN

182: /* Make sure we are call compatible */
183: IF NOT FND_API.compatible_api_call(l_api_version
184: ,p_api_version
185: ,'insert_operation_resources'
186: ,'gmd_operation_resources_pub') THEN
187: RAISE invalid_version;
188: END IF;
189:
190: /* Initialize message list and count if needed */

Line 491: , p_update_table IN gmd_operation_resources_pub.update_tbl_type

487: , p_init_msg_list IN BOOLEAN
488: , p_commit IN BOOLEAN
489: , p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
490: , p_resources IN gmd_operation_resources.resources%TYPE
491: , p_update_table IN gmd_operation_resources_pub.update_tbl_type
492: , x_message_count OUT NOCOPY NUMBER
493: , x_message_list OUT NOCOPY VARCHAR2
494: , x_return_status OUT NOCOPY VARCHAR2) IS
495:

Line 520: ,'gmd_operation_resources_pub') THEN

516: /* Make sure we are call compatible */
517: IF NOT FND_API.compatible_api_call(l_api_version
518: ,p_api_version
519: ,'update_operation_resources'
520: ,'gmd_operation_resources_pub') THEN
521: RAISE invalid_version;
522: END IF;
523:
524: /* Initialize message list and count if needed */

Line 759: v_update_table gmd_operation_resources_pub.update_tbl_type;

755: , x_message_count OUT NOCOPY NUMBER
756: , x_message_list OUT NOCOPY VARCHAR2
757: , x_return_status OUT NOCOPY VARCHAR2) IS
758:
759: v_update_table gmd_operation_resources_pub.update_tbl_type;
760: v_count NUMBER;
761: l_return_status VARCHAR2(1);
762: l_api_version NUMBER := 1.0;
763: v_oprn_id NUMBER;

Line 801: ,'gmd_operation_resources_pub') THEN

797: /* Make sure we are call compatible */
798: IF NOT FND_API.compatible_api_call(l_api_version
799: ,p_api_version
800: ,'delete_operation_resources'
801: ,'gmd_operation_resources_pub') THEN
802: RAISE invalid_version;
803: END IF;
804:
805: IF NOT gmd_api_grp.setup_done THEN

Line 918: END GMD_OPERATION_RESOURCES_PUB;

914: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
915: P_data => x_message_list);
916: END delete_operation_resources;
917:
918: END GMD_OPERATION_RESOURCES_PUB;