APPS.AS_SALES_METH_TASK_MAP_PVT dependencies on AS_SALES_METH_TASK_MAP

Line 1: PACKAGE BODY AS_SALES_METH_TASK_MAP_PVT AS

1: PACKAGE BODY AS_SALES_METH_TASK_MAP_PVT AS
2: /* $Header: asxsmtkb.pls 120.2 2005/12/14 01:42:38 sumahali noship $ */
3: --Procedure to Create a Sales Methodology
4: Procedure CREATE_SALES_METH_TASK_MAP
5: (

Line 33: INSERT INTO AS_SALES_METH_TASK_MAP ( sales_stage_id,

29: BEGIN
30: x_return_status := fnd_api.g_ret_sts_success;
31: SAVEPOINT create_sales_meth_task_pvt;
32: -- call table handler to insert into as_sales_methodology_b
33: INSERT INTO AS_SALES_METH_TASK_MAP ( sales_stage_id,
34: sales_methodology_id,
35: object_id,
36: object_type_code,
37: task_id,

Line 114: UPDATE AS_SALES_METH_TASK_MAP SET

110: BEGIN
111: x_return_status := fnd_api.g_ret_sts_success;
112: SAVEPOINT update_sales_meth_task_pvt;
113: -- call table handler to insert into as_sales_methodology_b
114: UPDATE AS_SALES_METH_TASK_MAP SET
115: sales_methodology_id = l_sales_methodology_id,
116: task_template_id = l_task_template_id,
117: last_updated_by = fnd_global.user_id,
118: last_update_date = SYSDATE ,

Line 187: DELETE FROM AS_SALES_METH_TASK_MAP

183: l_task_template_id NUMBER := p_task_template_id;
184: BEGIN
185: x_return_status := fnd_api.g_ret_sts_success;
186: SAVEPOINT update_sales_meth_task_pvt;
187: DELETE FROM AS_SALES_METH_TASK_MAP
188: WHERE object_id = l_source_object_id
189: AND sales_stage_id = l_sales_stage_id
190: AND task_template_group_id = l_task_template_group_id ;
191: IF (SQL%NOTFOUND) THEN

Line 228: end AS_SALES_METH_TASK_MAP_PVT;

224: p_count => x_msg_count,
225: p_data => x_msg_data
226: );
227: END DELETE_SALES_METH_TASK_MAP;
228: end AS_SALES_METH_TASK_MAP_PVT;
229: