APPS.AS_SALES_METH_WF dependencies on AS_SALES_METH_TASK_MAP

Line 113: SELECT count(a.task_id) FROM as_sales_meth_task_map a

109: FROM as_sales_meth_stage_map a
110: WHERE a.sales_methodology_id= l_methodology_id
111: ORDER BY stage_sequence;
112: CURSOR c_task IS
113: SELECT count(a.task_id) FROM as_sales_meth_task_map a
114: WHERE a.object_type_code = p_source_object_type_code
115: AND a.object_id = p_source_object_id
116: AND a.sales_stage_id = l_sales_stage_id
117: AND a.sales_methodology_id = l_methodology_id;

Line 410: CURSOR c_current_stage IS SELECT a.task_id FROM jtf_tasks_b a,as_sales_meth_task_map b,

406: l_task_name VARCHAR2(100);
407: l_task_number NUMBER;
408: l_meth_note_type VARCHAR2(100);
409: n NUMBER :=0;
410: CURSOR c_current_stage IS SELECT a.task_id FROM jtf_tasks_b a,as_sales_meth_task_map b,
411: jtf_task_statuses_b c
412: WHERE a.task_id = b.task_id
413: AND a.source_object_type_code = l_source_object_type_code
414: AND a.source_object_id = l_source_object_id

Line 496: CURSOR c_next_stage IS SELECT a.task_id FROM as_sales_meth_task_map a

492: l_name VARCHAR2(10);
493: l_return_status VARCHAR2(10);
494: l_long_task_id VARCHAR2(4000);
495: n NUMBER:= 0;
496: CURSOR c_next_stage IS SELECT a.task_id FROM as_sales_meth_task_map a
497: WHERE a.object_type_code = l_source_object_type_code
498: AND a.object_id = l_source_object_id
499: AND a.sales_stage_id = l_object_id ;
500: c_next_stage_rec c_next_stage%ROWTYPE;

Line 782: AS_SALES_METH_TASK_MAP_PVT.CREATE_SALES_METH_TASK_MAP ( P_API_VERSION => 1.0,

778: --------------
779: END IF;
780: CLOSE c_task;
781: --------------------------------------------------
782: AS_SALES_METH_TASK_MAP_PVT.CREATE_SALES_METH_TASK_MAP ( P_API_VERSION => 1.0,
783: P_INIT_MSG_LIST => fnd_api.g_false,
784: P_COMMIT => fnd_api.g_false,
785: P_VALIDATE_LEVEL => fnd_api.g_valid_level_full,
786: P_SALES_STAGE_ID => l_object_id,