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 2006/09/20 14:53:46 kmotupal noship $
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 2006/09/20 14:53:46 kmotupal noship $
3: ************************************************************************************
4: * *
5: * Package GMD_OPERATIONS_PUB *
6: * *
7: * Contents: INSERT_OPERATION *
8: * UPDATE_OPERATION *
9: * DELETE_OPERATION *

Line 62: ,p_operations IN OUT NOCOPY gmd_operations%ROWTYPE

58: PROCEDURE insert_operation (
59: p_api_version IN NUMBER
60: ,p_init_msg_list IN BOOLEAN
61: ,p_commit IN BOOLEAN
62: ,p_operations IN OUT NOCOPY gmd_operations%ROWTYPE
63: ,p_oprn_actv_tbl IN OUT NOCOPY gmd_operations_pub.gmd_oprn_activities_tbl_type
64: ,x_message_count OUT NOCOPY NUMBER
65: ,x_message_list OUT NOCOPY VARCHAR2
66: ,x_return_status OUT NOCOPY VARCHAR2

Line 63: ,p_oprn_actv_tbl IN OUT NOCOPY gmd_operations_pub.gmd_oprn_activities_tbl_type

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

Line 69: v_oprn_id gmd_operations.oprn_id%TYPE;

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

Line 70: v_oprn_no gmd_operations.oprn_no%TYPE;

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

Line 71: v_oprn_vers gmd_operations.oprn_vers%TYPE;

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

Line 73: v_oprn_class gmd_operations.oprn_class%TYPE;

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

Line 96: ,'gmd_operations_pub') THEN

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

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

259: gmd_debug.put_line('before PVT routine called');
260: END IF;
261:
262: /* insert operation */
263: GMD_OPERATIONS_PVT.insert_operation(p_operations => p_operations,
264: x_message_count => x_message_count,
265: x_message_list => x_message_list,
266: x_return_status => l_retn_status);
267: IF l_retn_status <> FND_API.g_ret_sts_success THEN

Line 385: , p_oprn_id IN gmd_operations.oprn_id%TYPE

381: PROCEDURE update_operation
382: ( p_api_version IN NUMBER
383: , p_init_msg_list IN BOOLEAN
384: , p_commit IN BOOLEAN
385: , p_oprn_id IN gmd_operations.oprn_id%TYPE
386: , p_oprn_no IN gmd_operations.oprn_no%TYPE
387: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
388: , p_update_table IN gmd_operations_pub.update_tbl_type
389: , x_message_count OUT NOCOPY NUMBER

Line 386: , p_oprn_no IN gmd_operations.oprn_no%TYPE

382: ( p_api_version IN NUMBER
383: , p_init_msg_list IN BOOLEAN
384: , p_commit IN BOOLEAN
385: , p_oprn_id IN gmd_operations.oprn_id%TYPE
386: , p_oprn_no IN gmd_operations.oprn_no%TYPE
387: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
388: , p_update_table IN gmd_operations_pub.update_tbl_type
389: , x_message_count OUT NOCOPY NUMBER
390: , x_message_list OUT NOCOPY VARCHAR2

Line 387: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE

383: , p_init_msg_list IN BOOLEAN
384: , p_commit IN BOOLEAN
385: , p_oprn_id IN gmd_operations.oprn_id%TYPE
386: , p_oprn_no IN gmd_operations.oprn_no%TYPE
387: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
388: , p_update_table IN gmd_operations_pub.update_tbl_type
389: , x_message_count OUT NOCOPY NUMBER
390: , x_message_list OUT NOCOPY VARCHAR2
391: , x_return_status OUT NOCOPY VARCHAR2) IS

Line 388: , p_update_table IN gmd_operations_pub.update_tbl_type

384: , p_commit IN BOOLEAN
385: , p_oprn_id IN gmd_operations.oprn_id%TYPE
386: , p_oprn_no IN gmd_operations.oprn_no%TYPE
387: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
388: , p_update_table IN gmd_operations_pub.update_tbl_type
389: , x_message_count OUT NOCOPY NUMBER
390: , x_message_list OUT NOCOPY VARCHAR2
391: , x_return_status OUT NOCOPY VARCHAR2) IS
392:

Line 393: v_oprn_id gmd_operations.oprn_id%TYPE;

389: , x_message_count OUT NOCOPY NUMBER
390: , x_message_list OUT NOCOPY VARCHAR2
391: , x_return_status OUT NOCOPY VARCHAR2) IS
392:
393: v_oprn_id gmd_operations.oprn_id%TYPE;
394: l_retn_status VARCHAR2(1);
395: l_api_version NUMBER := 1.0;
396:
397: l_start_date VARCHAR2(30);

