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_ACTIVITIES_PUB dependencies on GMD_OPERATION_ACTIVITIES

Line 1: PACKAGE BODY GMD_OPERATION_ACTIVITIES_PUB AS

1: PACKAGE BODY GMD_OPERATION_ACTIVITIES_PUB AS
2: /* $Header: GMDPOPAB.pls 120.0.12010000.2 2009/03/16 06:34:37 kannavar ship $
3: +=========================================================================+
4: | FILENAME |
5: | GMDPOPAB.pls |

Line 16: API Name : GMD_OPERATION_ACTIVITIES_PUB

12: | 21-AUG-2002 Sandra Dulyk Created |
13: | 20-FEB-2004 NSRIVAST Bug# 3222090 |
14: | Removed call to FND_PROFILE.VALUE('AFLOG_ENABLED')|
15: +=========================================================================+
16: API Name : GMD_OPERATION_ACTIVITIES_PUB
17: Type : Public
18: Function : This package contains public procedures used to create, modify, and delete operation activties
19: Pre-reqs : N/A
20: Parameters: Per function

Line 58: , p_oprn_activity IN OUT NOCOPY gmd_operation_activities%ROWTYPE

54: , p_init_msg_list IN BOOLEAN
55: , p_commit IN BOOLEAN
56: , p_oprn_no IN gmd_operations.oprn_no%TYPE
57: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
58: , p_oprn_activity IN OUT NOCOPY gmd_operation_activities%ROWTYPE
59: , p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type
60: , x_message_count OUT NOCOPY NUMBER
61: , x_message_list OUT NOCOPY VARCHAR2
62: , x_return_status OUT NOCOPY VARCHAR2) IS

Line 64: v_activity gmd_operation_activities.activity%TYPE;

60: , x_message_count OUT NOCOPY NUMBER
61: , x_message_list OUT NOCOPY VARCHAR2
62: , x_return_status OUT NOCOPY VARCHAR2) IS
63:
64: v_activity gmd_operation_activities.activity%TYPE;
65: v_oprn_line_Id gmd_operation_activities.oprn_line_id%TYPE;
66: v_oprn_id gmd_operation_activities.oprn_id%TYPE;
67: v_count NUMBER;
68:

Line 65: v_oprn_line_Id gmd_operation_activities.oprn_line_id%TYPE;

61: , x_message_list OUT NOCOPY VARCHAR2
62: , x_return_status OUT NOCOPY VARCHAR2) IS
63:
64: v_activity gmd_operation_activities.activity%TYPE;
65: v_oprn_line_Id gmd_operation_activities.oprn_line_id%TYPE;
66: v_oprn_id gmd_operation_activities.oprn_id%TYPE;
67: v_count NUMBER;
68:
69: l_retn_status VARCHAR2(1);

Line 66: v_oprn_id gmd_operation_activities.oprn_id%TYPE;

62: , x_return_status OUT NOCOPY VARCHAR2) IS
63:
64: v_activity gmd_operation_activities.activity%TYPE;
65: v_oprn_line_Id gmd_operation_activities.oprn_line_id%TYPE;
66: v_oprn_id gmd_operation_activities.oprn_id%TYPE;
67: v_count NUMBER;
68:
69: l_retn_status VARCHAR2(1);
70: l_api_version NUMBER := 1.0;

Line 90: CURSOR check_activity(v_activity gmd_operation_activities.activity%TYPE) IS

86: WHERE oprn_No = p_oprn_no
87: AND oprn_vers = p_oprn_vers
88: and delete_Mark = 0;
89:
90: CURSOR check_activity(v_activity gmd_operation_activities.activity%TYPE) IS
91: SELECT 1
92: FROM gmd_activities
93: WHERE activity = v_activity
94: and delete_mark = 0;

Line 126: ,'gmd_operation_activities_pub') THEN

122: /* Make sure we are call compatible */
123: IF NOT FND_API.compatible_api_call(l_api_version
124: ,p_api_version
125: ,'insert_operation_activity'
126: ,'gmd_operation_activities_pub') THEN
127: RAISE invalid_version;
128: END IF;
129:
130: /* Operation number ID must be passed, otherwise give error, also check operation exists */

