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.IEU_DIAG_AUDIT_TRACK_PVT dependencies on FND_GLOBAL

Line 88: where group_id = cur_rec.owner_id and language = FND_GLOBAL.CURRENT_LANGUAGE;

84: if cur_rec.owner_type = 'RS_GROUP' then
85: begin
86: select group_name into owner_name
87: from jtf_rs_groups_tl
88: where group_id = cur_rec.owner_id and language = FND_GLOBAL.CURRENT_LANGUAGE;
89: exception
90: when no_data_found then null;
91: end;
92: else

Line 116: where group_id = cur_rec.assignee_id and language = FND_GLOBAL.CURRENT_LANGUAGE;

112: else
113: begin
114: select group_name into assignee_name
115: from jtf_rs_groups_tl
116: where group_id = cur_rec.assignee_id and language = FND_GLOBAL.CURRENT_LANGUAGE;
117: exception
118: when no_data_found then null;
119: end;
120: end if;

Line 129: and language = FND_GLOBAL.CURRENT_LANGUAGE;

125: begin
126: select name into priority
127: from ieu_uwqm_priorities_tl
128: where priority_id = cur_rec.priority_id
129: and language = FND_GLOBAL.CURRENT_LANGUAGE;
130: exception
131: when no_data_found then null;
132: end;
133: end if;

Line 140: and language = FND_GLOBAL.CURRENT_LANGUAGE;

136: begin
137: select ws_name into l_ws_name
138: from ieu_uwqm_work_sources_tl
139: where ws_id = cur_rec.ws_id
140: and language = FND_GLOBAL.CURRENT_LANGUAGE;
141: exception
142: when no_data_found then null;
143: end;
144: end if;

Line 313: where group_id = cur_rec.owner_id and language = FND_GLOBAL.CURRENT_LANGUAGE;

309: if cur_rec.owner_type = 'RS_GROUP' then
310: begin
311: select group_name into owner_name
312: from jtf_rs_groups_tl
313: where group_id = cur_rec.owner_id and language = FND_GLOBAL.CURRENT_LANGUAGE;
314: exception
315: when no_data_found then null;
316: end;
317: else

Line 341: where group_id = cur_rec.assignee_id and language = FND_GLOBAL.CURRENT_LANGUAGE;

337: else
338: begin
339: select group_name into assignee_name
340: from jtf_rs_groups_tl
341: where group_id = cur_rec.assignee_id and language = FND_GLOBAL.CURRENT_LANGUAGE;
342: exception
343: when no_data_found then null;
344: end;
345: end if;

Line 355: and language = FND_GLOBAL.CURRENT_LANGUAGE;

351: begin
352: select name into priority
353: from ieu_uwqm_priorities_tl
354: where priority_id = cur_rec.priority_id
355: and language = FND_GLOBAL.CURRENT_LANGUAGE;
356: exception
357: when no_data_found then null;
358: end;
359: end if;

Line 366: and language = FND_GLOBAL.CURRENT_LANGUAGE;

362: begin
363: select ws_name into l_ws_name
364: from ieu_uwqm_work_sources_tl
365: where ws_id = cur_rec.ws_id
366: and language = FND_GLOBAL.CURRENT_LANGUAGE;
367: exception
368: when no_data_found then null;
369: end;
370: end if;

Line 515: where group_id = cur_rec.owner_id_prev and language = FND_GLOBAL.CURRENT_LANGUAGE;

511: if cur_rec.owner_type_prev = 'RS_GROUP' then
512: begin
513: select group_name into owner_name_prev
514: from jtf_rs_groups_tl
515: where group_id = cur_rec.owner_id_prev and language = FND_GLOBAL.CURRENT_LANGUAGE;
516: exception
517: when no_data_found then null;
518: end;
519: else

Line 543: where group_id = cur_rec.assignee_id_prev and language = FND_GLOBAL.CURRENT_LANGUAGE;

