APPS.GMD_OPERATIONS_PVT dependencies on GMD_OPERATIONS

Line 1: PACKAGE BODY GMD_OPERATIONS_PVT AS

1: PACKAGE BODY GMD_OPERATIONS_PVT AS
2: /* $Header: GMDVOPSB.pls 120.0 2005/05/25 19:47:44 appldev noship $
3: ********************************************************************
4: * *
5: * Package GMD_OPERATIONS_PVT *

Line 5: * Package GMD_OPERATIONS_PVT *

1: PACKAGE BODY GMD_OPERATIONS_PVT AS
2: /* $Header: GMDVOPSB.pls 120.0 2005/05/25 19:47:44 appldev noship $
3: ********************************************************************
4: * *
5: * Package GMD_OPERATIONS_PVT *
6: * *
7: * Contents: INSERT_OPERATION *
8: * UPDATE_OPERATION *
9: * *

Line 10: * Use This is the private layer of the GMD Operations API *

6: * *
7: * Contents: INSERT_OPERATION *
8: * UPDATE_OPERATION *
9: * *
10: * Use This is the private layer of the GMD Operations API *
11: * *
12: * *
13: * History *
14: * Written by Sandra Dulyk, OPM Development *

Line 48: , p_operations IN gmd_operations%ROWTYPE

44: PROCEDURE insert_operation
45: ( p_api_version IN NUMBER
46: , p_init_msg_list IN BOOLEAN
47: , p_commit IN BOOLEAN
48: , p_operations IN gmd_operations%ROWTYPE
49: , x_message_count OUT NOCOPY NUMBER
50: , x_message_list OUT NOCOPY VARCHAR2
51: , x_return_status OUT NOCOPY VARCHAR2) IS
52:

Line 71: GMD_OPERATIONS_PKG.INSERT_ROW(

67: IF NOT gmd_api_grp.setup_done THEN
68: RAISE setup_failure;
69: END IF;
70:
71: GMD_OPERATIONS_PKG.INSERT_ROW(
72: X_ROWID => l_rowid ,
73: X_OPRN_ID => p_operations.oprn_id,
74: X_ATTRIBUTE30 => p_operations.ATTRIBUTE30,
75: X_ATTRIBUTE_CATEGORY => p_operations.ATTRIBUTE_CATEGORY,

Line 153: , p_oprn_id IN gmd_operations.oprn_id%TYPE

149: PROCEDURE update_operation
150: ( p_api_version IN NUMBER
151: , p_init_msg_list IN BOOLEAN
152: , p_commit IN BOOLEAN
153: , p_oprn_id IN gmd_operations.oprn_id%TYPE
154: , p_update_table IN gmd_operations_pub.update_tbl_type
155: , x_message_count OUT NOCOPY NUMBER
156: , x_message_list OUT NOCOPY VARCHAR2
157: , x_return_status OUT NOCOPY VARCHAR2) IS

Line 154: , p_update_table IN gmd_operations_pub.update_tbl_type

150: ( p_api_version IN NUMBER
151: , p_init_msg_list IN BOOLEAN
152: , p_commit IN BOOLEAN
153: , p_oprn_id IN gmd_operations.oprn_id%TYPE
154: , p_update_table IN gmd_operations_pub.update_tbl_type
155: , x_message_count OUT NOCOPY NUMBER
156: , x_message_list OUT NOCOPY VARCHAR2
157: , x_return_status OUT NOCOPY VARCHAR2) IS
158:

Line 161: FROM gmd_operations

157: , x_return_status OUT NOCOPY VARCHAR2) IS
158:
159: CURSOR get_oprn_detail (v_oprn_id NUMBER) IS
160: SELECT *
161: FROM gmd_operations
162: WHERE oprn_Id = p_oprn_id
163: AND delete_mark = 0;
164:
165: v_update_rec gmd_operations%ROWTYPE;

Line 165: v_update_rec gmd_operations%ROWTYPE;

161: FROM gmd_operations
162: WHERE oprn_Id = p_oprn_id
163: AND delete_mark = 0;
164:
165: v_update_rec gmd_operations%ROWTYPE;
166: l_errmsg VARCHAR2(240);
167:
168: setup_failure EXCEPTION;
169: inv_operation EXCEPTION;

Line 382: GMD_OPERATIONS_PKG.UPDATE_ROW(

378: END IF;
379:
380:
381: IF x_return_status = 'S' THEN
382: GMD_OPERATIONS_PKG.UPDATE_ROW(
383: X_OPRN_ID => v_update_rec.oprn_id,
384: X_ATTRIBUTE30 => v_update_rec.ATTRIBUTE30,
385: X_ATTRIBUTE_CATEGORY => v_update_rec.ATTRIBUTE_CATEGORY,
386: X_ATTRIBUTE25 => v_update_rec.ATTRIBUTE25,

Line 448: END GMD_OPERATIONS_PVT;

444: P_data => x_message_list);
445:
446: END update_operation;
447:
448: END GMD_OPERATIONS_PVT;