APPS.CS_KB_WF_PKG dependencies on FND_PROFILE

Line 565: FROM fnd_profile_options o,

561: WHERE flow_id = flowId;
562:
563: CURSOR CHECK_DEFAULT_FLOWS (flowId NUMBER) IS
564: SELECT count(*)
565: FROM fnd_profile_options o,
566: fnd_profile_option_values ov
567: WHERE o.profile_option_name = 'CS_KB_DEFAULT_FLOW'
568: AND o.profile_option_id = ov.profile_option_id
569: AND ov.PROFILE_OPTION_VALUE = to_char(flowId)

Line 566: fnd_profile_option_values ov

562:
563: CURSOR CHECK_DEFAULT_FLOWS (flowId NUMBER) IS
564: SELECT count(*)
565: FROM fnd_profile_options o,
566: fnd_profile_option_values ov
567: WHERE o.profile_option_name = 'CS_KB_DEFAULT_FLOW'
568: AND o.profile_option_id = ov.profile_option_id
569: AND ov.PROFILE_OPTION_VALUE = to_char(flowId)
570: AND ov.application_id = 170;

Line 675: l_resp_id := FND_PROFILE.VALUE_SPECIFIC(

671: code JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
672: name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
673: BEGIN
674:
675: l_resp_id := FND_PROFILE.VALUE_SPECIFIC(
676: 'JTF_PROFILE_DEFAULT_RESPONSIBILITY',
677: l_user_id,
678: null,
679: null);