APPS.AST_UWQ_SEL_PKG dependencies on FND_PROFILE

Line 513: lx_campaignCode := FND_PROFILE.VALUE('AST_DEFAULT_SOURCE_CODE');

509: FETCH c_campaignid INTO lx_sourcecodeID, lx_CampaignCode;
510: IF (c_CampaignId%FOUND) then
511:
512: LogMessage('MoreCampaign Code Match. Will be using default is set ');
513: lx_campaignCode := FND_PROFILE.VALUE('AST_DEFAULT_SOURCE_CODE');
514:
515: if lx_CampaignCode is not NULL then
516: OPEN c_campaigncode(lx_CampaignCode);
517: FETCH c_campaigncode INTO l_sourcecodeID;

Line 1340: logmessage('Responsibility Application id ' || fnd_profile.value('RESP_APPL_ID')) ;

1336: select source_code_id from ams_source_codes where
1337: source_code = p_source_code;
1338: BEGIN
1339:
1340: logmessage('Responsibility Application id ' || fnd_profile.value('RESP_APPL_ID')) ;
1341:
1342: l_task_id := '';
1343: l_source_code := '';
1344: l_source_code_id := '';

Line 1369: if(fnd_profile.value('RESP_APPL_ID') = '695') then

1365: p_action_param := 'PARTY_ID=' || l_nm_PARTY_ID ||' SOURCE_CAMPAIGN_ID=' || l_source_code_id;
1366: p_action_type := 2;
1367:
1368: elsif (l_source_object_type = 'Party') then
1369: if(fnd_profile.value('RESP_APPL_ID') = '695') then
1370: p_action_name := 'IEXRCALL' ;
1371: else
1372: p_action_name := 'AST_RC_ALL';
1373: end if ;

Line 1390: l_Profile := NVL(FND_PROFILE.VALUE('AST_MATCH_CAMP_DNIS'), 'N');

1386: END handleFooTask ;
1387:
1388:
1389: BEGIN
1390: l_Profile := NVL(FND_PROFILE.VALUE('AST_MATCH_CAMP_DNIS'), 'N');
1391: l_DumpData := NVL(FND_PROFILE.VALUE('AST_DUMP_PARAMS'), 'N');
1392: l_NoAreaCodeMatch := NVL(fnd_profile.value('AST_ANI_WITHOUT_AREACODE'), 'N');
1393:
1394: END AST_UWQ_SEL_PKG;

Line 1391: l_DumpData := NVL(FND_PROFILE.VALUE('AST_DUMP_PARAMS'), 'N');

1387:
1388:
1389: BEGIN
1390: l_Profile := NVL(FND_PROFILE.VALUE('AST_MATCH_CAMP_DNIS'), 'N');
1391: l_DumpData := NVL(FND_PROFILE.VALUE('AST_DUMP_PARAMS'), 'N');
1392: l_NoAreaCodeMatch := NVL(fnd_profile.value('AST_ANI_WITHOUT_AREACODE'), 'N');
1393:
1394: END AST_UWQ_SEL_PKG;

Line 1392: l_NoAreaCodeMatch := NVL(fnd_profile.value('AST_ANI_WITHOUT_AREACODE'), 'N');

1388:
1389: BEGIN
1390: l_Profile := NVL(FND_PROFILE.VALUE('AST_MATCH_CAMP_DNIS'), 'N');
1391: l_DumpData := NVL(FND_PROFILE.VALUE('AST_DUMP_PARAMS'), 'N');
1392: l_NoAreaCodeMatch := NVL(fnd_profile.value('AST_ANI_WITHOUT_AREACODE'), 'N');
1393:
1394: END AST_UWQ_SEL_PKG;