DBA Data[Home] [Help]

APPS.OE_CUST_MERGE dependencies on HZ_ACCT_MERGE_UTIL

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

327: END IF;
328: END LOOP;
329:
330:
331: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
332: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
333:
334: -- GTT insertion , bug 8883694 ,9349882 ,9558975
335: IF l_run_parallel_query = 'N' THEN

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

1714: close c7;
1715:
1716: ELSE
1717:
1718: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1719: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1720:
1721: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1722: insert into HZ_CUSTOMER_MERGE_LOG (

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

2560:
2561: END LOOP;
2562:
2563:
2564: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2565: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2566:
2567: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines():1' );
2568: -- Bug 7379750

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

3583: close c7;
3584:
3585: ELSE
3586:
3587: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3588: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3589:
3590: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3591: insert into HZ_CUSTOMER_MERGE_LOG (

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

4218:
4219:
4220: ELSE
4221:
4222: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4223: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4224:
4225: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4226: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

4576:
4577:
4578: ELSE
4579:
4580: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4581: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4582: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4583: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4584: MERGE_LOG_ID,

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

5224:
5225:
5226: ELSE
5227:
5228: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5229: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5230:
5231: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5232: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

5581: close c3;
5582:
5583: ELSE
5584:
5585: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5586: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5587:
5588: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5589: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

5837: close c1;
5838:
5839: ELSE
5840:
5841: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5842: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5843:
5844: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5845: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

5961:
5962:
5963: ELSE
5964:
5965: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5966: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5967:
5968: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5969: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

6165: close sets_merge;
6166:
6167: ELSE
6168:
6169: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6170: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6171: ---bug 13786914
6172: IF l_run_parallel_query = 'Y' THEN
6173: OPEN sets_merge_2;

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

6353: close c1;
6354:
6355: ELSE
6356:
6357: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6358: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6359:
6360: OPEN c1_2;
6361: LOOP

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

6664: END IF;
6665:
6666: END LOOP;
6667:
6668: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6669: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6670:
6671: -- Bug 7379750
6672: IF l_run_parallel_query = 'Y' THEN

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

6972: close c5;
6973:
6974: ELSE
6975:
6976: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6977: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6978:
6979: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
6980: insert into HZ_CUSTOMER_MERGE_LOG (

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

7561:
7562: END LOOP;
7563:
7564:
7565: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
7566: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
7567:
7568: -- Bug 7379750
7569: IF l_run_parallel_query = 'Y' THEN

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

7989:
7990: END LOOP;
7991:
7992:
7993: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
7994: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
7995:
7996: -- Bug 7379750
7997: IF l_run_parallel_query = 'Y' THEN

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

8233:
8234:
8235: ELSE
8236:
8237: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
8238: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
8239:
8240:
8241: -- customer level update