APPS.JTF_RS_ROLE_RELATE_AUD_PVT dependencies on JTF_RS_ROLE_RELATE_AUD

Line 1: Package Body JTF_RS_ROLE_RELATE_AUD_PVT AS

1: Package Body JTF_RS_ROLE_RELATE_AUD_PVT AS
2: /* $Header: jtfrsalb.pls 120.0 2005/05/11 08:19:07 appldev ship $ */
3: -- API Name : JTF_RS_ROLE_RELATE_AUD_PVT
4: -- Type : Private
5: -- Purpose : Inserts IN the JTF_RS_ROLE_RELATE_AUD

Line 3: -- API Name : JTF_RS_ROLE_RELATE_AUD_PVT

1: Package Body JTF_RS_ROLE_RELATE_AUD_PVT AS
2: /* $Header: jtfrsalb.pls 120.0 2005/05/11 08:19:07 appldev ship $ */
3: -- API Name : JTF_RS_ROLE_RELATE_AUD_PVT
4: -- Type : Private
5: -- Purpose : Inserts IN the JTF_RS_ROLE_RELATE_AUD
6: -- Modification History
7: -- DATE NAME PURPOSE

Line 5: -- Purpose : Inserts IN the JTF_RS_ROLE_RELATE_AUD

1: Package Body JTF_RS_ROLE_RELATE_AUD_PVT AS
2: /* $Header: jtfrsalb.pls 120.0 2005/05/11 08:19:07 appldev ship $ */
3: -- API Name : JTF_RS_ROLE_RELATE_AUD_PVT
4: -- Type : Private
5: -- Purpose : Inserts IN the JTF_RS_ROLE_RELATE_AUD
6: -- Modification History
7: -- DATE NAME PURPOSE
8: -- 20 JAN 2000 S Choudhury Created
9: -- Notes:

Line 14: g_pkg_name varchar2(30) := 'JTF_RS_ROLE_RELATE_AUD_PVT ';

10: --
11:
12: --DECLARE GLOBAL VARIABLE
13:
14: g_pkg_name varchar2(30) := 'JTF_RS_ROLE_RELATE_AUD_PVT ';
15: /* FOR INSERT */
16:
17: PROCEDURE INSERT_ROLE_RELATE(
18: P_API_VERSION IN NUMBER,

Line 33: l_role_relate_aud_id jtf_rs_role_relate_aud.role_relate_audit_id%type;

29: X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2 )
31: IS
32:
33: l_role_relate_aud_id jtf_rs_role_relate_aud.role_relate_audit_id%type;
34: l_row_id varchar2(24) := null;
35:
36: --other variables
37: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_ROLE_RELATE';

Line 67: select jtf_rs_role_relate_aud_s.nextval

63: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
64: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
65:
66:
67: select jtf_rs_role_relate_aud_s.nextval
68: into l_role_relate_aud_id
69: from dual;
70:
71: /* CALL TABLE HANDLER */

Line 72: JTF_RS_ROLE_RELATE_AUD_PKG.INSERT_ROW (

68: into l_role_relate_aud_id
69: from dual;
70:
71: /* CALL TABLE HANDLER */
72: JTF_RS_ROLE_RELATE_AUD_PKG.INSERT_ROW (
73: X_ROWID => l_row_id,
74: X_ROLE_RELATE_AUDIT_ID => l_role_relate_aud_id,
75: X_ROLE_RELATE_ID => p_role_relate_id,
76: X_NEW_ROLE_RESOURCE_TYPE => p_role_resource_type,

Line 179: l_role_relate_aud_id jtf_rs_role_relate_aud.role_relate_audit_id%type;

175:
176:
177:
178: rr_old_rec rr_old_cur%rowtype;
179: l_role_relate_aud_id jtf_rs_role_relate_aud.role_relate_audit_id%type;
180: l_row_id varchar2(24) := null;
181:
182: --other variables
183: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ROLE_RELATE';

Line 253: select jtf_rs_role_relate_aud_s.nextval

249: l_object_version_number_n := p_object_version_number;
250: end if;
251:
252:
253: select jtf_rs_role_relate_aud_s.nextval
254: into l_role_relate_aud_id
255: from dual;
256:
257: /* CALL TABLE HANDLER */

Line 258: JTF_RS_ROLE_RELATE_AUD_PKG.INSERT_ROW (

254: into l_role_relate_aud_id
255: from dual;
256:
257: /* CALL TABLE HANDLER */
258: JTF_RS_ROLE_RELATE_AUD_PKG.INSERT_ROW (
259: X_ROWID => l_row_id,
260: X_ROLE_RELATE_AUDIT_ID => l_role_relate_aud_id,
261: X_ROLE_RELATE_ID => p_role_relate_id,
262: X_NEW_ROLE_RESOURCE_TYPE => l_role_resource_type_n,

Line 351: l_role_relate_aud_id jtf_rs_role_relate_aud.role_relate_audit_id%type;

347: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE := null ;
348: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := NULL;
349:
350: rr_old_rec rr_old_cur%rowtype;
351: l_role_relate_aud_id jtf_rs_role_relate_aud.role_relate_audit_id%type;
352: l_row_id varchar2(24) := null;
353:
354: --other variables
355: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ROLE_RELATE';

Line 402: select jtf_rs_role_relate_aud_s.nextval

398:
399:
400:
401:
402: select jtf_rs_role_relate_aud_s.nextval
403: into l_role_relate_aud_id
404: from dual;
405:
406: /* CALL TABLE HANDLER */

Line 407: JTF_RS_ROLE_RELATE_AUD_PKG.INSERT_ROW (

403: into l_role_relate_aud_id
404: from dual;
405:
406: /* CALL TABLE HANDLER */
407: JTF_RS_ROLE_RELATE_AUD_PKG.INSERT_ROW (
408: X_ROWID => l_row_id,
409: X_ROLE_RELATE_AUDIT_ID => l_role_relate_aud_id,
410: X_ROLE_RELATE_ID => p_role_relate_id,
411: X_NEW_ROLE_RESOURCE_TYPE => null,

Line 467: END; -- Package Body JTF_RS_ROLE_RELATE_AUD_PVT

463:
464:
465: END DELETE_ROLE_RELATE;
466:
467: END; -- Package Body JTF_RS_ROLE_RELATE_AUD_PVT