APPS.IBE_MERGE_PVT dependencies on FND_PROFILE

Line 143: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

139: ELSE
140: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
141: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);
142: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
143: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
144: --cursor to get party and account ID
145: open merged_records;
146: LOOP
147: FETCH merged_records BULK COLLECT INTO

Line 264: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

260: ELSE
261: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
262: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_SHP_LISTS',FALSE);
263: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
264: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
265: --cursor to get party and account ID
266: open merged_records;
267: LOOP
268: FETCH merged_records BULK COLLECT INTO

Line 425: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

421: ELSE
422: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
423: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_ACTIVE_QUOTES',FALSE);
424: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
425: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
426:
427: open C_ACTIVE_QUOTE_FROM;
428: loop
429: --get active quote for account

Line 577: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

573: ELSE
574: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
575: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBE_SH_QUOTE_ACCESS',FALSE);
576: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
577: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
578:
579: --retrieve shared carts
580: Open C_SHARED_QUOTE_FROM;
581: Loop

Line 742: select profile_option_value from fnd_profile_option_values where profile_option_id in

738: AND RACM.REQUEST_ID = req_id
739: AND RACM.SET_NUMBER = set_number;
740:
741: CURSOR c_prof IS
742: select profile_option_value from fnd_profile_option_values where profile_option_id in
743: (select profile_option_id from fnd_profile_options where profile_option_name ='AFLOG_ENABLED')
744: and ((level_id=10002 and level_value=671) or level_id=10001)
745: and profile_option_value='Y';
746:

Line 743: (select profile_option_id from fnd_profile_options where profile_option_name ='AFLOG_ENABLED')

739: AND RACM.SET_NUMBER = set_number;
740:
741: CURSOR c_prof IS
742: select profile_option_value from fnd_profile_option_values where profile_option_id in
743: (select profile_option_id from fnd_profile_options where profile_option_name ='AFLOG_ENABLED')
744: and ((level_id=10002 and level_value=671) or level_id=10001)
745: and profile_option_value='Y';
746:
747: l_debug VARCHAR2(1):='N';