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.PA_PAXAUGLT_XMLP_PKG dependencies on DBMS_APPLICATION_INFO

Line 114: /*STPROC.INIT('begin DBMS_APPLICATION_INFO.SET_MODULE(:MODULE_NAME, :ACTION_NAME); end;');

110:
111: PROCEDURE SET_MODULE(MODULE_NAME IN VARCHAR2
112: ,ACTION_NAME IN VARCHAR2) IS
113: BEGIN
114: /*STPROC.INIT('begin DBMS_APPLICATION_INFO.SET_MODULE(:MODULE_NAME, :ACTION_NAME); end;');
115: STPROC.BIND_I(MODULE_NAME);
116: STPROC.BIND_I(ACTION_NAME);
117: STPROC.EXECUTE;*/
118: DBMS_APPLICATION_INFO.SET_MODULE(MODULE_NAME, ACTION_NAME);

Line 118: DBMS_APPLICATION_INFO.SET_MODULE(MODULE_NAME, ACTION_NAME);

114: /*STPROC.INIT('begin DBMS_APPLICATION_INFO.SET_MODULE(:MODULE_NAME, :ACTION_NAME); end;');
115: STPROC.BIND_I(MODULE_NAME);
116: STPROC.BIND_I(ACTION_NAME);
117: STPROC.EXECUTE;*/
118: DBMS_APPLICATION_INFO.SET_MODULE(MODULE_NAME, ACTION_NAME);
119: END SET_MODULE;
120:
121: PROCEDURE SET_ACTION(ACTION_NAME IN VARCHAR2) IS
122: BEGIN

Line 123: /*STPROC.INIT('begin DBMS_APPLICATION_INFO.SET_ACTION(:ACTION_NAME); end;');

119: END SET_MODULE;
120:
121: PROCEDURE SET_ACTION(ACTION_NAME IN VARCHAR2) IS
122: BEGIN
123: /*STPROC.INIT('begin DBMS_APPLICATION_INFO.SET_ACTION(:ACTION_NAME); end;');
124: STPROC.BIND_I(ACTION_NAME);
125: STPROC.EXECUTE;*/
126: DBMS_APPLICATION_INFO.SET_ACTION(ACTION_NAME);
127: END SET_ACTION;

Line 126: DBMS_APPLICATION_INFO.SET_ACTION(ACTION_NAME);

122: BEGIN
123: /*STPROC.INIT('begin DBMS_APPLICATION_INFO.SET_ACTION(:ACTION_NAME); end;');
124: STPROC.BIND_I(ACTION_NAME);
125: STPROC.EXECUTE;*/
126: DBMS_APPLICATION_INFO.SET_ACTION(ACTION_NAME);
127: END SET_ACTION;
128:
129: PROCEDURE READ_MODULE(MODULE_NAME OUT NOCOPY VARCHAR2
130: ,ACTION_NAME OUT NOCOPY VARCHAR2) IS

Line 132: /*STPROC.INIT('begin DBMS_APPLICATION_INFO.READ_MODULE(:MODULE_NAME, :ACTION_NAME); end;');

128:
129: PROCEDURE READ_MODULE(MODULE_NAME OUT NOCOPY VARCHAR2
130: ,ACTION_NAME OUT NOCOPY VARCHAR2) IS
131: BEGIN
132: /*STPROC.INIT('begin DBMS_APPLICATION_INFO.READ_MODULE(:MODULE_NAME, :ACTION_NAME); end;');
133: STPROC.BIND_O(MODULE_NAME);
134: STPROC.BIND_O(ACTION_NAME);
135: STPROC.EXECUTE;
136: STPROC.RETRIEVE(1

Line 140: DBMS_APPLICATION_INFO.READ_MODULE(MODULE_NAME, ACTION_NAME);

136: STPROC.RETRIEVE(1
137: ,MODULE_NAME);
138: STPROC.RETRIEVE(2
139: ,ACTION_NAME);*/
140: DBMS_APPLICATION_INFO.READ_MODULE(MODULE_NAME, ACTION_NAME);
141: END READ_MODULE;
142:
143: PROCEDURE SET_CLIENT_INFO(CLIENT_INFO IN VARCHAR2) IS
144: BEGIN