Line 407: FROM gmd_operations

403: upd_oprn_err EXCEPTION;
404:
405: CURSOR get_oprn_id (v_oprn_no VARCHAR2, v_oprn_vers NUMBER) IS
406: SELECT oprn_id
407: FROM gmd_operations
408: where oprn_no = v_oprn_no
409: and oprn_vers = v_oprn_vers;
410:
411: CURSOR check_oprn_id (v_oprn_id NUMBER) IS

Line 413: FROM gmd_operations

409: and oprn_vers = v_oprn_vers;
410:
411: CURSOR check_oprn_id (v_oprn_id NUMBER) IS
412: SELECT oprn_id
413: FROM gmd_operations
414: where oprn_id = v_oprn_id;
415:
416: CURSOR get_orgn_id (v_oprn_id NUMBER) IS
417: SELECT OWNER_ORGANIZATION_ID

Line 418: FROM gmd_operations

414: where oprn_id = v_oprn_id;
415:
416: CURSOR get_orgn_id (v_oprn_id NUMBER) IS
417: SELECT OWNER_ORGANIZATION_ID
418: FROM gmd_operations
419: where oprn_id = v_oprn_id;
420:
421: l_orgn_id NUMBER;
422:

Line 435: ,'gmd_operations_pub') THEN

431: /* Make sure we are call compatible */
432: IF NOT FND_API.compatible_api_call(l_api_version
433: ,p_api_version
434: ,'update_operation'
435: ,'gmd_operations_pub') THEN
436: RAISE invalid_version;
437: END IF;
438:
439: /* Intializes the setup fields */

Line 571: GMD_OPERATIONS_PVT.update_operation(p_oprn_id => v_oprn_id

567: IF (l_debug = 'Y') THEN
568: gmd_debug.put_line('before PVT routine called');
569: END IF;
570:
571: GMD_OPERATIONS_PVT.update_operation(p_oprn_id => v_oprn_id
572: , p_update_table => p_update_table
573: , x_message_count => x_message_count
574: , x_message_list => x_message_list
575: , x_return_status => l_retn_status);

Line 623: , p_oprn_id IN gmd_operations.oprn_id%TYPE

619: PROCEDURE delete_operation (
620: p_api_version IN NUMBER
621: , p_init_msg_list IN BOOLEAN
622: , p_commit IN BOOLEAN
623: , p_oprn_id IN gmd_operations.oprn_id%TYPE
624: , p_oprn_no IN gmd_operations.oprn_no%TYPE
625: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
626: , x_message_count OUT NOCOPY NUMBER
627: , x_message_list OUT NOCOPY VARCHAR2

Line 624: , p_oprn_no IN gmd_operations.oprn_no%TYPE

620: p_api_version IN NUMBER
621: , p_init_msg_list IN BOOLEAN
622: , p_commit IN BOOLEAN
623: , p_oprn_id IN gmd_operations.oprn_id%TYPE
624: , p_oprn_no IN gmd_operations.oprn_no%TYPE
625: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
626: , x_message_count OUT NOCOPY NUMBER
627: , x_message_list OUT NOCOPY VARCHAR2
628: , x_return_status OUT NOCOPY VARCHAR2 ) IS

Line 625: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE

621: , p_init_msg_list IN BOOLEAN
622: , p_commit IN BOOLEAN
623: , p_oprn_id IN gmd_operations.oprn_id%TYPE
624: , p_oprn_no IN gmd_operations.oprn_no%TYPE
625: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
626: , x_message_count OUT NOCOPY NUMBER
627: , x_message_list OUT NOCOPY VARCHAR2
628: , x_return_status OUT NOCOPY VARCHAR2 ) IS
629:

Line 630: v_update_table gmd_operations_pub.update_tbl_type;

626: , x_message_count OUT NOCOPY NUMBER
627: , x_message_list OUT NOCOPY VARCHAR2
628: , x_return_status OUT NOCOPY VARCHAR2 ) IS
629:
630: v_update_table gmd_operations_pub.update_tbl_type;
631: l_retn_status VARCHAR2(1);
632: l_api_version NUMBER := 1.0;
633:
634: upd_oprn_err EXCEPTION;

Line 699: END GMD_OPERATIONS_PUB;

695: P_data => x_message_list);
696:
697: END delete_operation;
698:
699: END GMD_OPERATIONS_PUB;