APPS.IGI_STP_TABLE_HANDLER_PKG dependencies on FND_PROFILE

Line 94: l_profile_value varchar2(100); -- For capturing the value returned from fnd_profile.get

90:
91: l_application_id number;
92: l_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
93: l_cust_acct_site_id number;
94: l_profile_value varchar2(100); -- For capturing the value returned from fnd_profile.get
95:
96: v_cnt number;
97:
98: BEGIN

Line 182: FND_PROFILE.GET('HZ_GENERATE_PARTY_SITE_NUMBER', l_profile_value);

178: l_party_site_rec.party_site_id := X_party_site_id;
179: l_party_site_rec.party_id := X_party_id;
180: l_party_site_rec.location_id := X_location_id;
181:
182: FND_PROFILE.GET('HZ_GENERATE_PARTY_SITE_NUMBER', l_profile_value);
183:
184: IF (l_profile_value = 'N') THEN
185: l_party_site_rec.party_site_number := X_party_site_number;
186: ELSE

Line 1204: l_profile_value varchar2(100); -- For capturing the value returned by fnd_profile.get

1200: SELECT generate_customer_number
1201: FROM ar_system_parameters;
1202:
1203: l_gen_cust_num varchar2(1);
1204: l_profile_value varchar2(100); -- For capturing the value returned by fnd_profile.get
1205: BEGIN
1206: --fnd_log.string(1,'IGI_STP','In Customer Insert');
1207:
1208: l_party_rec.party_id := X_party_id;

Line 1211: FND_PROFILE.GET('HZ_GENERATE_PARTY_NUMBER', l_profile_value);

1207:
1208: l_party_rec.party_id := X_party_id;
1209:
1210:
1211: FND_PROFILE.GET('HZ_GENERATE_PARTY_NUMBER', l_profile_value);
1212:
1213: IF (l_profile_value = 'N') THEN
1214: l_party_rec.party_number := X_party_number;
1215: ELSE