APPS.JTF_EC_REFERENCES_PVT dependencies on JTF_EC_REFERENCES_PVT

Line 1: PACKAGE BODY jtf_ec_references_pvt AS

1: PACKAGE BODY jtf_ec_references_pvt AS
2: /* $Header: jtfecreb.pls 115.19 2004/02/13 10:58:24 nselvam ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_EC_REFERENCES_PVT';
4:
5: PROCEDURE create_references (

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

1: PACKAGE BODY jtf_ec_references_pvt AS
2: /* $Header: jtfecreb.pls 115.19 2004/02/13 10:58:24 nselvam ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_EC_REFERENCES_PVT';
4:
5: PROCEDURE create_references (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

Line 47: l_esc_ref_rec jtf_ec_references_pvt.Esc_Ref_rec;

43: l_escalation_id jtf_tasks_b.task_id%TYPE := p_escalation_id;
44: l_escalation_number jtf_tasks_b.task_number%TYPE := p_escalation_number;
45: x CHAR;
46: --Created for BES enh 2660883
47: l_esc_ref_rec jtf_ec_references_pvt.Esc_Ref_rec;
48:
49: BEGIN
50: SAVEPOINT create_references_pub;
51: x_return_status := fnd_api.g_ret_sts_success;

Line 256: l_esc_ref_rec_old jtf_ec_references_pvt.Esc_Ref_rec;

252:
253: escalation_reference c_escalation_reference%ROWTYPE;
254: x CHAR;
255: --Created for BES enh 2660883
256: l_esc_ref_rec_old jtf_ec_references_pvt.Esc_Ref_rec;
257: l_esc_ref_rec_new jtf_ec_references_pvt.Esc_Ref_rec;
258:
259: -- Added Task_ID for Bug # 3385990
260: CURSOR c_ref_orig (reference_id IN NUMBER) IS

Line 257: l_esc_ref_rec_new jtf_ec_references_pvt.Esc_Ref_rec;

253: escalation_reference c_escalation_reference%ROWTYPE;
254: x CHAR;
255: --Created for BES enh 2660883
256: l_esc_ref_rec_old jtf_ec_references_pvt.Esc_Ref_rec;
257: l_esc_ref_rec_new jtf_ec_references_pvt.Esc_Ref_rec;
258:
259: -- Added Task_ID for Bug # 3385990
260: CURSOR c_ref_orig (reference_id IN NUMBER) IS
261: SELECT REFERENCE_CODE , OBJECT_TYPE_CODE , OBJECT_ID, TASK_ID

Line 467: l_esc_ref_rec jtf_ec_references_pvt.Esc_Ref_rec;

463: l_api_version CONSTANT NUMBER := 1.0;
464: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_REFERENCE';
465:
466: --Created for BES enh 2660883
467: l_esc_ref_rec jtf_ec_references_pvt.Esc_Ref_rec;
468:
469: -- Added Task_ID for Bug # 3385990
470: CURSOR c_ref_orig (reference_id IN NUMBER) IS
471: SELECT REFERENCE_CODE, OBJECT_TYPE_CODE, OBJECT_ID, TASK_ID