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_RS_RESOURCE_EXTNS_AUD_PVT dependencies on JTF_RS_RESOURCE_EXTN_AUD

Line 50: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;

46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,
48: X_MSG_DATA OUT NOCOPY VARCHAR2 )
49: IS
50: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;
51: l_row_id varchar2(24) := null;
52:
53: --other variables
54: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_RESOURCE';

Line 85: select jtf_rs_resource_extn_aud_s.nextval

81: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
82: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
83:
84:
85: select jtf_rs_resource_extn_aud_s.nextval
86: into l_resource_extn_aud_id
87: from dual;
88:
89: /* CALL TABLE HANDLER */

Line 91: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW (

87: from dual;
88:
89: /* CALL TABLE HANDLER */
90:
91: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW (
92: X_ROWID => l_row_id,
93: x_resource_audit_id => l_resource_extn_aud_id,
94: x_resource_id => p_resource_id,
95: x_new_category => p_category,

Line 259: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;

255: X_MSG_DATA OUT NOCOPY VARCHAR2,
256: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,
257: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE)
258: IS
259: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;
260: l_row_id varchar2(24) := null;
261:
262: --other variables
263: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_RESOURCE';

Line 294: select jtf_rs_resource_extn_aud_s.nextval

290: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
291: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
292:
293:
294: select jtf_rs_resource_extn_aud_s.nextval
295: into l_resource_extn_aud_id
296: from dual;
297:
298: /* CALL TABLE HANDLER */

Line 300: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW (

296: from dual;
297:
298: /* CALL TABLE HANDLER */
299:
300: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW (
301: X_ROWID => l_row_id,
302: x_resource_audit_id => l_resource_extn_aud_id,
303: x_resource_id => p_resource_id,
304: x_new_category => p_category,

Line 600: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;

596: l_user_id_n jtf_rs_resource_extns.user_id%type;
597: l_object_version_number_n number;
598:
599: rr_old_rec rr_old_cur%rowtype;
600: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;
601: l_row_id varchar2(24) := null;
602: l_dummy varchar2(10) := 'S';
603:
604: --other variables

Line 786: select jtf_rs_resource_extn_aud_s.nextval

782: l_user_id_o := rr_old_rec.user_id;
783: l_user_id_n := p_user_id;
784: end if;
785:
786: select jtf_rs_resource_extn_aud_s.nextval
787: into l_resource_extn_aud_id
788: from dual;
789:
790: /* CALL TABLE HANDLER */

Line 791: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW (

787: into l_resource_extn_aud_id
788: from dual;
789:
790: /* CALL TABLE HANDLER */
791: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW (
792: X_ROWID => l_row_id,
793: x_resource_audit_id => l_resource_extn_aud_id,
794: x_resource_id => p_resource_id,
795: x_new_category => l_category_n,

Line 1161: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;

1157: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1158: l_party_id_n jtf_rs_resource_extns.person_party_id%type;
1159:
1160: rr_old_rec rr_old_cur%rowtype;
1161: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;
1162: l_row_id varchar2(24) := null;
1163: l_dummy varchar2(10) := 'S';
1164:
1165: --other variables

Line 1560: select jtf_rs_resource_extn_aud_s.nextval

1556:
1557:
1558:
1559:
1560: select jtf_rs_resource_extn_aud_s.nextval
1561: into l_resource_extn_aud_id
1562: from dual;
1563:
1564: /* CALL TABLE HANDLER */

Line 1565: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW (

1561: into l_resource_extn_aud_id
1562: from dual;
1563:
1564: /* CALL TABLE HANDLER */
1565: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW (
1566: X_ROWID => l_row_id,
1567: x_resource_audit_id => l_resource_extn_aud_id,
1568: x_resource_id => p_resource_id,
1569: x_new_category => l_category_n,

Line 1872: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;

1868: l_user_name jtf_rs_resource_extns.user_name%type ;
1869:
1870:
1871: rr_old_rec rr_old_cur%rowtype;
1872: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;
1873: l_row_id varchar2(24) := null;
1874:
1875: --other variables
1876: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE';

Line 1973: select jtf_rs_resource_extn_aud_s.nextval

1969: l_source_pager := rr_old_rec.source_pager;
1970: l_user_name := rr_old_rec.user_name;
1971:
1972:
1973: select jtf_rs_resource_extn_aud_s.nextval
1974: into l_resource_extn_aud_id
1975: from dual;
1976:
1977: --CALL TABLE HANDLER

Line 1978: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW (

1974: into l_resource_extn_aud_id
1975: from dual;
1976:
1977: --CALL TABLE HANDLER
1978: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW (
1979: X_ROWID => l_row_id,
1980: x_resource_audit_id => l_resource_extn_aud_id,
1981: x_resource_id => p_resource_id,
1982: x_new_category => null,