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_OPERATIONS_PUB dependencies on GMD_OPERATIONS

Line 1: PACKAGE BODY GMD_OPERATIONS_PUB AS

1: PACKAGE BODY GMD_OPERATIONS_PUB AS
2: /* $Header: GMDPOPSB.pls 120.3.12020000.2 2012/12/27 02:53:07 qzeng ship $
3: ************************************************************************************
4: * *
5: * Package GMD_OPERATIONS_PUB *

Line 5: * Package GMD_OPERATIONS_PUB *

1: PACKAGE BODY GMD_OPERATIONS_PUB AS
2: /* $Header: GMDPOPSB.pls 120.3.12020000.2 2012/12/27 02:53:07 qzeng ship $
3: ************************************************************************************
4: * *
5: * Package GMD_OPERATIONS_PUB *
6: * *
7: * Contents: INSERT_OPERATION *
8: * UPDATE_OPERATION *
9: * DELETE_OPERATION *

Line 66: ,p_operations IN OUT NOCOPY gmd_operations%ROWTYPE

62: PROCEDURE insert_operation (
63: p_api_version IN NUMBER
64: ,p_init_msg_list IN BOOLEAN
65: ,p_commit IN BOOLEAN
66: ,p_operations IN OUT NOCOPY gmd_operations%ROWTYPE
67: ,p_oprn_actv_tbl IN OUT NOCOPY gmd_operations_pub.gmd_oprn_activities_tbl_type
68: ,x_message_count OUT NOCOPY NUMBER
69: ,x_message_list OUT NOCOPY VARCHAR2
70: ,x_return_status OUT NOCOPY VARCHAR2

Line 67: ,p_oprn_actv_tbl IN OUT NOCOPY gmd_operations_pub.gmd_oprn_activities_tbl_type

63: p_api_version IN NUMBER
64: ,p_init_msg_list IN BOOLEAN
65: ,p_commit IN BOOLEAN
66: ,p_operations IN OUT NOCOPY gmd_operations%ROWTYPE
67: ,p_oprn_actv_tbl IN OUT NOCOPY gmd_operations_pub.gmd_oprn_activities_tbl_type
68: ,x_message_count OUT NOCOPY NUMBER
69: ,x_message_list OUT NOCOPY VARCHAR2
70: ,x_return_status OUT NOCOPY VARCHAR2
71: ,p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type) IS

Line 73: v_oprn_id gmd_operations.oprn_id%TYPE;

69: ,x_message_list OUT NOCOPY VARCHAR2
70: ,x_return_status OUT NOCOPY VARCHAR2
71: ,p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type) IS
72:
73: v_oprn_id gmd_operations.oprn_id%TYPE;
74: v_oprn_no gmd_operations.oprn_no%TYPE;
75: v_oprn_vers gmd_operations.oprn_vers%TYPE;
76: p_ret NUMBER;
77: v_oprn_class gmd_operations.oprn_class%TYPE;

Line 74: v_oprn_no gmd_operations.oprn_no%TYPE;

70: ,x_return_status OUT NOCOPY VARCHAR2
71: ,p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type) IS
72:
73: v_oprn_id gmd_operations.oprn_id%TYPE;
74: v_oprn_no gmd_operations.oprn_no%TYPE;
75: v_oprn_vers gmd_operations.oprn_vers%TYPE;
76: p_ret NUMBER;
77: v_oprn_class gmd_operations.oprn_class%TYPE;
78: l_retn_status VARCHAR2(1);

Line 75: v_oprn_vers gmd_operations.oprn_vers%TYPE;

71: ,p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type) IS
72:
73: v_oprn_id gmd_operations.oprn_id%TYPE;
74: v_oprn_no gmd_operations.oprn_no%TYPE;
75: v_oprn_vers gmd_operations.oprn_vers%TYPE;
76: p_ret NUMBER;
77: v_oprn_class gmd_operations.oprn_class%TYPE;
78: l_retn_status VARCHAR2(1);
79: my_rsrc_table_type gmd_operation_resources_pub.gmd_oprn_resources_tbl_type;

Line 77: v_oprn_class gmd_operations.oprn_class%TYPE;

73: v_oprn_id gmd_operations.oprn_id%TYPE;
74: v_oprn_no gmd_operations.oprn_no%TYPE;
75: v_oprn_vers gmd_operations.oprn_vers%TYPE;
76: p_ret NUMBER;
77: v_oprn_class gmd_operations.oprn_class%TYPE;
78: l_retn_status VARCHAR2(1);
79: my_rsrc_table_type gmd_operation_resources_pub.gmd_oprn_resources_tbl_type;
80: l_api_version NUMBER := 1.0;
81: l_entity_status gmd_api_grp.status_rec_type; ---bug# 3408799

Line 100: ,'gmd_operations_pub') THEN

96: /* Make sure we are call compatible */
97: IF NOT FND_API.compatible_api_call(l_api_version
98: ,p_api_version
99: ,'insert_operation'
100: ,'gmd_operations_pub') THEN
101: RAISE invalid_version;
102: END IF;
103:
104: /* Initialize message list and count if needed */

