APPS.OKC_CHANGE_CONTRACT_PVT dependencies on FND_GLOBAL

Line 104: -- NVL(C.USER_ID,fnd_global.user_id) AUTH_USER_ID,

100: C.SHORT_DESCRIPTION CRT_SHORT_DESCRIPTION,
101: substr(K.CONTRACT_NUMBER
102: ||K.CONTRACT_NUMBER_MODIFIER
103: ||C.NAME,1,240) KEY,
104: -- NVL(C.USER_ID,fnd_global.user_id) AUTH_USER_ID,
105: NVL(C.USER_ID,OKC_API.G_MISS_NUM) AUTH_USER_ID,
106: U.USER_NAME AUTH_USERNAME,
107: C.AUTHORITY REQUESTOR,
108: C.SIGNATURE_REQUIRED_YN

Line 117: and U.USER_ID = NVL(cpr.USER_ID,fnd_global.user_id);

113: where C.ID = p_change_request_id
114: and K.ID = C.CHR_ID
115: and cpr.crt_id = C.ID
116: -- and U.USER_ID = NVL(cpr.USER_ID,OKC_API.G_MISS_NUM);
117: and U.USER_ID = NVL(cpr.USER_ID,fnd_global.user_id);
118: --
119: --
120: l_wf_name varchar2(150);
121: l_wf_process_name varchar2(150);

Line 533: avalue => fnd_global.user_id);

529: begin
530: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
531: itemkey => L_KEY,
532: aname => 'USER_ID',
533: avalue => fnd_global.user_id);
534: exception
535: when others then
536: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
537: itemkey => L_KEY,

Line 542: avalue => fnd_global.user_id);

538: aname => 'USER_ID');
539: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
540: itemkey => L_KEY,
541: aname => 'USER_ID',
542: avalue => fnd_global.user_id);
543: end;
544: begin
545: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
546: itemkey => L_KEY,

Line 548: avalue => fnd_global.resp_id);

544: begin
545: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
546: itemkey => L_KEY,
547: aname => 'RESP_ID',
548: avalue => fnd_global.resp_id);
549: exception
550: when others then
551: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
552: itemkey => L_KEY,

Line 557: avalue => fnd_global.resp_id);

553: aname => 'RESP_ID');
554: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
555: itemkey => L_KEY,
556: aname => 'RESP_ID',
557: avalue => fnd_global.resp_id);
558: end;
559: begin
560: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
561: itemkey => L_KEY,

Line 563: avalue => fnd_global.RESP_APPL_id);

559: begin
560: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
561: itemkey => L_KEY,
562: aname => 'RESP_APPL_ID',
563: avalue => fnd_global.RESP_APPL_id);
564: exception
565: when others then
566: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
567: itemkey => L_KEY,

Line 572: avalue => fnd_global.RESP_APPL_id);

568: aname => 'RESP_APPL_ID');
569: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
570: itemkey => L_KEY,
571: aname => 'RESP_APPL_ID',
572: avalue => fnd_global.RESP_APPL_id);
573: end;
574: select value into L_NLS_VALUE
575: from NLS_SESSION_PARAMETERS
576: where PARAMETER='NLS_LANGUAGE';

Line 648: owner => fnd_global.user_name);

644: avalue => L_NLS_VALUE);
645: end;
646: wf_engine.SetItemOwner ( itemtype => L_WF_NAME,
647: itemkey => L_KEY,
648: owner => fnd_global.user_name);
649: wf_engine.StartProcess( itemtype => L_WF_NAME,
650: itemkey => L_KEY);
651:
652: open cur_header_aa(l_contract_id);

Line 862: p_user_id => fnd_global.user_id,

858: -- user have U privilege?
859: --
860: if OKC_CONTRACT_APPROVAL_PUB.k_accesible(
861: p_contract_id => l_contract_id,
862: p_user_id => fnd_global.user_id,
863: p_level => 'U'
864: ) = OKC_API.G_FALSE
865: then
866: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1004: l_cpsv_rec.user_id := fnd_global.user_id;

1000: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1001: RAISE OKC_API.G_EXCEPTION_ERROR;
1002: END IF;
1003: l_cpsv_rec.in_process_yn := 'Y';
1004: l_cpsv_rec.user_id := fnd_global.user_id;
1005: OKC_CONTRACT_PUB.update_contract_process(
1006: p_api_version => p_api_version,
1007: x_return_status => l_return_status,
1008: x_msg_count => x_msg_count,