DBA Data[Home] [Help]

APPS.JTF_TASKS_PVT dependencies on JTF_TASKS_PVT

Line 1: PACKAGE BODY jtf_tasks_pvt AS

1: PACKAGE BODY jtf_tasks_pvt AS
2: /* $Header: jtfvtktb.pls 120.22 2010/09/13 07:22:47 anangupt ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TASKS_PVT';
4: g_entity CONSTANT jtf_tasks_b.entity%TYPE := 'TASK';
5: g_free_busy_type CONSTANT jtf_task_all_assignments.free_busy_type%TYPE := 'FREE';

Line 3: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TASKS_PVT';

1: PACKAGE BODY jtf_tasks_pvt AS
2: /* $Header: jtfvtktb.pls 120.22 2010/09/13 07:22:47 anangupt ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TASKS_PVT';
4: g_entity CONSTANT jtf_tasks_b.entity%TYPE := 'TASK';
5: g_free_busy_type CONSTANT jtf_task_all_assignments.free_busy_type%TYPE := 'FREE';
6: v_select VARCHAR2(6000);
7: -- table for query_task

Line 1134: l_task_rec_type jtf_tasks_pvt.task_rec_type;

1130: FROM jtf_tasks_b
1131: WHERE task_id = p_task_id;
1132:
1133: l_task_id_duplicate VARCHAR2(1);
1134: l_task_rec_type jtf_tasks_pvt.task_rec_type;
1135: BEGIN
1136: SAVEPOINT create_task_pvt;
1137:
1138: x_return_status := fnd_api.g_ret_sts_success;

Line 3328: l_task_rec_type_old jtf_tasks_pvt.task_rec_type;

3324:
3325: l_updated_field_rec jtf_task_repeat_appt_pvt.updated_field_rec;
3326: l_assignee_rec jtf_task_utl.c_assignee_or_owner%ROWTYPE;
3327: --BES enh 2391065
3328: l_task_rec_type_old jtf_tasks_pvt.task_rec_type;
3329: l_task_rec_type_new jtf_tasks_pvt.task_rec_type;
3330: x_task_upd_rec jtf_tasks_pkg.task_upd_rec; --BES enh
3331: x_task_audit_id jtf_task_audits_b.task_audit_id%TYPE;
3332: x_event_return_status VARCHAR2(100);

Line 3329: l_task_rec_type_new jtf_tasks_pvt.task_rec_type;

3325: l_updated_field_rec jtf_task_repeat_appt_pvt.updated_field_rec;
3326: l_assignee_rec jtf_task_utl.c_assignee_or_owner%ROWTYPE;
3327: --BES enh 2391065
3328: l_task_rec_type_old jtf_tasks_pvt.task_rec_type;
3329: l_task_rec_type_new jtf_tasks_pvt.task_rec_type;
3330: x_task_upd_rec jtf_tasks_pkg.task_upd_rec; --BES enh
3331: x_task_audit_id jtf_task_audits_b.task_audit_id%TYPE;
3332: x_event_return_status VARCHAR2(100);
3333: l_availability VARCHAR2(1) := 'F';

Line 4539: l_task_rec_type jtf_tasks_pvt.task_rec_type;

4535: AND a.task_contact_id = c.task_id
4536: AND c.task_id = l_task_id;
4537:
4538: --BES enh 2391065
4539: l_task_rec_type jtf_tasks_pvt.task_rec_type;
4540: x_event_return_status VARCHAR2(100);
4541:
4542: CURSOR task_source_orig(b_task_id IN NUMBER) IS
4543: SELECT source_object_id