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.IBU_DYN_USER_GROUPS_PKG dependencies on DUAL

Line 12: --select to_char(sysdate, 'mm-dd-yyyy hh24:mi:ss') into now from dual;

8: Procedure Log_Message(p_Message IN VARCHAR2)
9: IS
10: now VARCHAR2(60);
11: Begin
12: --select to_char(sysdate, 'mm-dd-yyyy hh24:mi:ss') into now from dual;
13: --dbms_output.put_line( p_Message || ' ' || now);
14: --FND_FILE.PUT_LINE(FND_FILE.LOG, p_Message || ' ' || now);
15: FND_FILE.PUT_LINE(FND_FILE.LOG, p_Message);
16: --insert into ibu_usrgrp_results values (ibu_usrgrp_results_s.nextval , p_Message, now);

Line 151: SELECT UPPER(p_sql_text) into l_q_str from DUAL;

147: l_substring VARCHAR2(2000);
148: Begin
149: Log_Message('Query in Get_Category = { ' || p_sql_text || ' } ');
150:
151: SELECT UPPER(p_sql_text) into l_q_str from DUAL;
152:
153: SELECT INSTR (l_q_str, 'FROM', 1, 1) INTO l_num FROM DUAL;
154: SELECT SUBSTR (l_q_str, 1, l_num) INTO l_substring FROM DUAL;
155:

Line 153: SELECT INSTR (l_q_str, 'FROM', 1, 1) INTO l_num FROM DUAL;

149: Log_Message('Query in Get_Category = { ' || p_sql_text || ' } ');
150:
151: SELECT UPPER(p_sql_text) into l_q_str from DUAL;
152:
153: SELECT INSTR (l_q_str, 'FROM', 1, 1) INTO l_num FROM DUAL;
154: SELECT SUBSTR (l_q_str, 1, l_num) INTO l_substring FROM DUAL;
155:
156: SELECT INSTR (l_substring, 'PARTY_ID', 1, 1) INTO l_party_num FROM DUAL;
157: IF (l_party_num <> 0) THEN

Line 154: SELECT SUBSTR (l_q_str, 1, l_num) INTO l_substring FROM DUAL;

150:
151: SELECT UPPER(p_sql_text) into l_q_str from DUAL;
152:
153: SELECT INSTR (l_q_str, 'FROM', 1, 1) INTO l_num FROM DUAL;
154: SELECT SUBSTR (l_q_str, 1, l_num) INTO l_substring FROM DUAL;
155:
156: SELECT INSTR (l_substring, 'PARTY_ID', 1, 1) INTO l_party_num FROM DUAL;
157: IF (l_party_num <> 0) THEN
158: x_category := 'PARTY';

Line 156: SELECT INSTR (l_substring, 'PARTY_ID', 1, 1) INTO l_party_num FROM DUAL;

152:
153: SELECT INSTR (l_q_str, 'FROM', 1, 1) INTO l_num FROM DUAL;
154: SELECT SUBSTR (l_q_str, 1, l_num) INTO l_substring FROM DUAL;
155:
156: SELECT INSTR (l_substring, 'PARTY_ID', 1, 1) INTO l_party_num FROM DUAL;
157: IF (l_party_num <> 0) THEN
158: x_category := 'PARTY';
159: Else
160: SELECT INSTR (l_substring, 'EMPLOYEE_ID', 1, 1) INTO l_emp_num FROM DUAL;

Line 160: SELECT INSTR (l_substring, 'EMPLOYEE_ID', 1, 1) INTO l_emp_num FROM DUAL;

156: SELECT INSTR (l_substring, 'PARTY_ID', 1, 1) INTO l_party_num FROM DUAL;
157: IF (l_party_num <> 0) THEN
158: x_category := 'PARTY';
159: Else
160: SELECT INSTR (l_substring, 'EMPLOYEE_ID', 1, 1) INTO l_emp_num FROM DUAL;
161: IF (l_emp_num <> 0) THEN
162: x_category := 'EMPLOYEE';
163: Else
164: x_category := 'UNKNOWN';

Line 187: SELECT UPPER(p_sql_text) into l_q_str from DUAL;

183: l_num NUMBER;
184: l_length NUMBER;
185: BEGIN
186:
187: SELECT UPPER(p_sql_text) into l_q_str from DUAL;
188: SELECT INSTR (l_q_str, 'FROM', 1, 1) INTO l_num FROM DUAL;
189: SELECT SUBSTR (l_q_str, 1, l_num-1) INTO l_first_substring FROM DUAL;
190: SELECT length (l_q_str) INTO l_length FROM DUAL;
191: --SELECT SUBSTR (l_q_str, l_num, l_length) INTO l_last_substring FROM DUAL;

Line 188: SELECT INSTR (l_q_str, 'FROM', 1, 1) INTO l_num FROM DUAL;

