APPS.JTF_EC_PVT dependencies on JTF_EC_PVT

Line 1: PACKAGE BODY jtf_ec_pvt AS

1: PACKAGE BODY jtf_ec_pvt AS
2: /* $Header: jtfecmab.pls 115.24 2004/04/21 12:01:23 nselvam ship $ */
3: g_user CONSTANT VARCHAR2(30) := fnd_global.user_id;
4: g_false CONSTANT VARCHAR2(30) := fnd_api.g_false;
5: g_true CONSTANT VARCHAR2(30) := fnd_api.g_true;

Line 64: l_esc_rec_type jtf_ec_pvt.Esc_Rec_type;

60: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ESCALATION';
61: l_escalation_id jtf_tasks_b.task_id%TYPE;
62: l_escalation_number jtf_tasks_b.task_number%TYPE;
63: --Created for BES enh 2660883
64: l_esc_rec_type jtf_ec_pvt.Esc_Rec_type;
65: BEGIN
66:
67: SAVEPOINT create_escalation_pvt;
68:

Line 477: l_esc_rec_type jtf_ec_pvt.Esc_Rec_type;

473: l_escalation_id;
474:
475: escalation_rec c_escalation_update%ROWTYPE;
476: --Created for BES enh 2660883
477: l_esc_rec_type jtf_ec_pvt.Esc_Rec_type;
478: l_task_audit_id jtf_task_audits_b.TASK_AUDIT_ID%TYPE;
479:
480: cursor auditid_cur IS
481: select MAX(TASK_AUDIT_ID)

Line 758: l_esc_rec_type jtf_ec_pvt.Esc_Rec_type;

754:
755: l_escalation_id jtf_tasks_b.task_id%type := p_escalation_id ;
756: l_escalation_number jtf_tasks_b.task_number%type := p_escalation_number ;
757: --Created for BES enh 2660883
758: l_esc_rec_type jtf_ec_pvt.Esc_Rec_type;
759:
760: /* Bug # 3568448 */
761: /*Commenting out the below cursor definition since call to jtf_tasks_pvt.delete_task deletes the reference records */
762: /* CURSOR c_delete_references