DBA Data[Home] [Help]

APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on CS_AUTOGEN_TASK_PVT

Line 366: p_task_template_search_rec cs_autogen_task_pvt.task_template_search_rec_type;

362: l_task_temp_grp_name varchar2(80);
363: l_task_temp_grp_names varchar2(2000);
364: l_found_flag varchar2(1) := 'N';
365: --
366: p_task_template_search_rec cs_autogen_task_pvt.task_template_search_rec_type;
367: l_task_template_group_tbl cs_autogen_task_pvt.task_template_group_tbl_type;
368: --
369: cursor c_task_template_id is
370: select a.template_group_id

Line 367: l_task_template_group_tbl cs_autogen_task_pvt.task_template_group_tbl_type;

363: l_task_temp_grp_names varchar2(2000);
364: l_found_flag varchar2(1) := 'N';
365: --
366: p_task_template_search_rec cs_autogen_task_pvt.task_template_search_rec_type;
367: l_task_template_group_tbl cs_autogen_task_pvt.task_template_group_tbl_type;
368: --
369: cursor c_task_template_id is
370: select a.template_group_id
371: from jtf_tasks_b a, jtf_task_statuses_vl b

Line 400: cs_autogen_task_pvt.get_task_template_group( p_api_version => 1.0

396: p_task_template_search_rec.inventory_item_id := p_new_inv_item;
397: p_task_template_search_rec.category_id := p_new_inv_category;
398: p_task_template_search_rec.problem_code := p_new_prob_code;
399: --
400: cs_autogen_task_pvt.get_task_template_group( p_api_version => 1.0
401: , p_init_msg_list => 'T'
402: , p_commit => fnd_api.g_false
403: , p_validation_level => fnd_api.g_valid_level_full
404: , p_task_template_search_rec => p_task_template_search_rec