DBA Data[Home] [Help]

APPS.IGI_CIS_IGIPMTHP_PKG dependencies on FND_PROFILE

Line 192: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');

188: l_start_date ap_other_periods.start_date%TYPE;
189: BEGIN
190: l_procedure_name := g_path_name || l_procedure_name;
191: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
192: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
193:
194: SELECT start_date
195: INTO l_start_date
196: FROM ap_other_periods

Line 216: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');

212: l_end_date ap_other_periods.start_date%TYPE;
213: BEGIN
214: l_procedure_name := g_path_name || l_procedure_name;
215: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
216: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
217:
218: SELECT end_date
219: INTO l_end_date
220: FROM ap_other_periods

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

257: l_org_name hr_operating_units.name%TYPE := NULL ;
258: BEGIN
259: l_procedure_name := g_path_name || l_procedure_name;
260: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
261: -- l_org_id := fnd_profile.value('ORG_ID');
262:
263: l_org_id:= mo_global.get_current_org_id;
264: if(l_org_id is null) then
265: l_org_id := fnd_profile.value('ORG_ID');

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

261: -- l_org_id := fnd_profile.value('ORG_ID');
262:
263: l_org_id:= mo_global.get_current_org_id;
264: if(l_org_id is null) then
265: l_org_id := fnd_profile.value('ORG_ID');
266: end if;
267:
268: SELECT name
269: INTO l_org_name

Line 334: l_net_group := fnd_profile.VALUE('IGI_CIS2007_NET_WTH_GROUP');

330: l_tax_status VARCHAR2(10) := NULL;
331: BEGIN
332: l_procedure_name := g_path_name || l_procedure_name;
333: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
334: l_net_group := fnd_profile.VALUE('IGI_CIS2007_NET_WTH_GROUP');
335: l_unmatch_group := fnd_profile.VALUE('IGI_CIS2007_UNMATCHED_WTH_GROUP');
336: l_gross_group := fnd_profile.VALUE('IGI_CIS2007_GROSS_WTH_GROUP');
337:
338: SELECT meaning

Line 335: l_unmatch_group := fnd_profile.VALUE('IGI_CIS2007_UNMATCHED_WTH_GROUP');

331: BEGIN
332: l_procedure_name := g_path_name || l_procedure_name;
333: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
334: l_net_group := fnd_profile.VALUE('IGI_CIS2007_NET_WTH_GROUP');
335: l_unmatch_group := fnd_profile.VALUE('IGI_CIS2007_UNMATCHED_WTH_GROUP');
336: l_gross_group := fnd_profile.VALUE('IGI_CIS2007_GROSS_WTH_GROUP');
337:
338: SELECT meaning
339: INTO l_tax_status

Line 336: l_gross_group := fnd_profile.VALUE('IGI_CIS2007_GROSS_WTH_GROUP');

332: l_procedure_name := g_path_name || l_procedure_name;
333: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
334: l_net_group := fnd_profile.VALUE('IGI_CIS2007_NET_WTH_GROUP');
335: l_unmatch_group := fnd_profile.VALUE('IGI_CIS2007_UNMATCHED_WTH_GROUP');
336: l_gross_group := fnd_profile.VALUE('IGI_CIS2007_GROSS_WTH_GROUP');
337:
338: SELECT meaning
339: INTO l_tax_status
340: FROM igi_lookups