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.18.12010000.2 2008/09/08 06:28:58 lokumar 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.18.12010000.2 2008/09/08 06:28:58 lokumar 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 3327: l_task_rec_type_old jtf_tasks_pvt.task_rec_type;

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

Line 3328: l_task_rec_type_new jtf_tasks_pvt.task_rec_type;

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

Line 4458: l_task_rec_type jtf_tasks_pvt.task_rec_type;

4454: AND a.task_contact_id = c.task_id
4455: AND c.task_id = l_task_id;
4456:
4457: --BES enh 2391065
4458: l_task_rec_type jtf_tasks_pvt.task_rec_type;
4459: x_event_return_status VARCHAR2(100);
4460:
4461: CURSOR task_source_orig(b_task_id IN NUMBER) IS
4462: SELECT source_object_id