184: l_length NUMBER;
185: BEGIN
186:
187: SELECT UPPER(p_sql_text) into l_q_str from DUAL;
188: SELECT INSTR (l_q_str, 'FROM', 1, 1) INTO l_num FROM DUAL;
189: SELECT SUBSTR (l_q_str, 1, l_num-1) INTO l_first_substring FROM DUAL;
190: SELECT length (l_q_str) INTO l_length FROM DUAL;
191: --SELECT SUBSTR (l_q_str, l_num, l_length) INTO l_last_substring FROM DUAL;
192: -- For case sensitive queries

Line 189: SELECT SUBSTR (l_q_str, 1, l_num-1) INTO l_first_substring FROM DUAL;

185: BEGIN
186:
187: SELECT UPPER(p_sql_text) into l_q_str from DUAL;
188: SELECT INSTR (l_q_str, 'FROM', 1, 1) INTO l_num FROM DUAL;
189: SELECT SUBSTR (l_q_str, 1, l_num-1) INTO l_first_substring FROM DUAL;
190: SELECT length (l_q_str) INTO l_length FROM DUAL;
191: --SELECT SUBSTR (l_q_str, l_num, l_length) INTO l_last_substring FROM DUAL;
192: -- For case sensitive queries
193: SELECT SUBSTR (p_sql_text, l_num, l_length) INTO l_last_substring FROM DUAL;

Line 190: SELECT length (l_q_str) INTO l_length FROM DUAL;

186:
187: SELECT UPPER(p_sql_text) into l_q_str from DUAL;
188: SELECT INSTR (l_q_str, 'FROM', 1, 1) INTO l_num FROM DUAL;
189: SELECT SUBSTR (l_q_str, 1, l_num-1) INTO l_first_substring FROM DUAL;
190: SELECT length (l_q_str) INTO l_length FROM DUAL;
191: --SELECT SUBSTR (l_q_str, l_num, l_length) INTO l_last_substring FROM DUAL;
192: -- For case sensitive queries
193: SELECT SUBSTR (p_sql_text, l_num, l_length) INTO l_last_substring FROM DUAL;
194:

Line 191: --SELECT SUBSTR (l_q_str, l_num, l_length) INTO l_last_substring FROM DUAL;

187: SELECT UPPER(p_sql_text) into l_q_str from DUAL;
188: SELECT INSTR (l_q_str, 'FROM', 1, 1) INTO l_num FROM DUAL;
189: SELECT SUBSTR (l_q_str, 1, l_num-1) INTO l_first_substring FROM DUAL;
190: SELECT length (l_q_str) INTO l_length FROM DUAL;
191: --SELECT SUBSTR (l_q_str, l_num, l_length) INTO l_last_substring FROM DUAL;
192: -- For case sensitive queries
193: SELECT SUBSTR (p_sql_text, l_num, l_length) INTO l_last_substring FROM DUAL;
194:
195: l_first_substring := l_first_substring || ' , ' || '''' || p_category || '''' || ' , sysdate, ' || FND_GLOBAL.USER_ID || ' , sysdate, ' || FND_GLOBAL.USER_ID || ' ' ;

Line 193: SELECT SUBSTR (p_sql_text, l_num, l_length) INTO l_last_substring FROM DUAL;

189: SELECT SUBSTR (l_q_str, 1, l_num-1) INTO l_first_substring FROM DUAL;
190: SELECT length (l_q_str) INTO l_length FROM DUAL;
191: --SELECT SUBSTR (l_q_str, l_num, l_length) INTO l_last_substring FROM DUAL;
192: -- For case sensitive queries
193: SELECT SUBSTR (p_sql_text, l_num, l_length) INTO l_last_substring FROM DUAL;
194:
195: l_first_substring := l_first_substring || ' , ' || '''' || p_category || '''' || ' , sysdate, ' || FND_GLOBAL.USER_ID || ' , sysdate, ' || FND_GLOBAL.USER_ID || ' ' ;
196: l_q_str := l_first_substring || l_last_substring;
197: l_ins_qry := 'insert into ibu_usergroups_temp(source_id, category,creation_date, created_by, last_update_date, last_updated_by ) ';

Line 1432: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL',

1428: jtf_rs_role_relate_pub.create_resource_role_relate
1429: (P_API_VERSION => 1,
1430: P_INIT_MSG_LIST => fnd_api.g_false,
1431: P_COMMIT => fnd_api.g_false,
1432: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL',
1433: P_ROLE_RESOURCE_ID => x_resource_id,
1434: P_ROLE_ID => NULL,
1435: P_ROLE_CODE => 'MES_ADMIN',
1436: P_START_DATE_ACTIVE => sysdate,

Line 1448: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL',

1444: jtf_rs_role_relate_pub.create_resource_role_relate
1445: (P_API_VERSION => 1,
1446: P_INIT_MSG_LIST => fnd_api.g_false,
1447: P_COMMIT => fnd_api.g_false,
1448: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL',
1449: P_ROLE_RESOURCE_ID => x_resource_id,
1450: P_ROLE_ID => NULL,
1451: P_ROLE_CODE => 'MES_SETUP_CHANNEL',
1452: P_START_DATE_ACTIVE => sysdate,