APPS.GMD_ACTIVITIES_PUB dependencies on GMD_ACTIVITIES

Line 1: PACKAGE BODY GMD_ACTIVITIES_PUB AS

1: PACKAGE BODY GMD_ACTIVITIES_PUB AS
2: /* $Header: GMDPACTB.pls 115.4 2004/02/25 17:42:27 nsrivast noship $
3: **************************************************************************
4: * *
5: * Package GMD_ACTIVITY_PUB *

Line 53: , p_activity_tbl IN gmd_activities_pub.gmd_activities_tbl_type

49: PROCEDURE insert_activity (
50: p_api_version IN NUMBER
51: , p_init_msg_list IN BOOLEAN
52: , p_commit IN BOOLEAN
53: , p_activity_tbl IN gmd_activities_pub.gmd_activities_tbl_type
54: , x_message_count OUT NOCOPY NUMBER
55: , x_message_list OUT NOCOPY VARCHAR2
56: , x_return_status OUT NOCOPY VARCHAR2) IS
57:

Line 92: ,'gmd_activities_pub') THEN

88: /* Make sure we are call compatible */
89: IF NOT FND_API.compatible_api_call(l_api_version
90: ,p_api_version
91: ,'insert_activity'
92: ,'gmd_activities_pub') THEN
93: RAISE invalid_version;
94: END IF;
95:
96: /* Loop through records in activity table and perform validations for each record*/

Line 147: GMD_ACTIVITIES_PVT.insert_activity(p_activity_tbl => p_activity_tbl,

143:
144: END LOOP;
145:
146: IF x_return_status = 'S' THEN
147: GMD_ACTIVITIES_PVT.insert_activity(p_activity_tbl => p_activity_tbl,
148: x_message_count => x_message_count,
149: x_message_list => x_message_list,
150: x_return_status => l_retn_status);
151: IF l_retn_status <> FND_API.g_ret_sts_success THEN

Line 199: ,p_activity IN gmd_activities.activity%TYPE

195: PROCEDURE update_activity (
196: p_api_version IN NUMBER
197: ,p_init_msg_list IN BOOLEAN
198: ,p_commit IN BOOLEAN
199: ,p_activity IN gmd_activities.activity%TYPE
200: ,p_update_table IN gmd_activities_pub.update_tbl_type
201: ,x_message_count OUT NOCOPY NUMBER
202: ,x_message_list OUT NOCOPY VARCHAR2
203: ,x_return_status OUT NOCOPY VARCHAR2 ) IS

Line 200: ,p_update_table IN gmd_activities_pub.update_tbl_type

196: p_api_version IN NUMBER
197: ,p_init_msg_list IN BOOLEAN
198: ,p_commit IN BOOLEAN
199: ,p_activity IN gmd_activities.activity%TYPE
200: ,p_update_table IN gmd_activities_pub.update_tbl_type
201: ,x_message_count OUT NOCOPY NUMBER
202: ,x_message_list OUT NOCOPY VARCHAR2
203: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
204:

Line 214: FROM gmd_activities_b

210: upd_activity_err EXCEPTION;
211:
212: CURSOR Cur_check_activity (v_activity VARCHAR2) IS
213: SELECT 1
214: FROM gmd_activities_b
215: WHERE activity = v_activity;
216:
217: l_exist NUMBER(5);
218:

Line 242: ,'gmd_activities_pub') THEN

238: /* Make sure we are call compatible */
239: IF NOT FND_API.compatible_api_call(l_api_version
240: ,p_api_version
241: ,'update_activity'
242: ,'gmd_activities_pub') THEN
243: RAISE invalid_version;
244: END IF;
245:
246: /* Initially let us assign the return status to success */

Line 318: GMD_ACTIVITIES_PVT.update_activity(p_activity => p_activity

314: END IF;
315: END LOOP;
316:
317: IF x_return_status = 'S' THEN
318: GMD_ACTIVITIES_PVT.update_activity(p_activity => p_activity
319: , p_update_table => p_update_table
320: , x_message_count => x_message_count
321: , x_message_list => x_message_list
322: , x_return_status => l_retn_status);

Line 371: ,p_activity IN gmd_activities.activity%TYPE

367: PROCEDURE delete_activity (
368: p_api_version IN NUMBER
369: ,p_init_msg_list IN BOOLEAN
370: ,p_commit IN BOOLEAN
371: ,p_activity IN gmd_activities.activity%TYPE
372: ,x_message_count OUT NOCOPY NUMBER
373: ,x_message_list OUT NOCOPY VARCHAR2
374: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
375:

Line 376: v_update_table gmd_activities_pub.update_tbl_type;

372: ,x_message_count OUT NOCOPY NUMBER
373: ,x_message_list OUT NOCOPY VARCHAR2
374: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
375:
376: v_update_table gmd_activities_pub.update_tbl_type;
377: l_retn_status VARCHAR2(1);
378: del_activity_err EXCEPTION;
379: BEGIN
380: SAVEPOINT delete_activity;

Line 427: END GMD_ACTIVITIES_PUB;

423: P_data => x_message_list);
424:
425: END delete_activity;
426:
427: END GMD_ACTIVITIES_PUB;