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_PVT dependencies on GMD_OPERATION_RESOURCES

Line 1: PACKAGE BODY GMD_OPERATION_RESOURCES_PVT AS

1: PACKAGE BODY GMD_OPERATION_RESOURCES_PVT AS
2: /* $Header: GMDVOPRB.pls 120.0 2005/05/26 01:03:54 appldev noship $ */
3: /*
4: +=========================================================================+
5: | FILENAME |

Line 20: API Name : GMD_OPERATION_RESOURCES_PVT

16: | also added further validations |
17: | 20-FEB-2004 NSRIVAST Bug# 3222090,Removed call to |
18: | FND_PROFILE.VALUE('AFLOG_ENABLED') |
19: +=========================================================================+
20: API Name : GMD_OPERATION_RESOURCES_PVT
21: Type : Private
22: Function : This package contains private procedures used to create, modify, and delete operation resources
23: Pre-reqs : N/A
24: Parameters: Per function

Line 58: , p_oprn_rsrc_tbl IN GMD_OPERATION_RESOURCES_PUB.gmd_oprn_resources_tbl_type

54: Parameters
55: ================================================ */
56: PROCEDURE insert_operation_resources
57: (p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
58: , p_oprn_rsrc_tbl IN GMD_OPERATION_RESOURCES_PUB.gmd_oprn_resources_tbl_type
59: , x_message_count OUT NOCOPY NUMBER
60: , x_message_list OUT NOCOPY VARCHAR2
61: , x_return_status OUT NOCOPY VARCHAR2) IS
62:

Line 65: FROM gmd_operation_resources a, gmd_operation_activities b

61: , x_return_status OUT NOCOPY VARCHAR2) IS
62:
63: CURSOR Cur_check_resource (V_oprn_line_id NUMBER, V_resources VARCHAR2) IS
64: SELECT activity
65: FROM gmd_operation_resources a, gmd_operation_activities b
66: WHERE a.oprn_line_id = V_oprn_line_id
67: AND resources = V_resources
68: AND a.oprn_line_id = b.oprn_line_id;
69:

Line 108: insert into GMD_OPERATION_RESOURCES (

104: END IF;
105: CLOSE Cur_check_resource;
106:
107:
108: insert into GMD_OPERATION_RESOURCES (
109: OPRN_LINE_ID,
110: RESOURCES ,
111: RESOURCE_USAGE ,
112: RESOURCE_COUNT ,

Line 241: ( p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE

237: This particular procedure is used to update operation resources
238: Parameters
239: ================================================ */
240: PROCEDURE update_operation_resources
241: ( p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
242: , p_resources IN gmd_operation_resources.resources%TYPE
243: , p_update_table IN gmd_operation_resources_pub.update_tbl_type
244: , x_message_count OUT NOCOPY NUMBER
245: , x_message_list OUT NOCOPY VARCHAR2

Line 242: , p_resources IN gmd_operation_resources.resources%TYPE

238: Parameters
239: ================================================ */
240: PROCEDURE update_operation_resources
241: ( p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
242: , p_resources IN gmd_operation_resources.resources%TYPE
243: , p_update_table IN gmd_operation_resources_pub.update_tbl_type
244: , x_message_count OUT NOCOPY NUMBER
245: , x_message_list OUT NOCOPY VARCHAR2
246: , x_return_status OUT NOCOPY VARCHAR2) IS

Line 243: , p_update_table IN gmd_operation_resources_pub.update_tbl_type

239: ================================================ */
240: PROCEDURE update_operation_resources
241: ( p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
242: , p_resources IN gmd_operation_resources.resources%TYPE
243: , p_update_table IN gmd_operation_resources_pub.update_tbl_type
244: , x_message_count OUT NOCOPY NUMBER
245: , x_message_list OUT NOCOPY VARCHAR2
246: , x_return_status OUT NOCOPY VARCHAR2) IS
247:

Line 251: v_oprn_rsrc_update_rec gmd_operation_resources%ROWTYPE;

247:
248: l_mesg_count NUMBER;
249: l_mesg_list VARCHAR2(240);
250: l_retn_status VARCHAR2(1);
251: v_oprn_rsrc_update_rec gmd_operation_resources%ROWTYPE;
252: l_rsrc_usage varchar2(100);
253: setup_failure EXCEPTION;
254:
255: CURSOR get_resource_info(p_oprn_line_id gmd_operation_resources.oprn_line_id%TYPE , p_resources gmd_operation_resources.resources%TYPE) IS

Line 255: CURSOR get_resource_info(p_oprn_line_id gmd_operation_resources.oprn_line_id%TYPE , p_resources gmd_operation_resources.resources%TYPE) IS

251: v_oprn_rsrc_update_rec gmd_operation_resources%ROWTYPE;
252: l_rsrc_usage varchar2(100);
253: setup_failure EXCEPTION;
254:
255: CURSOR get_resource_info(p_oprn_line_id gmd_operation_resources.oprn_line_id%TYPE , p_resources gmd_operation_resources.resources%TYPE) IS
256: SELECT *
257: FROM gmd_operation_resources
258: WHERE oprn_line_id = p_oprn_line_id
259: AND resources = p_resources;

Line 257: FROM gmd_operation_resources

253: setup_failure EXCEPTION;
254:
255: CURSOR get_resource_info(p_oprn_line_id gmd_operation_resources.oprn_line_id%TYPE , p_resources gmd_operation_resources.resources%TYPE) IS
256: SELECT *
257: FROM gmd_operation_resources
258: WHERE oprn_line_id = p_oprn_line_id
259: AND resources = p_resources;
260:
261: BEGIN

Line 388: update GMD_OPERATION_RESOURCES

384:
385: gmd_debug.put_line('before update table - update_operation_rsrc private');
386: END IF;
387:
388: update GMD_OPERATION_RESOURCES
389: set RESOURCE_USAGE = v_oprn_rsrc_update_rec.resource_usage,
390: RESOURCES = v_oprn_rsrc_update_rec.resources,
391: RESOURCE_COUNT = v_oprn_rsrc_update_rec.resource_count,
392: resource_usage_uom = v_oprn_rsrc_update_rec.resource_usage_uom,

Line 467: ( p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE

463: This particular procedure is used to delete operation resources
464: Parameters
465: ================================================ */
466: PROCEDURE delete_operation_resource
467: ( p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
468: , p_resources IN gmd_operation_resources.resources%TYPE
469: , x_message_count OUT NOCOPY NUMBER
470: , x_message_list OUT NOCOPY VARCHAR2
471: , x_return_status OUT NOCOPY VARCHAR2) IS

Line 468: , p_resources IN gmd_operation_resources.resources%TYPE

464: Parameters
465: ================================================ */
466: PROCEDURE delete_operation_resource
467: ( p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
468: , p_resources IN gmd_operation_resources.resources%TYPE
469: , x_message_count OUT NOCOPY NUMBER
470: , x_message_list OUT NOCOPY VARCHAR2
471: , x_return_status OUT NOCOPY VARCHAR2) IS
472:

Line 495: DELETE from GMD_OPERATION_RESOURCES

491: IF (l_debug = 'Y') THEN
492: gmd_debug.put_line('START of delete_operation_resources PVT');
493: END IF;
494:
495: DELETE from GMD_OPERATION_RESOURCES
496: WHERE oprn_line_id = p_oprn_line_id
497: and resources = p_resources;
498:
499: IF (l_debug = 'Y') THEN

Line 518: END GMD_OPERATION_RESOURCES_PVT;

514:
515:
516: END delete_operation_resource;
517:
518: END GMD_OPERATION_RESOURCES_PVT;