Line 270: GMD_OPERATIONS_PVT.insert_operation(p_operations => p_operations,

266: gmd_debug.put_line('before PVT routine called');
267: END IF;
268:
269: /* insert operation */
270: GMD_OPERATIONS_PVT.insert_operation(p_operations => p_operations,
271: x_message_count => x_message_count,
272: x_message_list => x_message_list,
273: x_return_status => l_retn_status);
274: IF l_retn_status <> FND_API.g_ret_sts_success THEN

Line 392: , p_oprn_id IN gmd_operations.oprn_id%TYPE

388: PROCEDURE update_operation
389: ( p_api_version IN NUMBER
390: , p_init_msg_list IN BOOLEAN
391: , p_commit IN BOOLEAN
392: , p_oprn_id IN gmd_operations.oprn_id%TYPE
393: , p_oprn_no IN gmd_operations.oprn_no%TYPE
394: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
395: , p_update_table IN gmd_operations_pub.update_tbl_type
396: , x_message_count OUT NOCOPY NUMBER

Line 393: , p_oprn_no IN gmd_operations.oprn_no%TYPE

389: ( p_api_version IN NUMBER
390: , p_init_msg_list IN BOOLEAN
391: , p_commit IN BOOLEAN
392: , p_oprn_id IN gmd_operations.oprn_id%TYPE
393: , p_oprn_no IN gmd_operations.oprn_no%TYPE
394: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
395: , p_update_table IN gmd_operations_pub.update_tbl_type
396: , x_message_count OUT NOCOPY NUMBER
397: , x_message_list OUT NOCOPY VARCHAR2

Line 394: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE

390: , p_init_msg_list IN BOOLEAN
391: , p_commit IN BOOLEAN
392: , p_oprn_id IN gmd_operations.oprn_id%TYPE
393: , p_oprn_no IN gmd_operations.oprn_no%TYPE
394: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
395: , p_update_table IN gmd_operations_pub.update_tbl_type
396: , x_message_count OUT NOCOPY NUMBER
397: , x_message_list OUT NOCOPY VARCHAR2
398: , x_return_status OUT NOCOPY VARCHAR2) IS

Line 395: , p_update_table IN gmd_operations_pub.update_tbl_type

391: , p_commit IN BOOLEAN
392: , p_oprn_id IN gmd_operations.oprn_id%TYPE
393: , p_oprn_no IN gmd_operations.oprn_no%TYPE
394: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
395: , p_update_table IN gmd_operations_pub.update_tbl_type
396: , x_message_count OUT NOCOPY NUMBER
397: , x_message_list OUT NOCOPY VARCHAR2
398: , x_return_status OUT NOCOPY VARCHAR2) IS
399:

Line 400: v_oprn_id gmd_operations.oprn_id%TYPE;

396: , x_message_count OUT NOCOPY NUMBER
397: , x_message_list OUT NOCOPY VARCHAR2
398: , x_return_status OUT NOCOPY VARCHAR2) IS
399:
400: v_oprn_id gmd_operations.oprn_id%TYPE;
401: l_retn_status VARCHAR2(1);
402: l_api_version NUMBER := 1.0;
403:
404: l_start_date VARCHAR2(30);

Line 414: FROM gmd_operations

