APPS.IGI_CIS_IGIPMTHP_PKG dependencies on FND_PROFILE

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

122: FUNCTION get_period_start_date RETURN VARCHAR2 IS
123: l_period_type ap_other_periods.period_type%TYPE;
124: l_start_date ap_other_periods.start_date%TYPE;
125: BEGIN
126: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
127:
128: SELECT start_date
129: INTO l_start_date
130: FROM ap_other_periods

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

141: FUNCTION get_period_end_date RETURN VARCHAR2 IS
142: l_period_type ap_other_periods.period_type%TYPE;
143: l_end_date ap_other_periods.start_date%TYPE;
144: BEGIN
145: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
146:
147: SELECT end_date
148: INTO l_end_date
149: FROM ap_other_periods

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

176: FUNCTION get_org_name RETURN VARCHAR2 IS
177: l_org_id hr_operating_units.organization_id%TYPE := NULL ;
178: l_org_name hr_operating_units.name%TYPE := NULL ;
179: BEGIN
180: l_org_id := fnd_profile.value('ORG_ID');
181:
182: SELECT name
183: INTO l_org_name
184: FROM hr_operating_units

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

229: l_unmatch_group VARCHAR2(10) := NULL;
230: l_gross_group VARCHAR2(10) := NULL;
231: l_tax_status VARCHAR2(10) := NULL;
232: BEGIN
233: l_net_group := fnd_profile.VALUE('IGI_CIS2007_NET_WTH_GROUP');
234: l_unmatch_group := fnd_profile.VALUE('IGI_CIS2007_UNMATCHED_WTH_GROUP');
235: l_gross_group := fnd_profile.VALUE('IGI_CIS2007_GROSS_WTH_GROUP');
236:
237: SELECT meaning

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

230: l_gross_group VARCHAR2(10) := NULL;
231: l_tax_status VARCHAR2(10) := NULL;
232: BEGIN
233: l_net_group := fnd_profile.VALUE('IGI_CIS2007_NET_WTH_GROUP');
234: l_unmatch_group := fnd_profile.VALUE('IGI_CIS2007_UNMATCHED_WTH_GROUP');
235: l_gross_group := fnd_profile.VALUE('IGI_CIS2007_GROSS_WTH_GROUP');
236:
237: SELECT meaning
238: INTO l_tax_status

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

231: l_tax_status VARCHAR2(10) := NULL;
232: BEGIN
233: l_net_group := fnd_profile.VALUE('IGI_CIS2007_NET_WTH_GROUP');
234: l_unmatch_group := fnd_profile.VALUE('IGI_CIS2007_UNMATCHED_WTH_GROUP');
235: l_gross_group := fnd_profile.VALUE('IGI_CIS2007_GROSS_WTH_GROUP');
236:
237: SELECT meaning
238: INTO l_tax_status
239: FROM igi_lookups