DBA Data[Home] [Help]

APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on FND_GLOBAL

Line 161: l_user_id := FND_GLOBAL.user_id;

157: l_resp_appl_id NUMBER;
158: BEGIN
159:
160: /*6329229*/
161: l_user_id := FND_GLOBAL.user_id;
162: l_resp_id := 24286;
163: l_resp_appl_id := 510;
164:
165:

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

174: -- wf_seq_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'TMPL_WF_SEQ_ID', false);
175:
176:
177: -- Set the database session context
178: fnd_global.apps_initialize(l_user_id,l_resp_id, l_resp_appl_id);
179:
180: RETURN;
181:
182: END IF;

Line 666: last_updated_by = fnd_global.user_id

662: UPDATE okc_terms_templates_all
663: SET status_code = 'PENDING_APPROVAL',
664: object_version_number = object_version_number + 1,
665: last_update_date = sysdate,
666: last_updated_by = fnd_global.user_id
667: WHERE template_id = p_template_id;
668:
669: l_processOwner := fnd_global.user_name;
670:

Line 669: l_processOwner := fnd_global.user_name;

665: last_update_date = sysdate,
666: last_updated_by = fnd_global.user_id
667: WHERE template_id = p_template_id;
668:
669: l_processOwner := fnd_global.user_name;
670:
671: --Bug 3570042
672: -- l_itemkey := substr(l_tmpl_rec.template_name,1,150)||':'||l_tmpl_rec.org_id||':'||l_tmpl_rec.wf_sequence;
673: -- l_ItemUserKey := l_ItemKey;

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

757: itemkey => l_itemkey,
758: aname => 'ORG_NAME',
759: avalue => l_org_name);
760:
761: --l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||fnd_global.local_chr(38)||'pk1name=TEMPLATE_ID'
762: -- ||fnd_global.local_chr(38)||'pk1value='||l_tmpl_rec.template_id||fnd_global.local_chr(38)
763: -- ||'pk2name=WF_SEQUENCE_ID'||fnd_global.local_chr(38)||'pk2value='||l_tmpl_rec.wf_sequence ;
764:
765: l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||'&pk1name=TEMPLATE_ID&pk1value='||

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

758: aname => 'ORG_NAME',
759: avalue => l_org_name);
760:
761: --l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||fnd_global.local_chr(38)||'pk1name=TEMPLATE_ID'
762: -- ||fnd_global.local_chr(38)||'pk1value='||l_tmpl_rec.template_id||fnd_global.local_chr(38)
763: -- ||'pk2name=WF_SEQUENCE_ID'||fnd_global.local_chr(38)||'pk2value='||l_tmpl_rec.wf_sequence ;
764:
765: l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||'&pk1name=TEMPLATE_ID&pk1value='||
766: l_tmpl_rec.template_id||'&pk2name=WF_SEQUENCE_ID&pk2value='||l_tmpl_rec.wf_sequence ;

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

759: avalue => l_org_name);
760:
761: --l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||fnd_global.local_chr(38)||'pk1name=TEMPLATE_ID'
762: -- ||fnd_global.local_chr(38)||'pk1value='||l_tmpl_rec.template_id||fnd_global.local_chr(38)
763: -- ||'pk2name=WF_SEQUENCE_ID'||fnd_global.local_chr(38)||'pk2value='||l_tmpl_rec.wf_sequence ;
764:
765: l_attach_key := 'FND:entity=OKC_TERMS_TEMPLATES'||'&pk1name=TEMPLATE_ID&pk1value='||
766: l_tmpl_rec.template_id||'&pk2name=WF_SEQUENCE_ID&pk2value='||l_tmpl_rec.wf_sequence ;
767: