APPS.AMS_CAMPAIGN_PVT dependencies on FND_PROFILE

Line 87: WHERE business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

83: where campaign_id = p_parent_campaign_id
84: and exists (
85: SELECT 1
86: FROM hr_all_organization_units_vl
87: WHERE business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
88: AND NVL(date_from, SYSDATE) <= SYSDATE
89: AND NVL(date_to, SYSDATE) >= SYSDATE
90: AND type = 'BU'
91: AND organization_id = business_unit_id);

Line 174: l_camp_rec.campaign_calendar := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');

170: IF l_camp_rec.campaign_calendar IS NULL
171: AND (l_camp_rec.start_period_name IS NOT NULL
172: OR l_camp_rec.end_period_name IS NOT NULL)
173: THEN
174: l_camp_rec.campaign_calendar := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
175: END IF;
176:
177: -- default source_code
178: IF l_camp_rec.source_code IS NULL AND

Line 243: l_org_id := fnd_profile.value('DEFAULT_ORG_ID');

239: END LOOP;
240: END IF ;
241:
242: -- Added by rmajumda (09/15/05). MOAC changes
243: l_org_id := fnd_profile.value('DEFAULT_ORG_ID');
244:
245: -- Logic for Business Unit (8-Aug-2005 mayjain)
246: if (l_camp_rec.parent_campaign_id is not null)
247: then

Line 248: --OPEN c_parent_business_unit (l_camp_rec.parent_campaign_id, fnd_profile.value('ORG_ID'));

244:
245: -- Logic for Business Unit (8-Aug-2005 mayjain)
246: if (l_camp_rec.parent_campaign_id is not null)
247: then
248: --OPEN c_parent_business_unit (l_camp_rec.parent_campaign_id, fnd_profile.value('ORG_ID'));
249: -- MOAC changes
250: OPEN c_parent_business_unit (l_camp_rec.parent_campaign_id);
251: FETCH c_parent_business_unit into l_camp_rec.business_unit_id;
252: CLOSE c_parent_business_unit;

Line 256: AMS_Utility_PVT.debug_message(l_full_name ||': Org Id = ' || to_char(fnd_profile.value('ORG_ID')));

252: CLOSE c_parent_business_unit;
253:
254: AMS_Utility_PVT.debug_message(l_full_name ||': Business Unit = ' || to_char(l_camp_rec.business_unit_id));
255: AMS_Utility_PVT.debug_message(l_full_name ||': Parent Campaign Id = ' || to_char(l_camp_rec.parent_campaign_id));
256: AMS_Utility_PVT.debug_message(l_full_name ||': Org Id = ' || to_char(fnd_profile.value('ORG_ID')));
257:
258: OPEN c_parent_confi_flag (l_camp_rec.parent_campaign_id);
259: FETCH c_parent_confi_flag into l_camp_rec.private_flag;
260: CLOSE c_parent_confi_flag;

Line 478: NVL(l_camp_rec.city_id, TO_NUMBER(FND_PROFILE.value('AMS_SRCGEN_USER_CITY'))),

474: null, -- version_no
475: l_camp_rec.campaign_calendar,
476: l_camp_rec.start_period_name,
477: l_camp_rec.end_period_name,
478: NVL(l_camp_rec.city_id, TO_NUMBER(FND_PROFILE.value('AMS_SRCGEN_USER_CITY'))),
479: NVL(l_camp_rec.global_flag, 'N'),
480: l_camp_rec.custom_setup_id,
481: NVL(l_camp_rec.show_campaign_flag, 'Y'),
482: l_camp_rec.business_unit_id,

Line 1108: l_camp_rec.campaign_calendar := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');

1104: AND l_camp_rec.end_period_name IS NULL
1105: THEN
1106: l_camp_rec.campaign_calendar := NULL;
1107: ELSE
1108: l_camp_rec.campaign_calendar := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
1109: END IF;
1110:
1111: -- item level
1112: IF (AMS_DEBUG_HIGH_ON) THEN