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

Line 168: l_user_id := FND_GLOBAL.user_id;

164:
165: BEGIN
166:
167: /*6329229, 7605085*/
168: l_user_id := FND_GLOBAL.user_id;
169: --l_resp_id := 24286;
170:
171: OPEN get_resp_id_csr;
172: FETCH get_resp_id_csr INTO l_resp_id;

Line 190: fnd_global.apps_initialize(l_user_id,l_resp_id, l_resp_appl_id);

186: -- wf_seq_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);
187:
188:
189: -- Set the database session context
190: fnd_global.apps_initialize(l_user_id,l_resp_id, l_resp_appl_id);
191:
192: RETURN;
193:
194: END IF;

Line 681: last_updated_by = fnd_global.user_id

677: UPDATE okc_terms_templates_all
678: SET status_code = 'PENDING_APPROVAL',
679: object_version_number = object_version_number + 1,
680: last_update_date = sysdate,
681: last_updated_by = fnd_global.user_id
682: WHERE template_id = p_template_id;
683:
684: l_processOwner := fnd_global.user_name;
685:

Line 684: l_processOwner := fnd_global.user_name;

680: last_update_date = sysdate,
681: last_updated_by = fnd_global.user_id
682: WHERE template_id = p_template_id;
683:
684: l_processOwner := fnd_global.user_name;
685:
686: --Bug 3570042
687: -- l_itemkey := substr(l_tmpl_rec.template_name,1,150)||':'||l_tmpl_rec.org_id||':'||l_tmpl_rec.wf_sequence;
688: -- l_ItemUserKey := l_ItemKey;

Line 776: --l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||fnd_global.local_chr(38)||'pk1name=TEMPLATE_ID'

772: itemkey => l_itemkey,
773: aname => 'ORG_NAME',
774: avalue => l_org_name);
775:
776: --l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||fnd_global.local_chr(38)||'pk1name=TEMPLATE_ID'
777: -- ||fnd_global.local_chr(38)||'pk1value='||l_tmpl_rec.template_id||fnd_global.local_chr(38)
778: -- ||'pk2name=WF_SEQUENCE_ID'||fnd_global.local_chr(38)||'pk2value='||l_tmpl_rec.wf_sequence ;
779:
780: l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||'&pk1name=TEMPLATE_ID&pk1value='||

Line 777: -- ||fnd_global.local_chr(38)||'pk1value='||l_tmpl_rec.template_id||fnd_global.local_chr(38)

773: aname => 'ORG_NAME',
774: avalue => l_org_name);
775:
776: --l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||fnd_global.local_chr(38)||'pk1name=TEMPLATE_ID'
777: -- ||fnd_global.local_chr(38)||'pk1value='||l_tmpl_rec.template_id||fnd_global.local_chr(38)
778: -- ||'pk2name=WF_SEQUENCE_ID'||fnd_global.local_chr(38)||'pk2value='||l_tmpl_rec.wf_sequence ;
779:
780: l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||'&pk1name=TEMPLATE_ID&pk1value='||
781: l_tmpl_rec.template_id||'&pk2name=WF_SEQUENCE_ID&pk2value='||l_tmpl_rec.wf_sequence ;

Line 778: -- ||'pk2name=WF_SEQUENCE_ID'||fnd_global.local_chr(38)||'pk2value='||l_tmpl_rec.wf_sequence ;

774: avalue => l_org_name);
775:
776: --l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||fnd_global.local_chr(38)||'pk1name=TEMPLATE_ID'
777: -- ||fnd_global.local_chr(38)||'pk1value='||l_tmpl_rec.template_id||fnd_global.local_chr(38)
778: -- ||'pk2name=WF_SEQUENCE_ID'||fnd_global.local_chr(38)||'pk2value='||l_tmpl_rec.wf_sequence ;
779:
780: l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||'&pk1name=TEMPLATE_ID&pk1value='||
781: l_tmpl_rec.template_id||'&pk2name=WF_SEQUENCE_ID&pk2value='||l_tmpl_rec.wf_sequence ;
782:

Line 986: last_updated_by = FND_GLOBAL.USER_ID,

982: ELSE
983:
984: UPDATE Okc_Xprt_Question_Orders
985: SET runtime_available_flag = 'Y',
986: last_updated_by = FND_GLOBAL.USER_ID,
987: last_update_date = SYSDATE,
988: last_update_login = FND_GLOBAL.LOGIN_ID
989: WHERE template_id= l_tmpl_id
990: AND question_rule_status = 'ACTIVE';

Line 988: last_update_login = FND_GLOBAL.LOGIN_ID

984: UPDATE Okc_Xprt_Question_Orders
985: SET runtime_available_flag = 'Y',
986: last_updated_by = FND_GLOBAL.USER_ID,
987: last_update_date = SYSDATE,
988: last_update_login = FND_GLOBAL.LOGIN_ID
989: WHERE template_id= l_tmpl_id
990: AND question_rule_status = 'ACTIVE';
991:
992: -- Delete from okc_xprt_template_rules