APPS.GMD_ACTIVITIES_PVT dependencies on GMD_ACTIVITIES

Line 1: PACKAGE BODY GMD_ACTIVITIES_PVT AS

1: PACKAGE BODY GMD_ACTIVITIES_PVT AS
2: /* $Header: GMDVACTB.pls 115.4 2004/02/25 18:12:35 nsrivast noship $
3: *****************************************************************
4: * *
5: * Package GMD_ACTIVITY_PVT *

Line 48: , p_activity_tbl IN gmd_activities_pub.gmd_activities_tbl_type

44: PROCEDURE insert_activity (
45: p_api_version IN NUMBER
46: , p_init_msg_list IN BOOLEAN
47: , p_commit IN BOOLEAN
48: , p_activity_tbl IN gmd_activities_pub.gmd_activities_tbl_type
49: , x_message_count OUT NOCOPY NUMBER
50: , x_message_list OUT NOCOPY VARCHAR2
51: , x_return_status OUT NOCOPY VARCHAR2 ) IS
52:

Line 55: FROM gmd_activities_b

51: , x_return_status OUT NOCOPY VARCHAR2 ) IS
52:
53: CURSOR Cur_check_activity (v_activity VARCHAR2) IS
54: SELECT 1
55: FROM gmd_activities_b
56: WHERE activity = v_activity;
57:
58: l_exist NUMBER(5);
59: l_rowid VARCHAR2(40);

Line 95: GMD_ACTIVITIES_PKG.INSERT_ROW(

91: RAISE duplicate_activity;
92: END IF;
93: CLOSE Cur_check_activity;
94:
95: GMD_ACTIVITIES_PKG.INSERT_ROW(
96: X_ROWID => l_rowid,
97: X_ACTIVITY => p_activity_tbl(i).ACTIVITY,
98: X_COST_ANALYSIS_CODE => p_activity_tbl(i).COST_ANALYSIS_CODE,
99: X_DELETE_MARK => 0,

Line 144: ,p_activity IN gmd_activities.activity%TYPE

140: PROCEDURE update_activity (
141: p_api_version IN NUMBER
142: ,p_init_msg_list IN BOOLEAN
143: ,p_commit IN BOOLEAN
144: ,p_activity IN gmd_activities.activity%TYPE
145: ,p_update_table IN gmd_activities_pub.update_tbl_type
146: ,x_message_count OUT NOCOPY NUMBER
147: ,x_message_list OUT NOCOPY VARCHAR2
148: ,x_return_status OUT NOCOPY VARCHAR2 ) IS

Line 145: ,p_update_table IN gmd_activities_pub.update_tbl_type

141: p_api_version IN NUMBER
142: ,p_init_msg_list IN BOOLEAN
143: ,p_commit IN BOOLEAN
144: ,p_activity IN gmd_activities.activity%TYPE
145: ,p_update_table IN gmd_activities_pub.update_tbl_type
146: ,x_message_count OUT NOCOPY NUMBER
147: ,x_message_list OUT NOCOPY VARCHAR2
148: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
149:

Line 152: FROM gmd_activities

148: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
149:
150: CURSOR retrieve_activity_table_values(v_activity VARCHAR2) IS
151: SELECT *
152: FROM gmd_activities
153: WHERE activity = v_activity;
154:
155: v_update_rec gmd_activities%ROWTYPE;
156:

Line 155: v_update_rec gmd_activities%ROWTYPE;

151: SELECT *
152: FROM gmd_activities
153: WHERE activity = v_activity;
154:
155: v_update_rec gmd_activities%ROWTYPE;
156:
157: setup_failure EXCEPTION;
158: inv_activity_err EXCEPTION;
159:

Line 202: GMD_ACTIVITIES_PKG.UPDATE_ROW(

198: v_update_rec.activity_desc := p_update_table(i).p_value;
199: END IF;
200: END LOOP;
201:
202: GMD_ACTIVITIES_PKG.UPDATE_ROW(
203: X_ACTIVITY => p_activity
204: ,X_COST_ANALYSIS_CODE => v_update_rec.cost_analysis_code
205: ,X_DELETE_MARK => v_update_rec.delete_mark
206: ,X_TEXT_CODE => v_update_rec.text_code

Line 230: END GMD_ACTIVITIES_PVT;

226: FND_MSG_PUB.ADD;
227: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
228: P_data => x_message_list);
229: END update_activity;
230: END GMD_ACTIVITIES_PVT;