eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_OPERATION_RESOURCES_PUB dependencies on GMD_OPERATION_RESOURCES

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 69: FROM gmd_operation_resources

65: AND delete_mark = 0;
66:
67: CURSOR check_Resource(p_oprn_line_id NUMBER, p_resources VARCHAR2) IS
68: SELECT 1
69: FROM gmd_operation_resources
70: WHERE oprn_line_id = p_oprn_line_id
71: AND resources = p_resources;
72:
73: CURSOR check_one_prim_rsrc (V_oprn_line_id NUMBER) IS

Line 75: FROM gmd_operation_resources

71: AND resources = p_resources;
72:
73: CURSOR check_one_prim_rsrc (V_oprn_line_id NUMBER) IS
74: SELECT COUNT(1)
75: FROM gmd_operation_resources
76: WHERE oprn_line_id = V_oprn_line_id
77: AND prim_rsrc_ind = 1;
78:
79: CURSOR check_atleast_one (V_oprn_line_id NUMBER, V_resources VARCHAR2) IS

Line 81: FROM gmd_operation_resources

77: AND prim_rsrc_ind = 1;
78:
79: CURSOR check_atleast_one (V_oprn_line_id NUMBER, V_resources VARCHAR2) IS
80: SELECT COUNT(1)
81: FROM gmd_operation_resources
82: WHERE oprn_line_id = V_oprn_line_id
83: AND (V_resources IS NULL OR resources <> V_resources)
84: AND prim_rsrc_ind = 1;
85:

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 119: v_resources gmd_operation_resources.resources%TYPE;

115: , x_message_count OUT NOCOPY NUMBER
116: , x_message_list OUT NOCOPY VARCHAR2
117: , x_return_status OUT NOCOPY VARCHAR2) IS
118:
119: v_resources gmd_operation_resources.resources%TYPE;
120: v_uom gmd_operation_resources.resource_usage_uom%TYPE;
121: v_cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%TYPE;
122: v_cost_analysis_code gmd_operation_resources.cost_analysis_code%TYPE;
123: v_count NUMBER DEFAULT 0;

Line 120: v_uom gmd_operation_resources.resource_usage_uom%TYPE;

116: , x_message_list OUT NOCOPY VARCHAR2
117: , x_return_status OUT NOCOPY VARCHAR2) IS
118:
119: v_resources gmd_operation_resources.resources%TYPE;
120: v_uom gmd_operation_resources.resource_usage_uom%TYPE;
121: v_cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%TYPE;
122: v_cost_analysis_code gmd_operation_resources.cost_analysis_code%TYPE;
123: v_count NUMBER DEFAULT 0;
124: l_return_status VARCHAR2(1);

Line 121: v_cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%TYPE;

117: , x_return_status OUT NOCOPY VARCHAR2) IS
118:
119: v_resources gmd_operation_resources.resources%TYPE;
120: v_uom gmd_operation_resources.resource_usage_uom%TYPE;
121: v_cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%TYPE;
122: v_cost_analysis_code gmd_operation_resources.cost_analysis_code%TYPE;
123: v_count NUMBER DEFAULT 0;
124: l_return_status VARCHAR2(1);
125: l_api_version NUMBER := 1.0;

Line 122: v_cost_analysis_code gmd_operation_resources.cost_analysis_code%TYPE;

