APPS.CSL_JTF_TASKS_ACC_PKG dependencies on CSL_JTF_TASKS_ACC

Line 1: PACKAGE BODY CSL_JTF_TASKS_ACC_PKG AS

1: PACKAGE BODY CSL_JTF_TASKS_ACC_PKG AS
2: /* $Header: csltkacb.pls 120.0 2005/05/24 17:32:14 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_JTF_TASKS_ACC';

Line 5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_JTF_TASKS_ACC';

1: PACKAGE BODY CSL_JTF_TASKS_ACC_PKG AS
2: /* $Header: csltkacb.pls 120.0 2005/05/24 17:32:14 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_JTF_TASKS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_JTF_TASKS_VL');
8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_TASKS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'TASK_ID';

Line 617: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_INSERT_TASK',sqlerrm);

613: , g_table_name
614: , 'Caught exception in POST_INSERT_TASK hook:' || fnd_global.local_chr(10) || sqlerrm
615: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
616: END IF;
617: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_INSERT_TASK',sqlerrm);
618: -- x_return_status := FND_API.G_RET_STS_ERROR;
619: x_return_status := FND_API.G_RET_STS_SUCCESS;
620: END POST_INSERT_TASK;
621:

Line 679: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_TASK',sqlerrm);

675: , g_table_name
676: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
677: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
678: END IF;
679: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_TASK',sqlerrm);
680: -- x_return_status := FND_API.G_RET_STS_ERROR;
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: END PRE_UPDATE_TASK;
683:

Line 867: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_TASK',sqlerrm);

863: , g_table_name
864: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
865: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
866: END IF;
867: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_TASKS_ACC_PKG','POST_UPDATE_TASK',sqlerrm);
868: -- x_return_status := FND_API.G_RET_STS_ERROR;
869: x_return_status := FND_API.G_RET_STS_SUCCESS;
870: END POST_UPDATE_TASK;
871:

Line 949: FROM csl_jtf_tasks_acc acc,

945: IS
946:
947: CURSOR lcur_purge_tasks IS
948: SELECT acc.task_id, acc.resource_id
949: FROM csl_jtf_tasks_acc acc,
950: jtf_tasks_b jt,
951: jtf_task_statuses_b jts
952: WHERE acc.task_id = jt.task_id
953: AND jts.task_status_id = jt.task_status_id

Line 982: END CSL_JTF_TASKS_ACC_PKG;

978: JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
979:
980: END;
981:
982: END CSL_JTF_TASKS_ACC_PKG;