eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PERZ_DDF_PVT dependencies on JTF_PERZ_DATA_DEFAULT

Line 44: -- 1. insert_jtf_perz_data_default

40: -- TABLE HANDLERS
41: --
42: -- The following are the table handlers
43: --
44: -- 1. insert_jtf_perz_data_default
45: -- 2. update_jtf_perz_data_default
46: -- 3. delete_jtf_perz_data_default
47: -- ****************************************************************************
48: -- ****************************************************************************

Line 45: -- 2. update_jtf_perz_data_default

41: --
42: -- The following are the table handlers
43: --
44: -- 1. insert_jtf_perz_data_default
45: -- 2. update_jtf_perz_data_default
46: -- 3. delete_jtf_perz_data_default
47: -- ****************************************************************************
48: -- ****************************************************************************
49: PROCEDURE insert_jtf_perz_data_default(

Line 46: -- 3. delete_jtf_perz_data_default

42: -- The following are the table handlers
43: --
44: -- 1. insert_jtf_perz_data_default
45: -- 2. update_jtf_perz_data_default
46: -- 3. delete_jtf_perz_data_default
47: -- ****************************************************************************
48: -- ****************************************************************************
49: PROCEDURE insert_jtf_perz_data_default(
50: x_PERZ_DDF_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 49: PROCEDURE insert_jtf_perz_data_default(

45: -- 2. update_jtf_perz_data_default
46: -- 3. delete_jtf_perz_data_default
47: -- ****************************************************************************
48: -- ****************************************************************************
49: PROCEDURE insert_jtf_perz_data_default(
50: x_PERZ_DDF_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
51: p_PROFILE_ID IN NUMBER,
52: p_APPLICATION_ID IN NUMBER,
53: p_PERZ_DDF_CONTEXT IN VARCHAR2,

Line 60: CURSOR C2 IS SELECT JTF_PERZ_DATA_DEFAULT_S.nextval FROM sys.dual;

56: p_DDF_VALUE IN VARCHAR2,
57: p_DDF_VALUE_TYPE IN VARCHAR2,
58: p_OBJECT_VERSION_NUMBER IN NUMBER
59: ) IS
60: CURSOR C2 IS SELECT JTF_PERZ_DATA_DEFAULT_S.nextval FROM sys.dual;
61: BEGIN
62: If (x_PERZ_DDF_ID IS NULL) then
63: OPEN C2;
64: FETCH C2 INTO x_PERZ_DDF_ID;

Line 67: INSERT INTO JTF_PERZ_DATA_DEFAULT(

63: OPEN C2;
64: FETCH C2 INTO x_PERZ_DDF_ID;
65: CLOSE C2;
66: End If;
67: INSERT INTO JTF_PERZ_DATA_DEFAULT(
68: PERZ_DATA_DEFAULT_ID,
69: PROFILE_ID,
70: APPLICATION_ID,
71: PERZ_DDF_CONTEXT,

Line 93: End insert_jtf_perz_data_default;

89: decode( p_DDF_VALUE_TYPE, FND_API.G_MISS_CHAR, NULL, p_DDF_VALUE_TYPE),
90: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
91: FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID
92: );
93: End insert_jtf_perz_data_default;
94: -- ****************************************************************************
95:
96: PROCEDURE update_jtf_perz_data_default(
97: x_PERZ_DDF_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 96: PROCEDURE update_jtf_perz_data_default(

92: );
93: End insert_jtf_perz_data_default;
94: -- ****************************************************************************
95:
96: PROCEDURE update_jtf_perz_data_default(
97: x_PERZ_DDF_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
98: p_PROFILE_ID IN NUMBER,
99: p_APPLICATION_ID IN NUMBER,
100: p_PERZ_DDF_CONTEXT IN VARCHAR2,

Line 110: Update JTF_PERZ_DATA_DEFAULT

106: ) IS
107:
108: l_object_version_number NUMBER := p_OBJECT_VERSION_NUMBER;
109: BEGIN
110: Update JTF_PERZ_DATA_DEFAULT
111: SET
112: -- PROFILE_ID = decode( p_PROFILE_ID, FND_API.G_MISS_NUM, PROFILE_ID, p_PROFILE_ID),
113: -- APPLICATION_ID = decode( p_APPLICATION_ID, FND_API.G_MISS_NUM, APPLICATION_ID, p_APPLICATION_ID),
114: -- PERZ_DDF_CONTEXT = decode( p_PERZ_DDF_CONTEXT, FND_API.G_MISS_CHAR, PERZ_DDF_CONTEXT, p_PERZ_DDF_CONTEXT),

Line 130: END update_jtf_perz_data_default;

126:
127: If (SQL%NOTFOUND) then
128: RAISE NO_DATA_FOUND;
129: End If;
130: END update_jtf_perz_data_default;
131: -- ****************************************************************************
132:
133: PROCEDURE delete_jtf_perz_data_default(
134: p_PERZ_DDF_ID IN NUMBER)

Line 133: PROCEDURE delete_jtf_perz_data_default(

129: End If;
130: END update_jtf_perz_data_default;
131: -- ****************************************************************************
132:
133: PROCEDURE delete_jtf_perz_data_default(
134: p_PERZ_DDF_ID IN NUMBER)
135: IS
136: BEGIN
137: DELETE FROM JTF_PERZ_DATA_DEFAULT

Line 137: DELETE FROM JTF_PERZ_DATA_DEFAULT

133: PROCEDURE delete_jtf_perz_data_default(
134: p_PERZ_DDF_ID IN NUMBER)
135: IS
136: BEGIN
137: DELETE FROM JTF_PERZ_DATA_DEFAULT
138: WHERE PERZ_DATA_DEFAULT_ID = p_PERZ_DDF_ID;
139: If (SQL%NOTFOUND) then
140: RAISE NO_DATA_FOUND;
141: End If;

Line 142: END delete_jtf_perz_data_default;

138: WHERE PERZ_DATA_DEFAULT_ID = p_PERZ_DDF_ID;
139: If (SQL%NOTFOUND) then
140: RAISE NO_DATA_FOUND;
141: End If;
142: END delete_jtf_perz_data_default;
143:
144: -- ***************************************************************************
145: -- ***************************************************************************
146: --

Line 176: from JTF_PERZ_DATA_DEFAULT

172: p_gui_object_id NUMBER, p_perz_ddf_context VARCHAR2) is
173: select perz_data_default_id, perz_ddf_context,
174: profile_id, application_id, gui_object_name,
175: gui_object_id, PERZ_ddf_value, PERZ_ddf_value_type
176: from JTF_PERZ_DATA_DEFAULT
177: where
178: PROFILE_ID = p_PROFILE_ID
179: and APPLICATION_ID = p_APPLICATION_ID
180: and GUI_OBJECT_ID = p_GUI_OBJECT_ID

Line 188: from JTF_PERZ_DATA_DEFAULT

184: p_gui_object_id NUMBER) is
185: select perz_data_default_id, perz_ddf_context,
186: profile_id, application_id, gui_object_name,
187: gui_object_id, PERZ_ddf_value, PERZ_ddf_value_type
188: from JTF_PERZ_DATA_DEFAULT
189: where
190: PROFILE_ID = p_PROFILE_ID
191: and APPLICATION_ID = p_APPLICATION_ID
192: and GUI_OBJECT_ID = p_GUI_OBJECT_ID;

Line 200: from JTF_PERZ_DATA_DEFAULT

196: select perz_data_default_id, perz_ddf_context,
197: profile_id, application_id, gui_object_name,
198: gui_object_id, PERZ_ddf_value, PERZ_ddf_value_type
199:
200: from JTF_PERZ_DATA_DEFAULT
201: where
202: PROFILE_ID = p_PROFILE_ID
203: and APPLICATION_ID = p_APPLICATION_ID
204: and GUI_OBJECT_NAME = p_GUI_OBJECT_NAME

Line 212: from JTF_PERZ_DATA_DEFAULT

208: p_gui_object_name VARCHAR2) is
209: select perz_data_default_id, perz_ddf_context,
210: profile_id, application_id, gui_object_name,
211: gui_object_id, PERZ_ddf_value, PERZ_ddf_value_type
212: from JTF_PERZ_DATA_DEFAULT
213: where
214: PROFILE_ID = p_PROFILE_ID
215: and APPLICATION_ID = p_APPLICATION_ID
216: and GUI_OBJECT_NAME = p_GUI_OBJECT_NAME;

Line 408: from JTF_PERZ_DATA_DEFAULT

404: (x_PERZ_DDF_ID <> FND_API.G_MISS_NUM)) then
405:
406: select PERZ_DATA_DEFAULT_ID, OBJECT_VERSION_NUMBER
407: into l_perz_ddf_id, x_OBJECT_VERSION_NUMBER
408: from JTF_PERZ_DATA_DEFAULT
409: where PERZ_DATA_DEFAULT_ID = x_PERZ_DDF_ID;
410:
411: if (SQL%NOTFOUND) then
412: RAISE NO_DATA_FOUND;

Line 427: from JTF_PERZ_DATA_DEFAULT

423: (p_GUI_OBJECT_ID <>FND_API.G_MISS_NUM)) then
424: BEGIN
425: select PERZ_DATA_DEFAULT_ID, OBJECT_VERSION_NUMBER
426: into l_perz_ddf_id, x_OBJECT_VERSION_NUMBER
427: from JTF_PERZ_DATA_DEFAULT
428: where PROFILE_ID = p_PROFILE_ID
429: and APPLICATION_ID = p_APPLICATION_ID
430: and PERZ_DDF_CONTEXT = p_PERZ_DDF_CONTEXT
431: and GUI_OBJECT_ID = p_GUI_OBJECT_ID;

Line 449: from JTF_PERZ_DATA_DEFAULT

445: (p_GUI_OBJECT_NAME <> FND_API.G_MISS_CHAR)) THEN
446: BEGIN
447: select PERZ_DATA_DEFAULT_ID, OBJECT_VERSION_NUMBER
448: into l_perz_ddf_id, x_OBJECT_VERSION_NUMBER
449: from JTF_PERZ_DATA_DEFAULT
450: where PROFILE_ID = p_PROFILE_ID
451: and APPLICATION_ID = p_APPLICATION_ID
452: and PERZ_DDF_CONTEXT = p_PERZ_DDF_CONTEXT
453: and GUI_OBJECT_NAME = p_GUI_OBJECT_NAME;

Line 625: insert_jtf_perz_data_default(

621: end if;
622:
623: --2 Calling the insert table handler
624: l_object_version_number := 1;
625: insert_jtf_perz_data_default(
626: l_perz_ddf_id,
627: l_profile_id,
628: p_APPLICATION_ID,
629: p_PERZ_DDF_CONTEXT,

Line 873: update_jtf_perz_data_default(

869: else
870:
871: --3. Call the update handler
872:
873: update_jtf_perz_data_default(
874: l_perz_ddf_id,
875: l_profile_id,
876: p_APPLICATION_ID,
877: p_PERZ_DDF_CONTEXT,

Line 1547: delete_jtf_perz_data_default( p_perz_ddf_id);

1543: if ((p_perz_ddf_id is not null)
1544: AND (p_perz_ddf_id <> FND_API.G_MISS_NUM)) then
1545: -- Call delete_row()
1546:
1547: delete_jtf_perz_data_default( p_perz_ddf_id);
1548: else
1549: RAISE FND_API.G_EXC_ERROR;
1550:
1551: end if;