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.OKL_CS_WF dependencies on FND_PROFILE

Line 45: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));

41:
42: IF l_id is not NULL
43: THEN
44: OPEN Get_Message_Num (l_message_name, l_id,
45: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));
46: FETCH Get_Message_Num into l_message_num;
47: CLOSE Get_Message_Num;
48: END IF;
49:

Line 284: l_restruct_role := fnd_profile.value('OKL_CTR_RESTRUCTURE_REP');

280: CLOSE okl_contract_number;
281:
282: --This should be populated from the DB.
283: --rkuttiya added for bug:2923037
284: l_restruct_role := fnd_profile.value('OKL_CTR_RESTRUCTURE_REP');
285: IF l_restruct_role IS NULL THEN
286: l_restruct_role := 'SYSADMIN';
287: END IF;
288: l_request_number := x_thpv_tbl(1).trans_number;

Line 665: l_cust_role := fnd_profile.value('OKL_CS_AGENT_CUST_RESPONSE');

661:
662: BEGIN
663: IF (funcmode = 'RUN') THEN
664:
665: l_cust_role := fnd_profile.value('OKL_CS_AGENT_CUST_RESPONSE');
666: IF l_cust_role IS NULL THEN
667: l_cust_role := 'SYSADMIN';
668: END IF;
669:

Line 670: l_credit_role := fnd_profile.value('OKL_CS_CREDIT_APPROVER');

666: IF l_cust_role IS NULL THEN
667: l_cust_role := 'SYSADMIN';
668: END IF;
669:
670: l_credit_role := fnd_profile.value('OKL_CS_CREDIT_APPROVER');
671: IF l_credit_role IS NULL THEN
672: l_credit_role := 'SYSADMIN';
673: END IF;
674:

Line 675: l_ctr_admin_role := fnd_profile.value('OKL_CS_CONTRACT_ADMIN');

671: IF l_credit_role IS NULL THEN
672: l_credit_role := 'SYSADMIN';
673: END IF;
674:
675: l_ctr_admin_role := fnd_profile.value('OKL_CS_CONTRACT_ADMIN');
676: IF l_ctr_admin_role IS NULL THEN
677: l_ctr_admin_role := 'SYSADMIN';
678: END IF;
679:

Line 680: l_vendor_role := fnd_profile.value('OKL_CS_AGENT_VENDOR_RESPONSE');

676: IF l_ctr_admin_role IS NULL THEN
677: l_ctr_admin_role := 'SYSADMIN';
678: END IF;
679:
680: l_vendor_role := fnd_profile.value('OKL_CS_AGENT_VENDOR_RESPONSE');
681: IF l_vendor_role IS NULL THEN
682: l_vendor_role := 'SYSADMIN';
683: END IF;
684:

Line 685: l_collections_role := fnd_profile.value('OKL_CS_COLLECTIONS_APPROVER');

681: IF l_vendor_role IS NULL THEN
682: l_vendor_role := 'SYSADMIN';
683: END IF;
684:
685: l_collections_role := fnd_profile.value('OKL_CS_COLLECTIONS_APPROVER');
686: IF l_collections_role IS NULL THEN
687: l_collections_role := 'SYSADMIN';
688: END IF;
689:

Line 1106: l_agent_id := FND_PROFILE.VALUE('USER_ID');

1102:
1103: l_bind_var(1) := 'p_request_id';
1104: l_bind_val(1) := l_trx_id;
1105: l_bind_var_type(1) := 'NUMBER';
1106: l_agent_id := FND_PROFILE.VALUE('USER_ID');
1107: l_server_id := FND_PROFILE.VALUE('OKL_FM_SERVER');
1108:
1109: OPEN c_document(l_ptm_code);
1110: FETCH c_document INTO l_content_id,l_subject;

Line 1107: l_server_id := FND_PROFILE.VALUE('OKL_FM_SERVER');

1103: l_bind_var(1) := 'p_request_id';
1104: l_bind_val(1) := l_trx_id;
1105: l_bind_var_type(1) := 'NUMBER';
1106: l_agent_id := FND_PROFILE.VALUE('USER_ID');
1107: l_server_id := FND_PROFILE.VALUE('OKL_FM_SERVER');
1108:
1109: OPEN c_document(l_ptm_code);
1110: FETCH c_document INTO l_content_id,l_subject;
1111: CLOSE c_document;

Line 1228: l_agent_id := FND_PROFILE.VALUE('USER_ID');

1224:
1225: l_bind_var(1) := 'p_request_id';
1226: l_bind_val(1) := l_trx_id;
1227: l_bind_var_type(1) := 'NUMBER';
1228: l_agent_id := FND_PROFILE.VALUE('USER_ID');
1229: l_server_id := FND_PROFILE.VALUE('OKL_FM_SERVER');
1230:
1231: OPEN c_document(l_ptm_code);
1232: FETCH c_document INTO l_content_id,l_subject;

Line 1229: l_server_id := FND_PROFILE.VALUE('OKL_FM_SERVER');

1225: l_bind_var(1) := 'p_request_id';
1226: l_bind_val(1) := l_trx_id;
1227: l_bind_var_type(1) := 'NUMBER';
1228: l_agent_id := FND_PROFILE.VALUE('USER_ID');
1229: l_server_id := FND_PROFILE.VALUE('OKL_FM_SERVER');
1230:
1231: OPEN c_document(l_ptm_code);
1232: FETCH c_document INTO l_content_id,l_subject;
1233: CLOSE c_document;

Line 3101: l_lease_renewal_role := fnd_profile.value('OKL_CTR_RENEWAL_REP');

3097: FETCH c_ctr_no INTO l_parent_contract_num;
3098: CLOSE c_ctr_no;
3099:
3100: --rkuttiya added for bug:2923037
3101: l_lease_renewal_role := fnd_profile.value('OKL_CTR_RENEWAL_REP');
3102: IF l_lease_renewal_role IS NULL THEN
3103: l_lease_renewal_role := 'SYSADMIN';
3104: END IF;
3105: wf_engine.SetItemAttrText ( itemtype=> itemtype,

Line 3421: l_principal_paydown_role := fnd_profile.value('OKL_CTR_RESTRUCTURE_REP');

3417: FETCH c_ctr_no INTO l_contract_num;
3418: CLOSE c_ctr_no;
3419:
3420: --rkuttiya added for bug:2923037
3421: l_principal_paydown_role := fnd_profile.value('OKL_CTR_RESTRUCTURE_REP');
3422: IF l_principal_paydown_role IS NULL THEN
3423: l_principal_paydown_role := 'SYSADMIN';
3424: END IF;
3425: /*

Line 3860: l_approve_credit_memo_role := fnd_profile.value('OKL_CREDIT_MEMO_REP');

3856: FETCH c_ctr_no INTO l_contract_num;
3857: CLOSE c_ctr_no;
3858:
3859: --rkuttiya added for bug:2923037
3860: l_approve_credit_memo_role := fnd_profile.value('OKL_CREDIT_MEMO_REP');
3861: IF l_approve_credit_memo_role IS NULL THEN
3862: l_approve_credit_memo_role := 'SYSADMIN';
3863: END IF;
3864: wf_engine.SetItemAttrText ( itemtype=> itemtype,