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 2005/05/25 19:17:14 appldev noship $
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 284: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE

280: PROCEDURE update_operation_activity
281: ( p_api_version IN NUMBER
282: , p_init_msg_list IN BOOLEAN
283: , p_commit IN BOOLEAN
284: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
285: , p_update_table IN gmd_operation_activities_pub.update_tbl_type
286: , x_message_count OUT NOCOPY NUMBER
287: , x_message_list OUT NOCOPY VARCHAR2
288: , x_return_status OUT NOCOPY VARCHAR2) IS

Line 285: , p_update_table IN gmd_operation_activities_pub.update_tbl_type

281: ( p_api_version IN NUMBER
282: , p_init_msg_list IN BOOLEAN
283: , p_commit IN BOOLEAN
284: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
285: , p_update_table IN gmd_operation_activities_pub.update_tbl_type
286: , x_message_count OUT NOCOPY NUMBER
287: , x_message_list OUT NOCOPY VARCHAR2
288: , x_return_status OUT NOCOPY VARCHAR2) IS
289:

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

294: invalid_version EXCEPTION;
295: setup_failure EXCEPTION;
296: upd_oprn_actv_err EXCEPTION;
297:
298: CURSOR get_oprn_id(p_oprN_line_id gmd_operation_activities.oprn_line_id%TYPE) IS
299: SELECT oprn_id
300: FROM gmd_operation_activities
301: WHERE oprn_line_id = p_oprn_line_id
302: AND delete_mark = 0;

Line 300: FROM gmd_operation_activities

296: upd_oprn_actv_err EXCEPTION;
297:
298: CURSOR get_oprn_id(p_oprN_line_id gmd_operation_activities.oprn_line_id%TYPE) IS
299: SELECT oprn_id
300: FROM gmd_operation_activities
301: WHERE oprn_line_id = p_oprn_line_id
302: AND delete_mark = 0;
303:
304: BEGIN

Line 326: ,'gmd_operation_activities_pub') THEN

322: /* Make sure we are call compatible */
323: IF NOT FND_API.compatible_api_call(l_api_version
324: ,p_api_version
325: ,'update_operation_activity'
326: ,'gmd_operation_activities_pub') THEN
327: RAISE invalid_version;
328: END IF;
329:
330: IF (l_debug = 'Y') THEN

Line 418: GMD_OPERATION_ACTIVITIES_PVT.update_operation_activity(p_oprn_line_id => p_oprn_line_id

414: END IF;
415: END LOOP;
416:
417: IF x_return_status = 'S' THEN
418: GMD_OPERATION_ACTIVITIES_PVT.update_operation_activity(p_oprn_line_id => p_oprn_line_id
419: , p_update_table => p_update_table
420: , x_message_count => x_message_count
421: , x_message_list => x_message_list
422: , x_return_status => l_retn_status);

Line 471: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE

467: PROCEDURE delete_operation_activity
468: ( p_api_version IN NUMBER
469: , p_init_msg_list IN BOOLEAN
470: , p_commit IN BOOLEAN
471: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
472: , x_message_count OUT NOCOPY NUMBER
473: , x_message_list OUT NOCOPY VARCHAR2
474: , x_return_status OUT NOCOPY VARCHAR2) IS
475:

Line 476: v_update_table gmd_operation_activities_pub.update_tbl_type;

472: , x_message_count OUT NOCOPY NUMBER
473: , x_message_list OUT NOCOPY VARCHAR2
474: , x_return_status OUT NOCOPY VARCHAR2) IS
475:
476: v_update_table gmd_operation_activities_pub.update_tbl_type;
477: v_count NUMBER;
478: l_retn_status VARCHAR2(1);
479: l_api_version NUMBER := 1.0;
480: l_oprn_id NUMBER(15);

Line 488: FROM gmd_operation_activities

484: del_oprn_actv_err EXCEPTION;
485:
486: CURSOR chk_oprn_line_id(v_oprN_line_id NUMBER) IS
487: SELECT oprn_id
488: FROM gmd_operation_activities
489: WHERE oprn_line_id = v_oprn_line_id;
490:
491: CURSOR get_activity_count (v_oprn_id NUMBER) IS
492: SELECT COUNT(1)

Line 493: FROM gmd_operation_activities a

489: WHERE oprn_line_id = v_oprn_line_id;
490:
491: CURSOR get_activity_count (v_oprn_id NUMBER) IS
492: SELECT COUNT(1)
493: FROM gmd_operation_activities a
494: WHERE a.oprn_id = v_oprn_id;
495:
496: BEGIN
497: SAVEPOINT delete_oprn_actv;

Line 519: ,'gmd_operation_activities_pvt') THEN

515: /* Make sure we are call compatible */
516: IF NOT FND_API.compatible_api_call(l_api_version
517: ,p_api_version
518: ,'delete_operation_activity'
519: ,'gmd_operation_activities_pvt') THEN
520: RAISE invalid_version;
521: END IF;
522:
523: IF (l_debug = 'Y') THEN

Line 566: gmd_operation_activities_pvt.delete_operation_activity

562: RAISE del_oprn_actv_err;
563: END IF;
564:
565: IF x_return_status = 'S' THEN
566: gmd_operation_activities_pvt.delete_operation_activity
567: (p_oprn_line_id => p_oprn_line_id
568: , x_message_count => x_message_count
569: , x_message_list => x_message_list
570: , x_return_status => l_retn_status);

Line 604: END GMD_OPERATION_ACTIVITIES_PUB;

600: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
601: P_data => x_message_list);
602: END delete_operation_activity;
603:
604: END GMD_OPERATION_ACTIVITIES_PUB;