539: else
540: begin
541: select group_name into assignee_name_prev
542: from jtf_rs_groups_tl
543: where group_id = cur_rec.assignee_id_prev and language = FND_GLOBAL.CURRENT_LANGUAGE;
544: exception
545: when no_data_found then null;
546: end;
547: end if;

Line 554: where group_id = cur_rec.owner_id_curr and language = FND_GLOBAL.CURRENT_LANGUAGE;

550: if cur_rec.owner_type_curr = 'RS_GROUP' then
551: begin
552: select group_name into owner_name_curr
553: from jtf_rs_groups_tl
554: where group_id = cur_rec.owner_id_curr and language = FND_GLOBAL.CURRENT_LANGUAGE;
555: exception
556: when no_data_found then null;
557: end;
558: else

Line 582: where group_id = cur_rec.assignee_id_curr and language = FND_GLOBAL.CURRENT_LANGUAGE;

578: else
579: begin
580: select group_name into assignee_name_curr
581: from jtf_rs_groups_tl
582: where group_id = cur_rec.assignee_id_curr and language = FND_GLOBAL.CURRENT_LANGUAGE;
583: exception
584: when no_data_found then null;
585: end;
586: end if;

Line 594: and tl.language = FND_GLOBAL.CURRENT_LANGUAGE

590: begin
591: select ws_name into l_ws_name
592: from ieu_uwqm_work_sources_tl tl, ieu_uwqm_work_sources_b b
593: where b.ws_id = tl.ws_id
594: and tl.language = FND_GLOBAL.CURRENT_LANGUAGE
595: and b.ws_code=cur_rec.ws_code;
596: exception
597: when no_data_found then null;
598: end;

Line 754: where group_id = cur_rec.owner_id_prev and language = FND_GLOBAL.CURRENT_LANGUAGE;

750: if cur_rec.owner_type_prev = 'RS_GROUP' then
751: begin
752: select group_name into owner_name_prev
753: from jtf_rs_groups_tl
754: where group_id = cur_rec.owner_id_prev and language = FND_GLOBAL.CURRENT_LANGUAGE;
755: exception
756: when no_data_found then null;
757: end;
758: else

Line 782: where group_id = cur_rec.assignee_id_prev and language = FND_GLOBAL.CURRENT_LANGUAGE;

778: else
779: begin
780: select group_name into assignee_name_prev
781: from jtf_rs_groups_tl
782: where group_id = cur_rec.assignee_id_prev and language = FND_GLOBAL.CURRENT_LANGUAGE;
783: exception
784: when no_data_found then null;
785: end;
786: end if;

Line 793: where group_id = cur_rec.owner_id_curr and language = FND_GLOBAL.CURRENT_LANGUAGE;

789: if cur_rec.owner_type_curr = 'RS_GROUP' then
790: begin
791: select group_name into owner_name_curr
792: from jtf_rs_groups_tl
793: where group_id = cur_rec.owner_id_curr and language = FND_GLOBAL.CURRENT_LANGUAGE;
794: exception
795: when no_data_found then null;
796: end;
797: else

Line 821: where group_id = cur_rec.assignee_id_curr and language = FND_GLOBAL.CURRENT_LANGUAGE;

817: else
818: begin
819: select group_name into assignee_name_curr
820: from jtf_rs_groups_tl
821: where group_id = cur_rec.assignee_id_curr and language = FND_GLOBAL.CURRENT_LANGUAGE;
822: exception
823: when no_data_found then null;
824: end;
825: end if;

Line 833: and tl.language = FND_GLOBAL.CURRENT_LANGUAGE

829: begin
830: select ws_name into l_ws_name
831: from ieu_uwqm_work_sources_tl tl, ieu_uwqm_work_sources_b b
832: where b.ws_id = tl.ws_id
833: and tl.language = FND_GLOBAL.CURRENT_LANGUAGE
834: and b.ws_code=cur_rec.ws_code;
835: exception
836: when no_data_found then null;
837: end;