410: upd_oprn_err EXCEPTION;
411:
412: CURSOR get_oprn_id (v_oprn_no VARCHAR2, v_oprn_vers NUMBER) IS
413: SELECT oprn_id
414: FROM gmd_operations
415: where oprn_no = v_oprn_no
416: and oprn_vers = v_oprn_vers;
417:
418: CURSOR check_oprn_id (v_oprn_id NUMBER) IS

Line 420: FROM gmd_operations

416: and oprn_vers = v_oprn_vers;
417:
418: CURSOR check_oprn_id (v_oprn_id NUMBER) IS
419: SELECT oprn_id
420: FROM gmd_operations
421: where oprn_id = v_oprn_id;
422:
423: CURSOR get_orgn_id (v_oprn_id NUMBER) IS
424: SELECT OWNER_ORGANIZATION_ID

Line 425: FROM gmd_operations

421: where oprn_id = v_oprn_id;
422:
423: CURSOR get_orgn_id (v_oprn_id NUMBER) IS
424: SELECT OWNER_ORGANIZATION_ID
425: FROM gmd_operations
426: where oprn_id = v_oprn_id;
427:
428: l_orgn_id NUMBER;
429:

Line 442: ,'gmd_operations_pub') THEN

438: /* Make sure we are call compatible */
439: IF NOT FND_API.compatible_api_call(l_api_version
440: ,p_api_version
441: ,'update_operation'
442: ,'gmd_operations_pub') THEN
443: RAISE invalid_version;
444: END IF;
445:
446: /* Intializes the setup fields */

Line 578: GMD_OPERATIONS_PVT.update_operation(p_oprn_id => v_oprn_id

574: IF (l_debug = 'Y') THEN
575: gmd_debug.put_line('before PVT routine called');
576: END IF;
577:
578: GMD_OPERATIONS_PVT.update_operation(p_oprn_id => v_oprn_id
579: , p_update_table => p_update_table
580: , x_message_count => x_message_count
581: , x_message_list => x_message_list
582: , x_return_status => l_retn_status);

Line 630: , p_oprn_id IN gmd_operations.oprn_id%TYPE

626: PROCEDURE delete_operation (
627: p_api_version IN NUMBER
628: , p_init_msg_list IN BOOLEAN
629: , p_commit IN BOOLEAN
630: , p_oprn_id IN gmd_operations.oprn_id%TYPE
631: , p_oprn_no IN gmd_operations.oprn_no%TYPE
632: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
633: , x_message_count OUT NOCOPY NUMBER
634: , x_message_list OUT NOCOPY VARCHAR2

Line 631: , p_oprn_no IN gmd_operations.oprn_no%TYPE

627: p_api_version IN NUMBER
628: , p_init_msg_list IN BOOLEAN
629: , p_commit IN BOOLEAN
630: , p_oprn_id IN gmd_operations.oprn_id%TYPE
631: , p_oprn_no IN gmd_operations.oprn_no%TYPE
632: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
633: , x_message_count OUT NOCOPY NUMBER
634: , x_message_list OUT NOCOPY VARCHAR2
635: , x_return_status OUT NOCOPY VARCHAR2 ) IS

Line 632: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE

628: , p_init_msg_list IN BOOLEAN
629: , p_commit IN BOOLEAN
630: , p_oprn_id IN gmd_operations.oprn_id%TYPE
631: , p_oprn_no IN gmd_operations.oprn_no%TYPE
632: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
633: , x_message_count OUT NOCOPY NUMBER
634: , x_message_list OUT NOCOPY VARCHAR2
635: , x_return_status OUT NOCOPY VARCHAR2 ) IS
636:

Line 637: v_update_table gmd_operations_pub.update_tbl_type;

633: , x_message_count OUT NOCOPY NUMBER
634: , x_message_list OUT NOCOPY VARCHAR2
635: , x_return_status OUT NOCOPY VARCHAR2 ) IS
636:
637: v_update_table gmd_operations_pub.update_tbl_type;
638: l_retn_status VARCHAR2(1);
639: l_api_version NUMBER := 1.0;
640:
641: upd_oprn_err EXCEPTION;

Line 706: END GMD_OPERATIONS_PUB;

702: P_data => x_message_list);
703:
704: END delete_operation;
705:
706: END GMD_OPERATIONS_PUB;