Line 145: /*STPROC.INIT('begin DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:CLIENT_INFO); end;');

141: END READ_MODULE;
142:
143: PROCEDURE SET_CLIENT_INFO(CLIENT_INFO IN VARCHAR2) IS
144: BEGIN
145: /*STPROC.INIT('begin DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:CLIENT_INFO); end;');
146: STPROC.BIND_I(CLIENT_INFO);
147: STPROC.EXECUTE;*/
148: DBMS_APPLICATION_INFO.SET_CLIENT_INFO(CLIENT_INFO);
149: END SET_CLIENT_INFO;

Line 148: DBMS_APPLICATION_INFO.SET_CLIENT_INFO(CLIENT_INFO);

144: BEGIN
145: /*STPROC.INIT('begin DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:CLIENT_INFO); end;');
146: STPROC.BIND_I(CLIENT_INFO);
147: STPROC.EXECUTE;*/
148: DBMS_APPLICATION_INFO.SET_CLIENT_INFO(CLIENT_INFO);
149: END SET_CLIENT_INFO;
150:
151: PROCEDURE READ_CLIENT_INFO(CLIENT_INFO OUT NOCOPY VARCHAR2) IS
152: BEGIN

Line 153: /*STPROC.INIT('begin DBMS_APPLICATION_INFO.READ_CLIENT_INFO(:CLIENT_INFO); end;');

149: END SET_CLIENT_INFO;
150:
151: PROCEDURE READ_CLIENT_INFO(CLIENT_INFO OUT NOCOPY VARCHAR2) IS
152: BEGIN
153: /*STPROC.INIT('begin DBMS_APPLICATION_INFO.READ_CLIENT_INFO(:CLIENT_INFO); end;');
154: STPROC.BIND_O(CLIENT_INFO);
155: STPROC.EXECUTE;
156: STPROC.RETRIEVE(1
157: ,CLIENT_INFO);*/

Line 158: DBMS_APPLICATION_INFO.READ_CLIENT_INFO(CLIENT_INFO);

154: STPROC.BIND_O(CLIENT_INFO);
155: STPROC.EXECUTE;
156: STPROC.RETRIEVE(1
157: ,CLIENT_INFO);*/
158: DBMS_APPLICATION_INFO.READ_CLIENT_INFO(CLIENT_INFO);
159: END READ_CLIENT_INFO;
160:
161: /*PROCEDURE SET_SESSION_LONGOPS(HINT IN OUT NOCOPY BINARY_INTEGER
162: ,CONTEXT IN NUMBER

Line 172: STPROC.INIT('begin DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS(:HINT, :CONTEXT, :STEPID, :STEPSOFAR, :STEPTOTAL, :SOFAR, :TOTALWORK, :APPLICATION_DATA_1, :APPLICATION_DATA_2, :APPLICATION_DATA_3); end;');

168: ,APPLICATION_DATA_1 IN NUMBER
169: ,APPLICATION_DATA_2 IN NUMBER
170: ,APPLICATION_DATA_3 IN NUMBER) IS
171: BEGIN
172: STPROC.INIT('begin DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS(:HINT, :CONTEXT, :STEPID, :STEPSOFAR, :STEPTOTAL, :SOFAR, :TOTALWORK, :APPLICATION_DATA_1, :APPLICATION_DATA_2, :APPLICATION_DATA_3); end;');
173: STPROC.BIND_IO(HINT);
174: STPROC.BIND_I(CONTEXT);
175: STPROC.BIND_I(STEPID);
176: STPROC.BIND_I(STEPSOFAR);

Line 186: DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS(HINT, CONTEXT, STEPID, STEPSOFAR, STEPTOTAL, SOFAR, TOTALWORK, APPLICATION_DATA_1, APPLICATION_DATA_2, APPLICATION_DATA_3);

182: STPROC.BIND_I(APPLICATION_DATA_3);
183: STPROC.EXECUTE;
184: STPROC.RETRIEVE(1
185: ,HINT);
186: DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS(HINT, CONTEXT, STEPID, STEPSOFAR, STEPTOTAL, SOFAR, TOTALWORK, APPLICATION_DATA_1, APPLICATION_DATA_2, APPLICATION_DATA_3);
187: END SET_SESSION_LONGOPS;*/
188:
189: FUNCTION GET_CURRENCY_CODE RETURN VARCHAR2 IS
190: X0 VARCHAR2(2000);