Line 220: GMD_OPERATION_ACTIVITIES_PVT.insert_operation_activity(

216: gmd_debug.put_line('before PVT insert_oprn_activity routine called');
217: END IF;
218:
219: /* call insert operation activity routine using oprn_id */
220: GMD_OPERATION_ACTIVITIES_PVT.insert_operation_activity(
221: p_oprn_id => v_oprn_id,
222: p_oprn_activity => p_oprn_activity,
223: x_message_count => x_message_count,
224: x_message_list => x_message_list,

Line 290: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE

286: PROCEDURE update_operation_activity
287: ( p_api_version IN NUMBER
288: , p_init_msg_list IN BOOLEAN
289: , p_commit IN BOOLEAN
290: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
291: , p_update_table IN gmd_operation_activities_pub.update_tbl_type
292: , x_message_count OUT NOCOPY NUMBER
293: , x_message_list OUT NOCOPY VARCHAR2
294: , x_return_status OUT NOCOPY VARCHAR2) IS

Line 291: , p_update_table IN gmd_operation_activities_pub.update_tbl_type

287: ( p_api_version IN NUMBER
288: , p_init_msg_list IN BOOLEAN
289: , p_commit IN BOOLEAN
290: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
291: , p_update_table IN gmd_operation_activities_pub.update_tbl_type
292: , x_message_count OUT NOCOPY NUMBER
293: , x_message_list OUT NOCOPY VARCHAR2
294: , x_return_status OUT NOCOPY VARCHAR2) IS
295:

Line 304: CURSOR get_oprn_id(p_oprN_line_id gmd_operation_activities.oprn_line_id%TYPE) IS

300: invalid_version EXCEPTION;
301: setup_failure EXCEPTION;
302: upd_oprn_actv_err EXCEPTION;
303:
304: CURSOR get_oprn_id(p_oprN_line_id gmd_operation_activities.oprn_line_id%TYPE) IS
305: SELECT oprn_id
306: FROM gmd_operation_activities
307: WHERE oprn_line_id = p_oprn_line_id
308: AND delete_mark = 0;

Line 306: FROM gmd_operation_activities

302: upd_oprn_actv_err EXCEPTION;
303:
304: CURSOR get_oprn_id(p_oprN_line_id gmd_operation_activities.oprn_line_id%TYPE) IS
305: SELECT oprn_id
306: FROM gmd_operation_activities
307: WHERE oprn_line_id = p_oprn_line_id
308: AND delete_mark = 0;
309:
310: BEGIN

Line 332: ,'gmd_operation_activities_pub') THEN

328: /* Make sure we are call compatible */
329: IF NOT FND_API.compatible_api_call(l_api_version
330: ,p_api_version
331: ,'update_operation_activity'
332: ,'gmd_operation_activities_pub') THEN
333: RAISE invalid_version;
334: END IF;
335:
336: IF (l_debug = 'Y') THEN

Line 424: GMD_OPERATION_ACTIVITIES_PVT.update_operation_activity(p_oprn_line_id => p_oprn_line_id

420: END IF;
421: END LOOP;
422:
423: IF x_return_status = 'S' THEN
424: GMD_OPERATION_ACTIVITIES_PVT.update_operation_activity(p_oprn_line_id => p_oprn_line_id
425: , p_update_table => p_update_table
426: , x_message_count => x_message_count
427: , x_message_list => x_message_list
428: , x_return_status => l_retn_status);

Line 482: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE

478: PROCEDURE delete_operation_activity
479: ( p_api_version IN NUMBER
480: , p_init_msg_list IN BOOLEAN
481: , p_commit IN BOOLEAN
482: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
483: , x_message_count OUT NOCOPY NUMBER
484: , x_message_list OUT NOCOPY VARCHAR2
485: , x_return_status OUT NOCOPY VARCHAR2) IS
486:

Line 487: v_update_table gmd_operation_activities_pub.update_tbl_type;

483: , x_message_count OUT NOCOPY NUMBER
484: , x_message_list OUT NOCOPY VARCHAR2
485: , x_return_status OUT NOCOPY VARCHAR2) IS
486:
487: v_update_table gmd_operation_activities_pub.update_tbl_type;
488: v_count NUMBER;
489: l_retn_status VARCHAR2(1);
490: l_api_version NUMBER := 1.0;
491: l_oprn_id NUMBER(15);

Line 499: FROM gmd_operation_activities

495: del_oprn_actv_err EXCEPTION;
496:
497: CURSOR chk_oprn_line_id(v_oprN_line_id NUMBER) IS
498: SELECT oprn_id
499: FROM gmd_operation_activities
500: WHERE oprn_line_id = v_oprn_line_id;
501:
502: CURSOR get_activity_count (v_oprn_id NUMBER) IS
503: SELECT COUNT(1)

Line 504: FROM gmd_operation_activities a

500: WHERE oprn_line_id = v_oprn_line_id;
501:
502: CURSOR get_activity_count (v_oprn_id NUMBER) IS
503: SELECT COUNT(1)
504: FROM gmd_operation_activities a
505: WHERE a.oprn_id = v_oprn_id;
506:
507: BEGIN
508: SAVEPOINT delete_oprn_actv;

Line 530: ,'gmd_operation_activities_pvt') THEN

526: /* Make sure we are call compatible */
527: IF NOT FND_API.compatible_api_call(l_api_version
528: ,p_api_version
529: ,'delete_operation_activity'
530: ,'gmd_operation_activities_pvt') THEN
531: RAISE invalid_version;
532: END IF;
533:
534: IF (l_debug = 'Y') THEN

Line 577: gmd_operation_activities_pvt.delete_operation_activity

573: RAISE del_oprn_actv_err;
574: END IF;
575:
576: IF x_return_status = 'S' THEN
577: gmd_operation_activities_pvt.delete_operation_activity
578: (p_oprn_line_id => p_oprn_line_id
579: , x_message_count => x_message_count
580: , x_message_list => x_message_list
581: , x_return_status => l_retn_status);

Line 615: END GMD_OPERATION_ACTIVITIES_PUB;

611: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
612: P_data => x_message_list);
613: END delete_operation_activity;
614:
615: END GMD_OPERATION_ACTIVITIES_PUB;