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

Line 294: wf_engine.SetItemOwner( 'OKCARTAP', cv_imp_rec.ikey, fnd_global.user_name);

290: loop
291: begin
292: wf_engine.CreateProcess( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLES_AFTER_IMPORT_PROC');
293: wf_engine.SetItemUserKey( 'OKCARTAP', cv_imp_rec.ikey, cv_imp_rec.ukey);
294: wf_engine.SetItemOwner( 'OKCARTAP', cv_imp_rec.ikey, fnd_global.user_name);
295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);
296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);
297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);
298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);

Line 295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);

291: begin
292: wf_engine.CreateProcess( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLES_AFTER_IMPORT_PROC');
293: wf_engine.SetItemUserKey( 'OKCARTAP', cv_imp_rec.ikey, cv_imp_rec.ukey);
294: wf_engine.SetItemOwner( 'OKCARTAP', cv_imp_rec.ikey, fnd_global.user_name);
295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);
296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);
297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);
298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);
299: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_ID', cv_imp_rec.article_id);

Line 296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);

292: wf_engine.CreateProcess( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLES_AFTER_IMPORT_PROC');
293: wf_engine.SetItemUserKey( 'OKCARTAP', cv_imp_rec.ikey, cv_imp_rec.ukey);
294: wf_engine.SetItemOwner( 'OKCARTAP', cv_imp_rec.ikey, fnd_global.user_name);
295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);
296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);
297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);
298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);
299: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_ID', cv_imp_rec.article_id);
300: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_VERSION_ID', cv_imp_rec.article_version_id);

Line 297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);

293: wf_engine.SetItemUserKey( 'OKCARTAP', cv_imp_rec.ikey, cv_imp_rec.ukey);
294: wf_engine.SetItemOwner( 'OKCARTAP', cv_imp_rec.ikey, fnd_global.user_name);
295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);
296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);
297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);
298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);
299: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_ID', cv_imp_rec.article_id);
300: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_VERSION_ID', cv_imp_rec.article_version_id);
301: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_STATUS', cv_imp_rec.article_status);

Line 304: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR', fnd_global.user_name);

300: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_VERSION_ID', cv_imp_rec.article_version_id);
301: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_STATUS', cv_imp_rec.article_status);
302: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ADOPTION_TYPE', cv_imp_rec.adoption_type);
303: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'GLOBAL_YN', cv_imp_rec.global_yn);
304: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR', fnd_global.user_name);
305: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
306: wf_engine.StartProcess('OKCARTAP' , cv_imp_rec.ikey);
307:
308: IF j = 500 THEN

Line 305: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));

301: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_STATUS', cv_imp_rec.article_status);
302: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ADOPTION_TYPE', cv_imp_rec.adoption_type);
303: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'GLOBAL_YN', cv_imp_rec.global_yn);
304: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR', fnd_global.user_name);
305: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
306: wf_engine.StartProcess('OKCARTAP' , cv_imp_rec.ikey);
307:
308: IF j = 500 THEN
309: commit;

Line 468: last_updated_by = fnd_global.user_id

464: set
465: article_status = 'PENDING_APPROVAL',
466: object_version_number = c_tab(write_ptr).ovn,
467: last_update_date = sysdate,
468: last_updated_by = fnd_global.user_id
469: where current of cv;
470: */
471: close cv;
472: -- to be sure that there is no such item_key in workflow

Line 551: last_updated_by = fnd_global.user_id

547: adoption_type = 'ADOPTED',
548: adoption_status = 'PENDING_APPROVAL',
549: object_version_number = c_tab(write_ptr).ovn,
550: last_update_date = sysdate,
551: last_updated_by = fnd_global.user_id
552: where current of ca;
553: */
554: close ca;
555: -- to be sure that there is no such item_key in workflow

Line 1128: fnd_global.apps_initialize(user_id, resp_id, resp_appl_id);

1124: resp_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'RESP_ID', true);
1125: resp_appl_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'RESP_APPL_ID', true);
1126: -- set apps context if needed
1127: if ( command = 'SET_CTX' ) then
1128: fnd_global.apps_initialize(user_id, resp_id, resp_appl_id);
1129: mo_global.set_policy_context('S', org_id);
1130: resultout := 'COMPLETE'; -- context is set up
1131: return;
1132: end if;

Line 1282: -- somehow fnd_global.user_name doesn't work !!!

1278: itemkey, to_char(actid), funcmode);
1279: raise;
1280: end;
1281:
1282: -- somehow fnd_global.user_name doesn't work !!!
1283: function user_name return varchar2
1284: is
1285: cursor c_usr is
1286: select user_name

Line 1288: where user_id = fnd_global.user_id;

1284: is
1285: cursor c_usr is
1286: select user_name
1287: from fnd_user_view
1288: where user_id = fnd_global.user_id;
1289: user_name fnd_user_view.user_name%type;
1290: begin
1291: user_name := null;
1292: open c_usr;

Line 1311: user_id := fnd_global.user_id;

1307: resp_id number;
1308: resp_appl_id number;
1309: begin
1310: -- get current apps context params
1311: user_id := fnd_global.user_id;
1312: resp_id := fnd_global.resp_id;
1313: resp_appl_id := fnd_global.resp_appl_id;
1314:
1315: result := 'OK';

Line 1312: resp_id := fnd_global.resp_id;

1308: resp_appl_id number;
1309: begin
1310: -- get current apps context params
1311: user_id := fnd_global.user_id;
1312: resp_id := fnd_global.resp_id;
1313: resp_appl_id := fnd_global.resp_appl_id;
1314:
1315: result := 'OK';
1316: for i in 1..write_ptr

Line 1313: resp_appl_id := fnd_global.resp_appl_id;

1309: begin
1310: -- get current apps context params
1311: user_id := fnd_global.user_id;
1312: resp_id := fnd_global.resp_id;
1313: resp_appl_id := fnd_global.resp_appl_id;
1314:
1315: result := 'OK';
1316: for i in 1..write_ptr
1317: loop

Line 1321: wf_engine.SetItemOwner( 'OKCARTAP', c_tab(i).ikey, fnd_global.user_name);

1317: loop
1318: begin
1319: wf_engine.CreateProcess( 'OKCARTAP', c_tab(i).ikey, 'ARTICLES_APPROVAL_ROOT_PROC');
1320: wf_engine.SetItemUserKey( 'OKCARTAP', c_tab(i).ikey, c_tab(i).ukey);
1321: wf_engine.SetItemOwner( 'OKCARTAP', c_tab(i).ikey, fnd_global.user_name);
1322: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'USER_ID', user_id);
1323: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_ID', resp_id);
1324: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_APPL_ID', resp_appl_id);
1325: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ORG_ID', c_tab(i).org_id);

Line 1331: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR', fnd_global.user_name);

1327: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_VERSION_ID', c_tab(i).article_version_id);
1328: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_STATUS', c_tab(i).article_status);
1329: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ADOPTION_TYPE', c_tab(i).adoption_type);
1330: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'GLOBAL_YN', c_tab(i).global_yn);
1331: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR', fnd_global.user_name);
1332: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
1333: wf_engine.StartProcess('OKCARTAP' , c_tab(i).ikey);
1334: commit;
1335: exception

Line 1332: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));

1328: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_STATUS', c_tab(i).article_status);
1329: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ADOPTION_TYPE', c_tab(i).adoption_type);
1330: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'GLOBAL_YN', c_tab(i).global_yn);
1331: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR', fnd_global.user_name);
1332: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
1333: wf_engine.StartProcess('OKCARTAP' , c_tab(i).ikey);
1334: commit;
1335: exception
1336: when others then