APPS.AS_SALES_METH_WF dependencies on FND_PROFILE

Line 94: FROM fnd_profile_options a, fnd_profile_option_values b

90: l_count NUMBER;
91: l_meth_flag VARCHAR2(10);
92: CURSOR c_profile IS
93: SELECT b.profile_option_value
94: FROM fnd_profile_options a, fnd_profile_option_values b
95: WHERE a.profile_option_id = b.profile_option_id
96: AND a.profile_option_name = 'AS_SM_CREATE_TASKS'
97: AND b.application_id =279;
98: CURSOR c_resource IS

Line 532: IF l_return_status = 'Y' AND nvl(fnd_profile.value('AS_SM_RECREATE_TASKS'), 'N') <> 'Y' THEN

528: wf_engine.setitemattrtext( itemtype => itemtype,
529: itemkey => itemkey,
530: aname => 'METH_NOTE_TYPE',
531: avalue => l_meth_note_type);
532: IF l_return_status = 'Y' AND nvl(fnd_profile.value('AS_SM_RECREATE_TASKS'), 'N') <> 'Y' THEN
533: result:='COMPLETE:Y';
534: ELSE
535: result:='COMPLETE:N';
536: print_message('result after next stage = ' ||result);

Line 1049: l_org_id :=fnd_profile.value('ORG_ID');

1045: l_column VARCHAR2(10):=',';
1046: l_org_id NUMBER;
1047: BEGIN
1048: --l_return_status := 'U';
1049: l_org_id :=fnd_profile.value('ORG_ID');
1050: IF funcmode = 'RUN' THEN
1051: l_source_object_code := wf_engine.getitemattrtext( itemtype => itemtype,
1052: itemkey => itemkey,
1053: aname => 'SOURCE_OBJECT_TYPE_CODE');

Line 1137: l_org_id:= fnd_profile.value('ORG_ID');

1133: l_task_name VARCHAR2(2000);
1134: l_org_id NUMBER;
1135: BEGIN
1136: l_return_status := 'S';
1137: l_org_id:= fnd_profile.value('ORG_ID');
1138: IF funcmode = 'RUN' THEN
1139: l_source_object_code := wf_engine.getitemattrtext( itemtype => itemtype,
1140: itemkey => itemkey,
1141: aname => 'SOURCE_OBJECT_TYPE_CODE');

Line 1241: l_org_id :=fnd_profile.value('ORG_ID');

1237: l_column VARCHAR2(10):=',';
1238: l_org_id NUMBER;
1239: BEGIN
1240: l_return_status := 'U';
1241: l_org_id :=fnd_profile.value('ORG_ID');
1242: IF funcmode = 'RUN' THEN
1243: l_source_object_code := wf_engine.getitemattrtext( itemtype => itemtype,
1244: itemkey => itemkey,
1245: aname => 'SOURCE_OBJECT_TYPE_CODE');