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 656: l_cust_role := fnd_profile.value('OKL_CS_AGENT_CUST_RESPONSE');

652:
653: BEGIN
654: IF (funcmode = 'RUN') THEN
655:
656: l_cust_role := fnd_profile.value('OKL_CS_AGENT_CUST_RESPONSE');
657: IF l_cust_role IS NULL THEN
658: l_cust_role := 'SYSADMIN';
659: END IF;
660:

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

657: IF l_cust_role IS NULL THEN
658: l_cust_role := 'SYSADMIN';
659: END IF;
660:
661: l_credit_role := fnd_profile.value('OKL_CS_CREDIT_APPROVER');
662: IF l_credit_role IS NULL THEN
663: l_credit_role := 'SYSADMIN';
664: END IF;
665:

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

662: IF l_credit_role IS NULL THEN
663: l_credit_role := 'SYSADMIN';
664: END IF;
665:
666: l_ctr_admin_role := fnd_profile.value('OKL_CS_CONTRACT_ADMIN');
667: IF l_ctr_admin_role IS NULL THEN
668: l_ctr_admin_role := 'SYSADMIN';
669: END IF;
670:

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

667: IF l_ctr_admin_role IS NULL THEN
668: l_ctr_admin_role := 'SYSADMIN';
669: END IF;
670:
671: l_vendor_role := fnd_profile.value('OKL_CS_AGENT_VENDOR_RESPONSE');
672: IF l_vendor_role IS NULL THEN
673: l_vendor_role := 'SYSADMIN';
674: END IF;
675:

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

672: IF l_vendor_role IS NULL THEN
673: l_vendor_role := 'SYSADMIN';
674: END IF;
675:
676: l_collections_role := fnd_profile.value('OKL_CS_COLLECTIONS_APPROVER');
677: IF l_collections_role IS NULL THEN
678: l_collections_role := 'SYSADMIN';
679: END IF;
680:

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

1093:
1094: l_bind_var(1) := 'p_request_id';
1095: l_bind_val(1) := l_trx_id;
1096: l_bind_var_type(1) := 'NUMBER';
1097: l_agent_id := FND_PROFILE.VALUE('USER_ID');
1098: l_server_id := FND_PROFILE.VALUE('OKL_FM_SERVER');
1099:
1100: OPEN c_document(l_ptm_code);
1101: FETCH c_document INTO l_content_id,l_subject;

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

1094: l_bind_var(1) := 'p_request_id';
1095: l_bind_val(1) := l_trx_id;
1096: l_bind_var_type(1) := 'NUMBER';
1097: l_agent_id := FND_PROFILE.VALUE('USER_ID');
1098: l_server_id := FND_PROFILE.VALUE('OKL_FM_SERVER');
1099:
1100: OPEN c_document(l_ptm_code);
1101: FETCH c_document INTO l_content_id,l_subject;
1102: CLOSE c_document;

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

1215:
1216: l_bind_var(1) := 'p_request_id';
1217: l_bind_val(1) := l_trx_id;
1218: l_bind_var_type(1) := 'NUMBER';
1219: l_agent_id := FND_PROFILE.VALUE('USER_ID');
1220: l_server_id := FND_PROFILE.VALUE('OKL_FM_SERVER');
1221:
1222: OPEN c_document(l_ptm_code);
1223: FETCH c_document INTO l_content_id,l_subject;

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

1216: l_bind_var(1) := 'p_request_id';
1217: l_bind_val(1) := l_trx_id;
1218: l_bind_var_type(1) := 'NUMBER';
1219: l_agent_id := FND_PROFILE.VALUE('USER_ID');
1220: l_server_id := FND_PROFILE.VALUE('OKL_FM_SERVER');
1221:
1222: OPEN c_document(l_ptm_code);
1223: FETCH c_document INTO l_content_id,l_subject;
1224: CLOSE c_document;

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

3088: FETCH c_ctr_no INTO l_parent_contract_num;
3089: CLOSE c_ctr_no;
3090:
3091: --rkuttiya added for bug:2923037
3092: l_lease_renewal_role := fnd_profile.value('OKL_CTR_RENEWAL_REP');
3093: IF l_lease_renewal_role IS NULL THEN
3094: l_lease_renewal_role := 'SYSADMIN';
3095: END IF;
3096: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3408: FETCH c_ctr_no INTO l_contract_num;
3409: CLOSE c_ctr_no;
3410:
3411: --rkuttiya added for bug:2923037
3412: l_principal_paydown_role := fnd_profile.value('OKL_CTR_RESTRUCTURE_REP');
3413: IF l_principal_paydown_role IS NULL THEN
3414: l_principal_paydown_role := 'SYSADMIN';
3415: END IF;
3416: /*

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

3847: FETCH c_ctr_no INTO l_contract_num;
3848: CLOSE c_ctr_no;
3849:
3850: --rkuttiya added for bug:2923037
3851: l_approve_credit_memo_role := fnd_profile.value('OKL_CREDIT_MEMO_REP');
3852: IF l_approve_credit_memo_role IS NULL THEN
3853: l_approve_credit_memo_role := 'SYSADMIN';
3854: END IF;
3855: wf_engine.SetItemAttrText ( itemtype=> itemtype,