DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PVT dependencies on JTF_TASK_INST_TEMPLATES_PUB

Line 1396: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;

1392: l_resolved_flag VARCHAR2(1);
1393:
1394: -- Added to be used as OUT parameter for calling CS_AutoGen_Task_PVT.Auto_Generate_Tasks API
1395: l_auto_task_gen_rec CS_AutoGen_Task_PVT.auto_task_gen_rec_type;
1396: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;
1397: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;
1398: -- Added for Misc ER :Owner auto assignment changes
1399: l_work_item_id NUMBER;
1400:

Line 1397: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;

1393:
1394: -- Added to be used as OUT parameter for calling CS_AutoGen_Task_PVT.Auto_Generate_Tasks API
1395: l_auto_task_gen_rec CS_AutoGen_Task_PVT.auto_task_gen_rec_type;
1396: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;
1397: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;
1398: -- Added for Misc ER :Owner auto assignment changes
1399: l_work_item_id NUMBER;
1400:
1401: --Added for calling Auditing project of 11.5.10

Line 4076: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;

4072: l_task_template_group_owner NUMBER;
4073: l_task_tmpl_group_owner_type VARCHAR2(240);
4074: l_task_owner_name VARCHAR2(120);
4075: l_auto_task_gen_rec CS_AutoGen_Task_PVT.auto_task_gen_rec_type;
4076: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;
4077: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;
4078:
4079: BEGIN
4080:

Line 4077: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;

4073: l_task_tmpl_group_owner_type VARCHAR2(240);
4074: l_task_owner_name VARCHAR2(120);
4075: l_auto_task_gen_rec CS_AutoGen_Task_PVT.auto_task_gen_rec_type;
4076: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;
4077: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;
4078:
4079: BEGIN
4080:
4081: -- Standard start of API savepoint

Line 7308: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;

7304: l_task_template_group_owner NUMBER;
7305: l_task_tmpl_group_owner_type VARCHAR2(240);
7306: l_task_owner_name VARCHAR2(120);
7307: l_auto_task_gen_rec CS_AutoGen_Task_PVT.auto_task_gen_rec_type;
7308: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;
7309: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;
7310:
7311: --Fixed bug#2775580, getting all the columns in the cursor.
7312:

Line 7309: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;

7305: l_task_tmpl_group_owner_type VARCHAR2(240);
7306: l_task_owner_name VARCHAR2(120);
7307: l_auto_task_gen_rec CS_AutoGen_Task_PVT.auto_task_gen_rec_type;
7308: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;
7309: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;
7310:
7311: --Fixed bug#2775580, getting all the columns in the cursor.
7312:
7313: /* ****************