DBA Data[Home] [Help]

APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on FND_PROFILE

Line 2123: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name

2119: OPEN sel_jsp_name_csr;
2120: FETCH sel_jsp_name_csr INTO l_jsp_name;
2121: CLOSE sel_jsp_name_csr;
2122:
2123: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
2124: || '?srID=' || sel_link_rec.incident_number;
2125:
2126: --l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/ibuSRDetails.jsp?srID=' || sel_link_rec.incident_number;
2127: WF_ENGINE.SetItemAttrText(

Line 2126: --l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/ibuSRDetails.jsp?srID=' || sel_link_rec.incident_number;

2122:
2123: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
2124: || '?srID=' || sel_link_rec.incident_number;
2125:
2126: --l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/ibuSRDetails.jsp?srID=' || sel_link_rec.incident_number;
2127: WF_ENGINE.SetItemAttrText(
2128: itemtype => itemtype,
2129: itemkey => itemkey,
2130: aname => 'NTFY_REQUEST_NUMBER_URL',

Line 2453: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name

2449: OPEN sel_jsp_name_csr;
2450: FETCH sel_jsp_name_csr INTO l_jsp_name;
2451: CLOSE sel_jsp_name_csr;
2452:
2453: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
2454: || '?srID=' || l_request_number;
2455:
2456: --l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/ibuSRDetails.jsp?srID=' || l_request_number;
2457: WF_ENGINE.SetItemAttrText(

Line 2456: --l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/ibuSRDetails.jsp?srID=' || l_request_number;

2452:
2453: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
2454: || '?srID=' || l_request_number;
2455:
2456: --l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/ibuSRDetails.jsp?srID=' || l_request_number;
2457: WF_ENGINE.SetItemAttrText(
2458: itemtype => itemtype,
2459: itemkey => itemkey,
2460: aname => 'NTFY_REQUEST_NUMBER_URL',

Line 2848: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name

2844: OPEN sel_jsp_name_csr;
2845: FETCH sel_jsp_name_csr INTO l_jsp_name;
2846: CLOSE sel_jsp_name_csr;
2847:
2848: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
2849: || '?srID=' || l_request_number;
2850:
2851: WF_ENGINE.SetItemAttrText(
2852: itemtype => itemtype,

Line 3164: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name

3160: OPEN sel_jsp_name_csr;
3161: FETCH sel_jsp_name_csr INTO l_jsp_name;
3162: CLOSE sel_jsp_name_csr;
3163:
3164: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
3165: || '?srID=' || l_request_number;
3166: WF_ENGINE.SetItemAttrText(
3167: itemtype => itemtype,
3168: itemkey => itemkey,

Line 3346: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name

3342: OPEN sel_jsp_name_csr;
3343: FETCH sel_jsp_name_csr INTO l_jsp_name;
3344: CLOSE sel_jsp_name_csr;
3345:
3346: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
3347: || '?srID=' || l_request_number;
3348: WF_ENGINE.SetItemAttrText(
3349: itemtype => itemtype,
3350: itemkey => itemkey,

Line 3624: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name

3620: OPEN sel_jsp_name_csr;
3621: FETCH sel_jsp_name_csr INTO l_jsp_name;
3622: CLOSE sel_jsp_name_csr;
3623:
3624: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
3625: || '?srID=' || l_request_number;
3626: WF_ENGINE.SetItemAttrText(
3627: itemtype => itemtype,
3628: itemkey => itemkey,

Line 3862: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name

3858: OPEN sel_jsp_name_csr;
3859: FETCH sel_jsp_name_csr INTO l_jsp_name;
3860: CLOSE sel_jsp_name_csr;
3861:
3862: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
3863: || '?srID=' || l_request_number;
3864: WF_ENGINE.SetItemAttrText(
3865: itemtype => itemtype,
3866: itemkey => itemkey,

Line 4034: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name

4030: OPEN sel_jsp_name_csr;
4031: FETCH sel_jsp_name_csr INTO l_jsp_name;
4032: CLOSE sel_jsp_name_csr;
4033:
4034: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
4035: || '?srID=' || l_request_number;
4036: WF_ENGINE.SetItemAttrText(
4037: itemtype => itemtype,
4038: itemkey => itemkey,

Line 6534: l_resource_id := NVL(FND_PROFILE.VALUE('CS_SR_DEFAULT_SYSTEM_RESOURCE'), -1);

6530: aname => 'SENDER_ROLE' );
6531:
6532: IF (l_role_name IS NULL) THEN
6533:
6534: l_resource_id := NVL(FND_PROFILE.VALUE('CS_SR_DEFAULT_SYSTEM_RESOURCE'), -1);
6535: OPEN l_get_source_id(l_resource_id);
6536: FETCH l_get_source_id INTO l_get_source_id_rec;
6537:
6538: l_role_name := 'CS_WF_ROLE_DUMMY';

Line 6792: l_int_wrapup_id := FND_PROFILE.Value('CSC_CC_WRAPUP_INTERACTION_DEFAULTS');

6788: BEGIN
6789:
6790: x_return_status := FND_API.G_RET_STS_SUCCESS;
6791:
6792: l_int_wrapup_id := FND_PROFILE.Value('CSC_CC_WRAPUP_INTERACTION_DEFAULTS');
6793:
6794: l_action_item := 'Sr';
6795: l_action := 'Automated Email Sent';
6796:

Line 6800: l_int_profile := FND_PROFILE.Value('CS_SR_INTERACTION_LOGGING');

6796:
6797: l_interaction_rec := JTF_IH_PUB.INIT_INTERACTION_REC;
6798: l_activity_rec := JTF_IH_PUB.INIT_ACTIVITY_REC;
6799:
6800: l_int_profile := FND_PROFILE.Value('CS_SR_INTERACTION_LOGGING');
6801: NL := fnd_global.Local_Chr(10);
6802:
6803: IF ( l_int_profile is null or l_int_profile ='AUTO_INT_LOG' ) THEN
6804:

Line 6807: fnd_profile.get('USER_ID', d_user_id);

6803: IF ( l_int_profile is null or l_int_profile ='AUTO_INT_LOG' ) THEN
6804:
6805:
6806: IF (p_user_id is null) THEN
6807: fnd_profile.get('USER_ID', d_user_id);
6808: ELSE
6809: d_user_id := p_user_id;
6810: END IF;
6811:

Line 6813: fnd_profile.get('LOGIN_ID', d_login_id);

6809: d_user_id := p_user_id;
6810: END IF;
6811:
6812: IF (p_login_id is null) THEN
6813: fnd_profile.get('LOGIN_ID', d_login_id);
6814: ELSE
6815: d_login_id := p_login_id;
6816: END IF;
6817:

Line 6819: fnd_profile.get('RESP_ID', d_resp_id);

6815: d_login_id := p_login_id;
6816: END IF;
6817:
6818: IF (p_resp_id is null) THEN
6819: fnd_profile.get('RESP_ID', d_resp_id);
6820: ELSE
6821: d_resp_id := p_resp_id;
6822: END IF;
6823:

Line 6825: fnd_profile.get('RESP_APPL_ID', d_resp_appl_id);

6821: d_resp_id := p_resp_id;
6822: END IF;
6823:
6824: IF (p_resp_appl_id is null) THEN
6825: fnd_profile.get('RESP_APPL_ID', d_resp_appl_id);
6826: ELSE
6827: d_resp_appl_id := p_resp_appl_id;
6828: END IF;
6829:

Line 6883: l_interaction_rec.resource_id := FND_PROFILE.VALUE('CS_SR_DEFAULT_SYSTEM_RESOURCE');

6879: ****/
6880:
6881: -- Get the resource from the profile instead. Part of fix for bug 3360069.
6882: -- rmanabat 01/19/04.
6883: l_interaction_rec.resource_id := FND_PROFILE.VALUE('CS_SR_DEFAULT_SYSTEM_RESOURCE');
6884: IF (l_interaction_rec.resource_id is NULL) THEN
6885: raise l_NO_RESOURCE_FOUND;
6886: END IF;
6887:

Line 6920: l_act_wrapup_id := FND_PROFILE.Value('CSC_CC_WRAPUP_ACTIVITY_DEFAULTS');

6916:
6917: ELSE
6918:
6919:
6920: l_act_wrapup_id := FND_PROFILE.Value('CSC_CC_WRAPUP_ACTIVITY_DEFAULTS');
6921:
6922: IF (l_act_wrapup_id is not null) THEN
6923: -- Get the Activity defaults
6924: p_wrap_id := l_act_wrapup_id;

Line 7659: FND_PROFILE.GET('APPS_FRAMEWORK_AGENT',l_host);

7655: || p_contact_type || l_amp||'IBULanguage=' || p_user_language ;
7656:
7657: -- Get the host
7658:
7659: FND_PROFILE.GET('APPS_FRAMEWORK_AGENT',l_host);
7660:
7661: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
7662: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_WF_AUTO_NTFY_UPDATE_PKG.SET_HTML_NOTIFICATION_DETAILS')) THEN
7663:

Line 7679: UTL_HTTP.SET_WALLET('file:' || FND_PROFILE.Value('FND_DB_WALLET_DIR'));

7675: END IF;
7676:
7677: -- bug 5661159
7678: IF lower(substr(nvl(l_host, ''), 1, 5)) = 'https' THEN
7679: UTL_HTTP.SET_WALLET('file:' || FND_PROFILE.Value('FND_DB_WALLET_DIR'));
7680: END IF;
7681: -- bug 5661159_eof
7682:
7683: l_request := UTL_HTTP.BEGIN_REQUEST(l_host||l_ibu_url);