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.ZPB_SECURITY_CONTEXT dependencies on DBMS_SESSION

Line 27: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'user_id', P_USER_ID);

23: P_BUSINESS_AREA_ID IN NUMBER)
24: IS
25:
26: BEGIN
27: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'user_id', P_USER_ID);
28: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'shadow_id', P_SHADOW_ID);
29: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'resp_id', P_RESP_ID);
30: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'session_id', P_SESSION_ID);
31: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'business_area_id', P_BUSINESS_AREA_ID);

Line 28: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'shadow_id', P_SHADOW_ID);

24: IS
25:
26: BEGIN
27: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'user_id', P_USER_ID);
28: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'shadow_id', P_SHADOW_ID);
29: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'resp_id', P_RESP_ID);
30: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'session_id', P_SESSION_ID);
31: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'business_area_id', P_BUSINESS_AREA_ID);
32: END INITCONTEXT;

Line 29: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'resp_id', P_RESP_ID);

25:
26: BEGIN
27: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'user_id', P_USER_ID);
28: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'shadow_id', P_SHADOW_ID);
29: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'resp_id', P_RESP_ID);
30: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'session_id', P_SESSION_ID);
31: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'business_area_id', P_BUSINESS_AREA_ID);
32: END INITCONTEXT;
33:

Line 30: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'session_id', P_SESSION_ID);

26: BEGIN
27: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'user_id', P_USER_ID);
28: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'shadow_id', P_SHADOW_ID);
29: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'resp_id', P_RESP_ID);
30: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'session_id', P_SESSION_ID);
31: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'business_area_id', P_BUSINESS_AREA_ID);
32: END INITCONTEXT;
33:
34: PROCEDURE INITOPENSQL (P_BUSINESS_AREA_ID IN NUMBER, P_LANG IN VARCHAR2)

Line 31: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'business_area_id', P_BUSINESS_AREA_ID);

27: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'user_id', P_USER_ID);
28: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'shadow_id', P_SHADOW_ID);
29: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'resp_id', P_RESP_ID);
30: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'session_id', P_SESSION_ID);
31: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'business_area_id', P_BUSINESS_AREA_ID);
32: END INITCONTEXT;
33:
34: PROCEDURE INITOPENSQL (P_BUSINESS_AREA_ID IN NUMBER, P_LANG IN VARCHAR2)
35:

Line 48: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'business_area_id', P_BUSINESS_AREA_ID);

44: select data_aw, annotation_aw into l_shar_aw, l_annot_aw
45: from zpb_business_areas
46: where business_area_id=P_BUSINESS_AREA_ID;
47:
48: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'business_area_id', P_BUSINESS_AREA_ID);
49:
50: l_zpb_pref := zpb_aw.get_schema;
51: l_zpb_pref := l_zpb_pref || '.';
52:

Line 73: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'user_lang', P_LANG_ID);

69:
70: IS
71:
72: BEGIN
73: DBMS_SESSION.SET_CONTEXT('ZPB_CONTEXT', 'user_lang', P_LANG_ID);
74:
75: end INITEPBLANG;
76:
77: end ZPB_SECURITY_CONTEXT;