DBA Data[Home] [Help]

APPS.OE_CUST_MERGE dependencies on HZ_ACCT_MERGE_UTIL

Line 221: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

217: END IF;
218:
219: END LOOP;
220:
221: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
222: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
223:
224:
225: OPEN merge_headers_2;

Line 1420: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

1416: close c7;
1417:
1418: ELSE
1419:
1420: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1421: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1422:
1423: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1424: insert into HZ_CUSTOMER_MERGE_LOG (

Line 2181: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

2177: END IF;
2178:
2179: END LOOP;
2180:
2181: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2182: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2183:
2184: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines():1' );
2185:

Line 3048: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

3044: close c7;
3045:
3046: ELSE
3047:
3048: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3049: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3050:
3051: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3052: insert into HZ_CUSTOMER_MERGE_LOG (

Line 3679: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

3675:
3676:
3677: ELSE
3678:
3679: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3680: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3681:
3682: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3683: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 4037: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

4033:
4034:
4035: ELSE
4036:
4037: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4038: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4039: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4040: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4041: MERGE_LOG_ID,

Line 4685: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

4681:
4682:
4683: ELSE
4684:
4685: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4686: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4687:
4688: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4689: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 5042: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

5038: close c3;
5039:
5040: ELSE
5041:
5042: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5043: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5044:
5045: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5046: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 5293: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

5289: close c1;
5290:
5291: ELSE
5292:
5293: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5294: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5295:
5296: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5297: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 5417: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

5413:
5414:
5415: ELSE
5416:
5417: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5418: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5419:
5420: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5421: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 5609: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

5605: close sets_merge;
5606:
5607: ELSE
5608:
5609: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5610: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5611:
5612: OPEN sets_merge_2;
5613: LOOP

Line 5776: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

5772: close c1;
5773:
5774: ELSE
5775:
5776: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5777: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5778:
5779: OPEN c1_2;
5780: LOOP

Line 6030: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

6026: END IF;
6027:
6028: END LOOP;
6029:
6030: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6031: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6032:
6033:
6034: OPEN merge_headers_2;

Line 6307: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

6303: close c5;
6304:
6305: ELSE
6306:
6307: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6308: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6309:
6310: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
6311: insert into HZ_CUSTOMER_MERGE_LOG (

Line 6832: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

6828: END IF;
6829:
6830: END LOOP;
6831:
6832: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6833: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6834:
6835: OPEN merge_lines_2;
6836: LOOP

Line 7167: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

7163: END IF;
7164:
7165: END LOOP;
7166:
7167: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
7168: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
7169:
7170: OPEN merge_lines_history_2;
7171: LOOP

Line 7376: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

7372:
7373:
7374: ELSE
7375:
7376: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
7377: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
7378:
7379:
7380: -- customer level update