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_DHMINTERFACE_GRP dependencies on FND_GLOBAL

Line 12: nl varchar2(1) := fnd_global.local_chr(10);

8: procedure convert_name (x_name IN OUT NOCOPY VARCHAR2)
9: is
10: i number;
11: j number;
12: nl varchar2(1) := fnd_global.local_chr(10);
13: begin
14: if (x_name is not null) then
15: i := 1;
16: j := instr (x_name, '''');

Line 198: fnd_global.user_id);

194:
195: x_return_status := FND_API.G_RET_STS_SUCCESS;
196:
197: l_shdw_id := nvl(sys_context('ZPB_CONTEXT', 'shadow_id'),
198: fnd_global.user_id);
199: l_apps_id := nvl(sys_context('ZPB_CONTEXT', 'user_id'), fnd_global.user_id);
200:
201: select USER_NAME
202: into l_user_name

Line 199: l_apps_id := nvl(sys_context('ZPB_CONTEXT', 'user_id'), fnd_global.user_id);

195: x_return_status := FND_API.G_RET_STS_SUCCESS;
196:
197: l_shdw_id := nvl(sys_context('ZPB_CONTEXT', 'shadow_id'),
198: fnd_global.user_id);
199: l_apps_id := nvl(sys_context('ZPB_CONTEXT', 'user_id'), fnd_global.user_id);
200:
201: select USER_NAME
202: into l_user_name
203: from FND_USER

Line 342: FND_GLOBAL.CURRENT_LANGUAGE||'''');

338: --
339: -- HACK: is this needed? Should this happen in startup?
340: --
341: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LangDim||' to '''||
342: FND_GLOBAL.CURRENT_LANGUAGE||'''');
343: --
344: -- Update the Dimension member security table:
345: --
346: l_command := 'delete from '||l_dim_table_name||' where USER_ID = '||

Line 436: fnd_global.login_id);

432: sysdate,
433: l_apps_id,
434: l_apps_id,
435: sysdate,
436: fnd_global.login_id);
437:
438: l_attr_dimdim := zpb_aw.interp
439: ('shw '||l_awQual||l_global_attr_ecm.RangeDimRel||
440: ' ('||l_awQual||l_global_ecm.AttrDim||' '''||l_attr||''')');

Line 485: l_apps_id||', sysdate, FND_GLOBAL.LOGIN_ID from '||

481: l_command := 'insert into '||each.MEMBER_PRIV_TABLE_NAME||
482: '(USER_ID, '||each.MEMBER_COL||',CREATION_DATE, CREATED_BY,'||
483: 'LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) select '||
484: l_apps_id||','||each.MEMBER_COL||',sysdate,'||l_apps_id||', '||
485: l_apps_id||', sysdate, FND_GLOBAL.LOGIN_ID from '||
486: each.MEMBER_B_TABLE_NAME;
487: execute immediate l_command;
488: end if;
489:

Line 514: FND_GLOBAL.LOGIN_ID);

510: sysdate,
511: l_apps_id,
512: l_apps_id,
513: sysdate,
514: FND_GLOBAL.LOGIN_ID);
515: end if;
516: end loop;
517: elsif (l_dim_data.Type = 'TIME') then
518: for each in l_epb_time_attrs loop

Line 544: FND_GLOBAL.LOGIN_ID);

540: sysdate,
541: l_apps_id,
542: l_apps_id,
543: sysdate,
544: FND_GLOBAL.LOGIN_ID);
545: end if;
546: end loop;
547: end if;
548:

Line 578: fnd_global.login_id

574: sysdate,
575: l_apps_id,
576: l_apps_id,
577: sysdate,
578: fnd_global.login_id
579: from ZPB_LAB_LEVELS_SCOPE_V
580: where DIMENSION = l_dim_data.ExpObj
581: and OBJECT_SHORT_LABEL not like '%LV_%';
582:

Line 682: fnd_global.login_id);

678: sysdate,
679: l_apps_id,
680: sysdate,
681: l_apps_id,
682: fnd_global.login_id);
683: end if;
684:
685: --
686: -- Update the Definition table:

Line 776: fnd_global.login_id);

772: sysdate,
773: l_apps_id,
774: sysdate,
775: l_apps_id,
776: fnd_global.login_id);
777:
778: insert into FEM_HIER_DEFINITIONS
779: (HIERARCHY_OBJ_DEF_ID,
780: CREATION_DATE,

Line 793: fnd_global.login_id,

789: sysdate,
790: l_apps_id,
791: l_apps_id,
792: sysdate,
793: fnd_global.login_id,
794: 1,
795: 'COMPLETED');
796:
797: --

Line 825: fnd_global.login_id,

821: sysdate,
822: '||l_apps_id||',
823: '||l_apps_id||',
824: sysdate,
825: fnd_global.login_id,
826: 1
827: from '||l_dim_view;
828:
829: execute immediate l_command;

Line 908: fnd_global.login_id,

904: sysdate,
905: l_apps_id,
906: l_apps_id,
907: sysdate,
908: fnd_global.login_id,
909: 'PLANNING',
910: l_multi_vs,
911: 1);
912: end if;

Line 991: fnd_global.login_id||',

987: sysdate, '||
988: l_apps_id||', '||
989: l_apps_id||',
990: sysdate, '||
991: fnd_global.login_id||',
992: 1 from '||l_dim_view||
993: ' where '||l_dim_pgid_col||
994: ' is not null and '||l_dim_order_col||' is not null';
995:

Line 1040: fnd_global.login_id||',

1036: sysdate, '||
1037: l_apps_id||', '||
1038: l_apps_id||',
1039: sysdate, '||
1040: fnd_global.login_id||',
1041: 1 from '||l_dim_view||
1042: ' where '||l_dim_gid_col||' = 0 and '||
1043: l_dim_pgid_col||
1044: ' is not null and '||l_dim_order_col||' is not null';

Line 1088: fnd_global.login_id||',

1084: sysdate, '||
1085: l_apps_id||', '||
1086: l_apps_id||',
1087: sysdate, '||
1088: fnd_global.login_id||',
1089: 1 from '||l_dim_view||
1090: ' where '||l_dim_pgid_col||' is null and '||
1091: l_dim_order_col||' is not null';
1092:

Line 1145: fnd_global.login_id||',

1141: sysdate, '||
1142: l_apps_id||', '||
1143: l_apps_id||',
1144: sysdate, '||
1145: fnd_global.login_id||',
1146: ''N'',
1147: 1 from '||l_dim_view||' where '||l_dim_view_col||
1148: ' in ('||l_dims||')';
1149: else

Line 1193: fnd_global.login_id||',

1189: sysdate, '||
1190: l_apps_id||', '||
1191: l_apps_id||',
1192: sysdate, '||
1193: fnd_global.login_id||',
1194: ''N'',
1195: 1 from '||l_dim_view||' where '||l_dim_view_col||
1196: ' in ('||l_dims||')';
1197: end if;

Line 1234: ''''||FND_GLOBAL.CURRENT_LANGUAGE||''',

1230: else
1231: l_command := l_command||l_dim_view_col||', ';
1232: end if;
1233: l_command := l_command||
1234: ''''||FND_GLOBAL.CURRENT_LANGUAGE||''',
1235: '''||FND_GLOBAL.CURRENT_LANGUAGE||''', '||
1236: zpb_metadata_names.get_dim_short_name_column(l_epb_dim)||', '||
1237: zpb_metadata_names.get_dim_long_name_column(l_epb_dim)||', ';
1238: if (l_dim_data.Type = 'TIME') then

Line 1235: '''||FND_GLOBAL.CURRENT_LANGUAGE||''', '||

1231: l_command := l_command||l_dim_view_col||', ';
1232: end if;
1233: l_command := l_command||
1234: ''''||FND_GLOBAL.CURRENT_LANGUAGE||''',
1235: '''||FND_GLOBAL.CURRENT_LANGUAGE||''', '||
1236: zpb_metadata_names.get_dim_short_name_column(l_epb_dim)||', '||
1237: zpb_metadata_names.get_dim_long_name_column(l_epb_dim)||', ';
1238: if (l_dim_data.Type = 'TIME') then
1239: l_command := l_command||'nvl('||

Line 1248: fnd_global.login_id||' from '||l_dim_view||' where '||l_dim_view_col||

1244: sysdate, '||
1245: l_apps_id||', '||
1246: l_apps_id||',
1247: sysdate, '||
1248: fnd_global.login_id||' from '||l_dim_view||' where '||l_dim_view_col||
1249: ' in ('||l_dims||')';
1250:
1251: execute immediate l_command;
1252:

Line 1386: fnd_global.login_id,

1382: sysdate,
1383: l_apps_id,
1384: l_apps_id,
1385: sysdate,
1386: fnd_global.login_id,
1387: 1);
1388: exit when m=0;
1389: end loop;
1390:

Line 1575: fnd_global.user_id);

1571:
1572: x_return_status := FND_API.G_RET_STS_SUCCESS;
1573:
1574: l_shdw_id := nvl(sys_context('ZPB_CONTEXT', 'shadow_id'),
1575: fnd_global.user_id);
1576: l_apps_id := nvl(sys_context('ZPB_CONTEXT', 'user_id'), fnd_global.user_id);
1577:
1578: zpb_aw.execute ('commas = no');
1579:

Line 1576: l_apps_id := nvl(sys_context('ZPB_CONTEXT', 'user_id'), fnd_global.user_id);

1572: x_return_status := FND_API.G_RET_STS_SUCCESS;
1573:
1574: l_shdw_id := nvl(sys_context('ZPB_CONTEXT', 'shadow_id'),
1575: fnd_global.user_id);
1576: l_apps_id := nvl(sys_context('ZPB_CONTEXT', 'user_id'), fnd_global.user_id);
1577:
1578: zpb_aw.execute ('commas = no');
1579:
1580: l_upd_date := 'to_date ('''||