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

Line 42: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;

38: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 4 := '|| p_resp4);
39: fnd_file.put_line(FND_FILE.LOG,' Parameter : Responsibility 5 := '|| p_resp5);
40:
41: If (P_debug = 'Y') then
42: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
43: fnd_file.put_line(FND_FILE.LOG,'Date and Time Before starting the update on ar_collectors '|| l_date_time );
44: End If;
45:
46: /* kasreeni 07/14/2005 Changed to Merge_Collectors as function */

Line 83: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;

79: l_colcount NUMBER;
80: l_date_time VARCHAR2(25);
81: BEGIN
82: If (P_debug = 'Y') then
83: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
84: fnd_file.put_line(FND_FILE.LOG,'Date and Time Before starting the update on ar_collectors '|| l_date_time );
85: End If;
86:
87: UPDATE ar_collectors ARC set

Line 103: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;

99: AND resource_id is null;
100:
101: l_colcount := sql%rowcount;
102: fnd_file.put_line(FND_FILE.LOG, l_colcount || ' Record(s) updated in ar_collectors by merging Resource' ) ;
103: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
104: If (P_debug = 'Y') then
105: fnd_file.put_line(FND_FILE.LOG,'Date and Time After finishing the update on ar_collectors'|| l_date_time );
106: End If;
107: if (l_colcount > 0) then

Line 184: SELECT to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;

180: --Bug4930348. Use Responsibility Id. Fix by LKKUMAR on 16-Jan-2006. End.
181:
182:
183:
184: SELECT to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
185: fnd_file.put_line(FND_FILE.LOG,'Starting the conversion ' || l_date_time);
186:
187:
188: -- Inserting in to AR_COLLECTORS

Line 191: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;

187:
188: -- Inserting in to AR_COLLECTORS
189:
190: If (P_debug = 'Y') then
191: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
192: fnd_file.put_line(FND_FILE.LOG,'Date and Time After finishing the update '|| l_date_time );
193: End If;
194:
195:

Line 199: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;

195:
196: -- Inserting in to AR_COLLECTORS
197: FOR I IN INSERT_RESOURCE LOOP
198: If (P_debug = 'Y') then
199: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
200: fnd_file.put_line(FND_FILE.LOG,'Date and Time Before starting the Insert '|| l_date_time );
201: End If;
202: BEGIN
203: SELECT AR_COLLECTORS_S.NEXTVAL

Line 205: FROM DUAL;

201: End If;
202: BEGIN
203: SELECT AR_COLLECTORS_S.NEXTVAL
204: INTO L_COLLECTOR_ID
205: FROM DUAL;
206: Exception when others then
207: If (P_debug = 'Y') then
208: fnd_file.put_line(FND_FILE.LOG,'Error while selecting the colector_id sequence ' || SQLERRM);
209: End If;

Line 257: AND jtrr.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'

253: WHERE
254: jtrr.role_resource_id = jtfrs.resource_id
255: AND jtv.role_id = jtrr.role_id
256: AND jtv.ROLE_CODE = 'IEX_AGENT'
257: AND jtrr.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'
258: AND jtfrs.source_id is not null
259: AND jtfrs.resource_id = i.resource_id;
260:
261: If (p_debug = 'Y') then

Line 278: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL' ,

274: JTF_RS_ROLE_RELATE_PUB.create_resource_role_relate
275: (P_API_VERSION => 1.0,
276: P_INIT_MSG_LIST => 'T',
277: P_COMMIT => 'F',
278: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL' ,
279: P_ROLE_RESOURCE_ID => i.RESOURCE_ID,
280: P_ROLE_ID => l_Role_ID,
281: P_ROLE_CODE => 'COLLECTIONS',
282: P_START_DATE_ACTIVE => TRUNC(SYSDATE),

Line 301: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;

297: End Loop;
298:
299: COMMIT;
300:
301: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
302: fnd_file.put_line(FND_FILE.LOG,'Date and Time Finish '|| l_date_time );
303: fnd_file.put_line(FND_FILE.LOG,'No. of Collector(s) Added '|| l_colcount);
304:
305:

Line 343: AND jtrr.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'

339: FROM JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtv,
340: JTF_RS_RESOURCE_EXTNS jtr
341: WHERE jtv.ROLE_CODE = 'IEX_AGENT' AND jtv.role_id = jtrr.role_id
342: AND jtrr.role_resource_id = jtr.resource_id
343: AND jtrr.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'
344: AND jtr.source_id is not null)
345: AND employee_id not in (SELECT jtr.source_id from
346: jtf_rs_resource_extns jtr where source_id is not null)
347: AND resource_id is not null

Line 455: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;

451: L_RESOURCE_ID_LST RESOURCE_ID_LIST;
452:
453:
454: BEGIN
455: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
456: fnd_file.put_line(FND_FILE.LOG,'Date and Time Start conversion '|| l_date_time );
457:
458: OPEN C_ROLE_ID;
459: FETCH C_ROLE_ID INTO l_Role_id;

Line 521: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL' ,

517: JTF_RS_ROLE_RELATE_PUB.create_resource_role_relate
518: (P_API_VERSION => 1.0,
519: P_INIT_MSG_LIST => 'T',
520: P_COMMIT => 'T',
521: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL' ,
522: P_ROLE_RESOURCE_ID => L_RESOURCE_ID_LST(I),
523: P_ROLE_ID => l_Role_ID,
524: P_ROLE_CODE => 'COLLECTIONS',
525: P_START_DATE_ACTIVE => TRUNC(SYSDATE),

Line 709: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL' ,

705: JTF_RS_ROLE_RELATE_PUB.create_resource_role_relate
706: (P_API_VERSION => 1.0,
707: P_INIT_MSG_LIST => 'T',
708: P_COMMIT => 'F',
709: P_ROLE_RESOURCE_TYPE => 'RS_INDIVIDUAL' ,
710: P_ROLE_RESOURCE_ID => L_RESOURCE_ID,
711: P_ROLE_ID => l_Role_ID,
712: P_ROLE_CODE => 'COLLECTIONS',
713: P_START_DATE_ACTIVE => TRUNC(SYSDATE),

Line 735: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;

731:
732: l_resource_id := NULL;
733: l_resource_number := NULL;
734: END LOOP;
735: Select to_char(sysdate,'DD-MON-YYYY HH24:MM:SS') into l_date_time from dual;
736: fnd_file.put_line(FND_FILE.LOG,'Date and Time Finish '|| l_date_time );
737: FND_FILE.put_line(FND_FILE.LOG,'No. of. Resources Added := ' || l_colcount);
738:
739: COMMIT;