118:
119: v_resources gmd_operation_resources.resources%TYPE;
120: v_uom gmd_operation_resources.resource_usage_uom%TYPE;
121: v_cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%TYPE;
122: v_cost_analysis_code gmd_operation_resources.cost_analysis_code%TYPE;
123: v_count NUMBER DEFAULT 0;
124: l_return_status VARCHAR2(1);
125: l_api_version NUMBER := 1.0;
126:

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 417: GMD_OPERATION_RESOURCES_PVT.insert_operation_resources(p_oprn_line_id => p_oprn_line_id,

413: IF (l_debug = 'Y') THEN
414: gmd_debug.put_line('before PVT routine called');
415: END IF;
416:
417: GMD_OPERATION_RESOURCES_PVT.insert_operation_resources(p_oprn_line_id => p_oprn_line_id,
418: p_oprn_rsrc_tbl => l_oprn_rsrc_tbl,
419: x_message_count => x_message_count,
420: x_message_list => x_message_list,
421: x_return_status => l_return_status);

Line 489: , p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE

485: PROCEDURE update_operation_resources
486: ( p_api_version IN NUMBER
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

Line 490: , p_resources IN gmd_operation_resources.resources%TYPE

486: ( p_api_version IN NUMBER
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

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 504: CURSOR get_oprn_id (p_oprN_line_id gmd_operation_resources.oprn_line_id%TYPE) IS

500:
501: invalid_version EXCEPTION;
502: setup_failure EXCEPTION;
503:
504: CURSOR get_oprn_id (p_oprN_line_id gmd_operation_resources.oprn_line_id%TYPE) IS
505: SELECT oprn_id
506: FROM gmd_operation_activities
507: WHERE oprn_line_id = p_oprn_line_id;
508:

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 700: GMD_OPERATION_RESOURCES_PVT.update_operation_resources(p_oprn_line_id => p_oprn_line_id

696: IF (l_debug = 'Y') THEN
697: gmd_debug.put_line('before PVT routine called');
698: END IF;
699:
700: GMD_OPERATION_RESOURCES_PVT.update_operation_resources(p_oprn_line_id => p_oprn_line_id
701: , p_resources => p_resources
702: , p_update_table => p_update_table
703: , x_message_count => x_message_count
704: , x_message_list => x_message_list

Line 753: , p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE

749: PROCEDURE delete_operation_resources
750: ( p_api_version IN NUMBER
751: , p_init_msg_list IN BOOLEAN
752: , p_commit IN BOOLEAN
753: , p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
754: , p_resources IN gmd_operation_resources.resources%TYPE
755: , x_message_count OUT NOCOPY NUMBER
756: , x_message_list OUT NOCOPY VARCHAR2
757: , x_return_status OUT NOCOPY VARCHAR2) IS

Line 754: , p_resources IN gmd_operation_resources.resources%TYPE

750: ( p_api_version IN NUMBER
751: , p_init_msg_list IN BOOLEAN
752: , p_commit IN BOOLEAN
753: , p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
754: , p_resources IN gmd_operation_resources.resources%TYPE
755: , x_message_count OUT NOCOPY NUMBER
756: , x_message_list OUT NOCOPY VARCHAR2
757: , x_return_status OUT NOCOPY VARCHAR2) IS
758:

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 777: FROM gmd_operation_resources

773: WHERE oprn_line_id = p_oprn_line_id;
774:
775: CURSOR check_Resource(p_oprn_line_id NUMBER, p_resources VARCHAR2) IS
776: SELECT 1
777: FROM gmd_operation_resources
778: WHERE oprn_line_id = p_oprn_line_id
779: AND resources = p_resources;
780:
781: CURSOR get_oprn_id (p_oprN_line_id gmd_operation_resources.oprn_line_id%TYPE) IS

Line 781: CURSOR get_oprn_id (p_oprN_line_id gmd_operation_resources.oprn_line_id%TYPE) IS

777: FROM gmd_operation_resources
778: WHERE oprn_line_id = p_oprn_line_id
779: AND resources = p_resources;
780:
781: CURSOR get_oprn_id (p_oprN_line_id gmd_operation_resources.oprn_line_id%TYPE) IS
782: SELECT oprn_id
783: FROM gmd_operation_activities
784: WHERE oprn_line_id = p_oprn_line_id;
785:

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 866: gmd_operation_resources_pvt.delete_operation_resource(p_oprn_line_id => p_oprn_line_id

862: /* Call PVT delete_operation_resources */
863: IF (l_debug = 'Y') THEN
864: gmd_debug.put_line('before call to delete_operation_resource PVT');
865: END IF;
866: gmd_operation_resources_pvt.delete_operation_resource(p_oprn_line_id => p_oprn_line_id
867: ,p_resources => p_resources
868: , x_message_count => x_message_count
869: , x_message_list => x_message_list
870: , x_return_status => l_return_status);

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;