Line 975: where group_id = cur_rec.owner_id and language = FND_GLOBAL.CURRENT_LANGUAGE;

971: if cur_rec.owner_type = 'RS_GROUP' then
972: begin
973: select group_name into owner_name
974: from jtf_rs_groups_tl
975: where group_id = cur_rec.owner_id and language = FND_GLOBAL.CURRENT_LANGUAGE;
976: exception
977: when no_data_found then null;
978: end;
979: else

Line 1003: where group_id = cur_rec.assignee_id and language = FND_GLOBAL.CURRENT_LANGUAGE;

999: else
1000: begin
1001: select group_name into assignee_name
1002: from jtf_rs_groups_tl
1003: where group_id = cur_rec.assignee_id and language = FND_GLOBAL.CURRENT_LANGUAGE;
1004: exception
1005: when no_data_found then null;
1006: end;
1007: end if;

Line 1017: and language = FND_GLOBAL.CURRENT_LANGUAGE;

1013: begin
1014: select name into priority
1015: from ieu_uwqm_priorities_tl
1016: where priority_id = cur_rec.priority_id
1017: and language = FND_GLOBAL.CURRENT_LANGUAGE;
1018: exception
1019: when no_data_found then null;
1020: end;
1021: end if;

Line 1029: and language = FND_GLOBAL.CURRENT_LANGUAGE;

1025: begin
1026: select ws_name into l_ws_name
1027: from ieu_uwqm_work_sources_tl
1028: where ws_id = cur_rec.ws_id
1029: and language = FND_GLOBAL.CURRENT_LANGUAGE;
1030: exception
1031: when no_data_found then null;
1032: end;
1033: end if;

Line 1126: and tl.language = FND_GLOBAL.CURRENT_LANGUAGE

1122: AND a.owner_id_curr = rs1.group_id(+)
1123: AND a.assignee_id_curr = rs2.resource_id(+)
1124: and a.workitem_obj_code = b.object_code
1125: and b.ws_id = tl.ws_id
1126: and tl.language = FND_GLOBAL.CURRENT_LANGUAGE
1127: AND not exists
1128: (select 1 from jtf_rs_group_members
1129: where group_id = a.owner_id_curr
1130: and resource_id = a.assignee_id_curr

Line 1170: and rs1.language=FND_GLOBAL.CURRENT_LANGUAGE

1166: and a.workitem_obj_code = b.object_code
1167: and b.ws_id = tl.ws_id
1168: AND a.owner_id_curr = rs1.group_id(+)
1169: AND a.assignee_id_curr = rs2.resource_id(+)
1170: and rs1.language=FND_GLOBAL.CURRENT_LANGUAGE
1171: AND not exists
1172: (select 1 from jtf_rs_group_members
1173: where group_id = a.owner_id_curr
1174: and resource_id = a.assignee_id_curr

Line 1193: and tl.language = FND_GLOBAL.CURRENT_LANGUAGE

1189: --dbms_output.put_line('extened');
1190: /* select ws_name into l_ws_name
1191: from ieu_uwqm_work_sources_tl tl, ieu_uwqm_work_sources_b b
1192: where b.ws_id = tl.ws_id
1193: and tl.language = FND_GLOBAL.CURRENT_LANGUAGE
1194: and b.ws_code=cur_rec.ws_code;
1195: */
1196: x_results(x_results.last) :=IEU_DIAG_NOTMEMBER_OBJ(cur_rec.workitem_pk_id,
1197: cur_rec.workitem_obj_code,

Line 1371: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1367: fnd_msg_pub.delete_msg();
1368: x_return_status := fnd_api.g_ret_sts_success;
1369: FND_MSG_PUB.initialize;
1370: x_results := IEU_DIAG_WORKLIFE_NST();
1371: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1372:
1373: current_m :='';
1374: current_meaning :='';
1375: meaning1 :='';