eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CUST_MERGE dependencies on HZ_CUSTOMER_MERGE_LOG

Line 316: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

312: --insert audit information for customer merge
313: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
314: IF hdr_header_id_tab.COUNT <> 0 THEN
315: forall i in hdr_header_id_tab.FIRST..hdr_header_id_tab.LAST
316: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
317: MERGE_LOG_ID,
318: TABLE_NAME,
319: MERGE_HEADER_ID,
320: PRIMARY_KEY_ID1,

Line 343: HZ_CUSTOMER_MERGE_LOG_s.nextval,

339: LAST_UPDATE_LOGIN,
340: LAST_UPDATE_DATE,
341: LAST_UPDATED_BY
342: ) VALUES (
343: HZ_CUSTOMER_MERGE_LOG_s.nextval,
344: 'OE_ORDER_HEADERS_ALL',
345: MERGE_HEADER_ID_LIST(I),
346: hdr_header_id_tab(I),
347: old_hdr_sold_to_org_id_tab(I),

Line 1424: insert into HZ_CUSTOMER_MERGE_LOG (

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 (
1425: MERGE_LOG_ID,
1426: TABLE_NAME,
1427: MERGE_HEADER_ID,
1428: PRIMARY_KEY1,

Line 1440: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1436: LAST_UPDATE_DATE,
1437: LAST_UPDATED_BY
1438: )
1439: select
1440: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1441: 'OE_HEADER_ACKS',
1442: m.CUSTOMER_MERGE_HEADER_ID,
1443: h.ORIG_SYS_DOCUMENT_REF,
1444: h.ship_to_org_id,

Line 1491: insert into HZ_CUSTOMER_MERGE_LOG (

1487: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
1488: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1489:
1490: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1491: insert into HZ_CUSTOMER_MERGE_LOG (
1492: MERGE_LOG_ID,
1493: TABLE_NAME,
1494: MERGE_HEADER_ID,
1495: PRIMARY_KEY1,

Line 1507: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1503: LAST_UPDATE_DATE,
1504: LAST_UPDATED_BY
1505: )
1506: select
1507: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1508: 'OE_HEADERS_ACKS',
1509: m.CUSTOMER_MERGE_HEADER_ID,
1510: h.ORIG_SYS_DOCUMENT_REF,
1511: h.invoice_to_org_id,

Line 1560: insert into HZ_CUSTOMER_MERGE_LOG (

1556: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1557: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1558:
1559: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1560: insert into HZ_CUSTOMER_MERGE_LOG (
1561: MERGE_LOG_ID,
1562: TABLE_NAME,
1563: MERGE_HEADER_ID,
1564: PRIMARY_KEY1,

Line 1576: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1572: LAST_UPDATE_DATE,
1573: LAST_UPDATED_BY
1574: )
1575: select
1576: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1577: 'OE_HEADER_ACKS',
1578: m.CUSTOMER_MERGE_HEADER_ID,
1579: h.ORIG_SYS_DOCUMENT_REF,
1580: h.deliver_to_org_id,

Line 1631: insert into HZ_CUSTOMER_MERGE_LOG (

1627: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1628: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1629:
1630: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1631: insert into HZ_CUSTOMER_MERGE_LOG (
1632: MERGE_LOG_ID,
1633: TABLE_NAME,
1634: MERGE_HEADER_ID,
1635: PRIMARY_KEY1,

Line 1647: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1643: LAST_UPDATE_DATE,
1644: LAST_UPDATED_BY
1645: )
1646: select
1647: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1648: 'OE_HEADER_ACKS',
1649: m.CUSTOMER_MERGE_HEADER_ID,
1650: h.ORIG_SYS_DOCUMENT_REF,
1651: h.sold_to_org_id,

Line 1703: insert into HZ_CUSTOMER_MERGE_LOG (

1699: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1700: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1701:
1702: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1703: insert into HZ_CUSTOMER_MERGE_LOG (
1704: MERGE_LOG_ID,
1705: TABLE_NAME,
1706: MERGE_HEADER_ID,
1707: PRIMARY_KEY1,

Line 1719: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1715: LAST_UPDATE_DATE,
1716: LAST_UPDATED_BY
1717: )
1718: select
1719: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1720: 'OE_HEADER_ACKS',
1721: m.CUSTOMER_MERGE_HEADER_ID,
1722: h.ORIG_SYS_DOCUMENT_REF,
1723: h.sold_to_site_use_id,

Line 1776: insert into HZ_CUSTOMER_MERGE_LOG (

1772: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1773: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1774:
1775: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1776: insert into HZ_CUSTOMER_MERGE_LOG (
1777: MERGE_LOG_ID,
1778: TABLE_NAME,
1779: MERGE_HEADER_ID,
1780: PRIMARY_KEY1,

Line 1792: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1788: LAST_UPDATE_DATE,
1789: LAST_UPDATED_BY
1790: )
1791: select
1792: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1793: 'OE_HEADER_ACKS',
1794: m.CUSTOMER_MERGE_HEADER_ID,
1795: h.ORIG_SYS_DOCUMENT_REF,
1796: h.end_customer_site_use_id,

Line 1849: insert into HZ_CUSTOMER_MERGE_LOG (

1845: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1846: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1847:
1848: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1849: insert into HZ_CUSTOMER_MERGE_LOG (
1850: MERGE_LOG_ID,
1851: TABLE_NAME,
1852: MERGE_HEADER_ID,
1853: PRIMARY_KEY1,

Line 1865: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1861: LAST_UPDATE_DATE,
1862: LAST_UPDATED_BY
1863: )
1864: select
1865: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1866: 'OE_HEADER_ACKS',
1867: m.CUSTOMER_MERGE_HEADER_ID,
1868: h.ORIG_SYS_DOCUMENT_REF,
1869: h.end_customer_id,

Line 2283: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

2279: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2280: IF line_line_id_tab.COUNT <> 0 THEN
2281: forall i in line_line_id_tab.FIRST..line_line_id_tab.LAST
2282: --insert audit information for customer merge
2283: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2284: MERGE_LOG_ID,
2285: TABLE_NAME,
2286: MERGE_HEADER_ID,
2287: PRIMARY_KEY_ID1,

Line 2308: HZ_CUSTOMER_MERGE_LOG_s.nextval,

2304: LAST_UPDATE_LOGIN,
2305: LAST_UPDATE_DATE,
2306: LAST_UPDATED_BY
2307: ) VALUES (
2308: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2309: 'OE_ORDER_LINES_ALL',
2310: MERGE_HEADER_ID_LIST(I),
2311: line_line_id_tab(I),
2312: line_sold_to_org_id_tab(I),

Line 3052: insert into HZ_CUSTOMER_MERGE_LOG (

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 (
3053: MERGE_LOG_ID,
3054: TABLE_NAME,
3055: MERGE_HEADER_ID,
3056: PRIMARY_KEY1,

Line 3069: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3065: LAST_UPDATE_DATE,
3066: LAST_UPDATED_BY
3067: )
3068: select
3069: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3070: 'OE_LINE_ACKS',
3071: m.CUSTOMER_MERGE_HEADER_ID,
3072: a.ORIG_SYS_DOCUMENT_REF,
3073: a.ORIG_SYS_LINE_REF,

Line 3121: insert into HZ_CUSTOMER_MERGE_LOG (

3117: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
3118: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3119:
3120: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3121: insert into HZ_CUSTOMER_MERGE_LOG (
3122: MERGE_LOG_ID,
3123: TABLE_NAME,
3124: MERGE_HEADER_ID,
3125: PRIMARY_KEY1,

Line 3138: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3134: LAST_UPDATE_DATE,
3135: LAST_UPDATED_BY
3136: )
3137: select
3138: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3139: 'OE_LINE_ACKS',
3140: m.CUSTOMER_MERGE_HEADER_ID,
3141: a.ORIG_SYS_DOCUMENT_REF,
3142: a.ORIG_SYS_LINE_REF,

Line 3189: insert into HZ_CUSTOMER_MERGE_LOG (

3185: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
3186: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3187:
3188: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3189: insert into HZ_CUSTOMER_MERGE_LOG (
3190: MERGE_LOG_ID,
3191: TABLE_NAME,
3192: MERGE_HEADER_ID,
3193: PRIMARY_KEY1,

Line 3206: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3202: LAST_UPDATE_DATE,
3203: LAST_UPDATED_BY
3204: )
3205: select
3206: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3207: 'OE_LINE_ACKS',
3208: m.CUSTOMER_MERGE_HEADER_ID,
3209: a.ORIG_SYS_DOCUMENT_REF,
3210: a.ORIG_SYS_LINE_REF,

Line 3257: insert into HZ_CUSTOMER_MERGE_LOG (

3253: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
3254: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3255:
3256: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3257: insert into HZ_CUSTOMER_MERGE_LOG (
3258: MERGE_LOG_ID,
3259: TABLE_NAME,
3260: MERGE_HEADER_ID,
3261: PRIMARY_KEY1,

Line 3274: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3270: LAST_UPDATE_DATE,
3271: LAST_UPDATED_BY
3272: )
3273: select
3274: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3275: 'OE_LINE_ACKS',
3276: m.CUSTOMER_MERGE_HEADER_ID,
3277: a.ORIG_SYS_DOCUMENT_REF,
3278: a.ORIG_SYS_LINE_REF,

Line 3331: insert into HZ_CUSTOMER_MERGE_LOG (

3327: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3328:
3329:
3330: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3331: insert into HZ_CUSTOMER_MERGE_LOG (
3332: MERGE_LOG_ID,
3333: TABLE_NAME,
3334: MERGE_HEADER_ID,
3335: PRIMARY_KEY1,

Line 3348: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3344: LAST_UPDATE_DATE,
3345: LAST_UPDATED_BY
3346: )
3347: select
3348: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3349: 'OE_LINE_ACKS',
3350: m.CUSTOMER_MERGE_HEADER_ID,
3351: a.ORIG_SYS_DOCUMENT_REF,
3352: a.ORIG_SYS_LINE_REF,

Line 3408: insert into HZ_CUSTOMER_MERGE_LOG (

3404: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3405:
3406:
3407: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3408: insert into HZ_CUSTOMER_MERGE_LOG (
3409: MERGE_LOG_ID,
3410: TABLE_NAME,
3411: MERGE_HEADER_ID,
3412: PRIMARY_KEY1,

Line 3425: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3421: LAST_UPDATE_DATE,
3422: LAST_UPDATED_BY
3423: )
3424: select
3425: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3426: 'OE_LINE_ACKS',
3427: m.CUSTOMER_MERGE_HEADER_ID,
3428: a.ORIG_SYS_DOCUMENT_REF,
3429: a.ORIG_SYS_LINE_REF,

Line 3483: insert into HZ_CUSTOMER_MERGE_LOG (

3479: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3480:
3481:
3482: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3483: insert into HZ_CUSTOMER_MERGE_LOG (
3484: MERGE_LOG_ID,
3485: TABLE_NAME,
3486: MERGE_HEADER_ID,
3487: PRIMARY_KEY1,

Line 3500: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3496: LAST_UPDATE_DATE,
3497: LAST_UPDATED_BY
3498: )
3499: select
3500: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3501: 'OE_LINE_ACKS',
3502: m.CUSTOMER_MERGE_HEADER_ID,
3503: a.ORIG_SYS_DOCUMENT_REF,
3504: a.ORIG_SYS_LINE_REF,

Line 3683: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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 (
3684: MERGE_LOG_ID,
3685: TABLE_NAME,
3686: MERGE_HEADER_ID,
3687: PRIMARY_KEY_ID1,

Line 3699: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3695: LAST_UPDATE_DATE,
3696: LAST_UPDATED_BY
3697: )
3698: select
3699: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3700: 'OE_ATTACHMENT_RULE_ELEMENTS',
3701: m.customer_merge_header_id,
3702: a.rule_element_id,
3703: a.attribute_value,

Line 3751: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

3747: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3748:
3749:
3750: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3751: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
3752: MERGE_LOG_ID,
3753: TABLE_NAME,
3754: MERGE_HEADER_ID,
3755: PRIMARY_KEY_ID1,

Line 3767: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3763: LAST_UPDATE_DATE,
3764: LAST_UPDATED_BY
3765: )
3766: select
3767: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3768: 'OE_ATTACHMENT_RULE_ELEMENTS',
3769: m.customer_merge_header_id,
3770: a.rule_element_id,
3771: a.attribute_value,

Line 3820: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

3816:
3817:
3818:
3819: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3820: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
3821: MERGE_LOG_ID,
3822: TABLE_NAME,
3823: MERGE_HEADER_ID,
3824: PRIMARY_KEY_ID1,

Line 3836: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3832: LAST_UPDATE_DATE,
3833: LAST_UPDATED_BY
3834: )
3835: select
3836: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3837: 'OE_ATTACHMENT_RULE_ELEMENTS',
3838: m.customer_merge_header_id,
3839: a.rule_element_id,
3840: a.attribute_value,

Line 4040: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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,
4042: TABLE_NAME,
4043: MERGE_HEADER_ID,
4044: PRIMARY_KEY_ID1,

Line 4056: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4052: LAST_UPDATE_DATE,
4053: LAST_UPDATED_BY
4054: )
4055: select
4056: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4057: 'OE_DEF_CONDN_ELEMS',
4058: m.customer_merge_header_id,
4059: a.condition_element_id,
4060: a.value_string,

Line 4107: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

4103:
4104: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
4105: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4106: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4107: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4108: MERGE_LOG_ID,
4109: TABLE_NAME,
4110: MERGE_HEADER_ID,
4111: PRIMARY_KEY_ID1,

Line 4123: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4119: LAST_UPDATE_DATE,
4120: LAST_UPDATED_BY
4121: )
4122: select
4123: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4124: 'OE_DEF_CONDN_ELEMS',
4125: m.customer_merge_header_id,
4126: a.condition_element_id,
4127: a.value_string,

Line 4176: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

4172: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
4173: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4174:
4175: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4176: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4177: MERGE_LOG_ID,
4178: TABLE_NAME,
4179: MERGE_HEADER_ID,
4180: PRIMARY_KEY_ID1,

Line 4192: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4188: LAST_UPDATE_DATE,
4189: LAST_UPDATED_BY
4190: )
4191: select
4192: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4193: 'OE_DEF_CONDN_ELEMS',
4194: m.customer_merge_header_id,
4195: a.condition_element_id,
4196: a.value_string,

Line 4244: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

4240: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
4241: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4242:
4243: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4244: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4245: MERGE_LOG_ID,
4246: TABLE_NAME,
4247: MERGE_HEADER_ID,
4248: PRIMARY_KEY_ID1,

Line 4260: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4256: LAST_UPDATE_DATE,
4257: LAST_UPDATED_BY
4258: )
4259: select
4260: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4261: 'OE_DEF_CONDN_ELEMS',
4262: m.customer_merge_header_id,
4263: a.condition_element_id,
4264: a.value_string,

Line 4314: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

4310: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4311:
4312:
4313: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4314: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4315: MERGE_LOG_ID,
4316: TABLE_NAME,
4317: MERGE_HEADER_ID,
4318: PRIMARY_KEY_ID1,

Line 4330: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4326: LAST_UPDATE_DATE,
4327: LAST_UPDATED_BY
4328: )
4329: select
4330: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4331: 'OE_DEF_ATTR_DEF_RULES',
4332: m.customer_merge_header_id,
4333: a.attr_def_rule_id,
4334: a.src_constant_value,

Line 4384: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

4380: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
4381: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4382:
4383: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4384: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4385: MERGE_LOG_ID,
4386: TABLE_NAME,
4387: MERGE_HEADER_ID,
4388: PRIMARY_KEY_ID1,

Line 4400: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4396: LAST_UPDATE_DATE,
4397: LAST_UPDATED_BY
4398: )
4399: select
4400: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4401: 'OE_DEF_ATTR_DEF_RULES',
4402: m.customer_merge_header_id,
4403: a.attr_def_rule_id,
4404: a.src_constant_value,

Line 4452: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

4448: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
4449: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4450:
4451: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4452: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4453: MERGE_LOG_ID,
4454: TABLE_NAME,
4455: MERGE_HEADER_ID,
4456: PRIMARY_KEY_ID1,

Line 4468: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4464: LAST_UPDATE_DATE,
4465: LAST_UPDATED_BY
4466: )
4467: select
4468: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4469: 'OE_DEF_ATTR_DEF_RULES',
4470: m.customer_merge_header_id,
4471: a.attr_def_rule_id,
4472: a.src_constant_value,

Line 4521: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

4517: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4518:
4519:
4520: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4521: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4522: MERGE_LOG_ID,
4523: TABLE_NAME,
4524: MERGE_HEADER_ID,
4525: PRIMARY_KEY_ID1,

Line 4537: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4533: LAST_UPDATE_DATE,
4534: LAST_UPDATED_BY
4535: )
4536: select
4537: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4538: 'OE_DEF_ATTR_DEF_RULES',
4539: m.customer_merge_header_id,
4540: a.attr_def_rule_id,
4541: a.src_constant_value,

Line 4689: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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 (
4690: MERGE_LOG_ID,
4691: TABLE_NAME,
4692: MERGE_HEADER_ID,
4693: PRIMARY_KEY_ID1,

Line 4705: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4701: LAST_UPDATE_DATE,
4702: LAST_UPDATED_BY
4703: )
4704: select
4705: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4706: 'OE_PC_VTMPLT_COLS',
4707: m.customer_merge_header_id,
4708: a.validation_tmplt_id,
4709: a.value_string,

Line 4757: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

4753: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
4754: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4755:
4756: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4757: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4758: MERGE_LOG_ID,
4759: TABLE_NAME,
4760: MERGE_HEADER_ID,
4761: PRIMARY_KEY_ID1,

Line 4773: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4769: LAST_UPDATE_DATE,
4770: LAST_UPDATED_BY
4771: )
4772: select
4773: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4774: 'OE_PC_VTMPLT_COLS',
4775: m.customer_merge_header_id,
4776: a.validation_tmplt_id,
4777: a.value_string,

Line 4825: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

4821: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
4822: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4823:
4824: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4825: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4826: MERGE_LOG_ID,
4827: TABLE_NAME,
4828: MERGE_HEADER_ID,
4829: PRIMARY_KEY_ID1,

Line 4841: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4837: LAST_UPDATE_DATE,
4838: LAST_UPDATED_BY
4839: )
4840: select
4841: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4842: 'OE_PC_VTMPLT_COLS',
4843: m.customer_merge_header_id,
4844: a.validation_tmplt_id,
4845: a.value_string,

Line 4894: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

4890: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4891:
4892:
4893: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4894: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4895: MERGE_LOG_ID,
4896: TABLE_NAME,
4897: MERGE_HEADER_ID,
4898: PRIMARY_KEY_ID1,

Line 4910: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4906: LAST_UPDATE_DATE,
4907: LAST_UPDATED_BY
4908: )
4909: select
4910: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4911: 'OE_PC_VTMPLT_COLS',
4912: m.customer_merge_header_id,
4913: a.validation_tmplt_id,
4914: a.value_string,

Line 5046: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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 (
5047: MERGE_LOG_ID,
5048: TABLE_NAME,
5049: MERGE_HEADER_ID,
5050: PRIMARY_KEY_ID1,

Line 5062: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5058: LAST_UPDATE_DATE,
5059: LAST_UPDATED_BY
5060: )
5061: select
5062: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5063: 'OE_HOLD_SOURCES',
5064: m.customer_merge_header_id,
5065: a.hold_source_id,
5066: to_char(a.hold_entity_id),

Line 5114: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

5110: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
5111: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
5112:
5113: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5114: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
5115: MERGE_LOG_ID,
5116: TABLE_NAME,
5117: MERGE_HEADER_ID,
5118: PRIMARY_KEY_ID1,

Line 5130: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5126: LAST_UPDATE_DATE,
5127: LAST_UPDATED_BY
5128: )
5129: select
5130: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5131: 'OE_HOLD_SOURCES',
5132: m.customer_merge_header_id,
5133: a.hold_source_id,
5134: to_char(a.hold_entity_id),

Line 5183: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

5179: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
5180:
5181:
5182: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5183: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
5184: MERGE_LOG_ID,
5185: TABLE_NAME,
5186: MERGE_HEADER_ID,
5187: PRIMARY_KEY_ID1,

Line 5199: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5195: LAST_UPDATE_DATE,
5196: LAST_UPDATED_BY
5197: )
5198: select
5199: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5200: 'OE_HOLD_SOURCES',
5201: m.customer_merge_header_id,
5202: a.hold_source_id,
5203: to_char(a.hold_entity_id),

Line 5297: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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 (
5298: MERGE_LOG_ID,
5299: TABLE_NAME,
5300: MERGE_HEADER_ID,
5301: PRIMARY_KEY_ID1,

Line 5313: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5309: LAST_UPDATE_DATE,
5310: LAST_UPDATED_BY
5311: )
5312: select
5313: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5314: 'OE_DROP_SHIP_SOURCES',
5315: m.customer_merge_header_id,
5316: a.drop_ship_source_id,
5317: to_char(a.line_location_id),

Line 5421: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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 (
5422: MERGE_LOG_ID,
5423: TABLE_NAME,
5424: MERGE_HEADER_ID,
5425: PRIMARY_KEY_ID1,

Line 5437: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5433: LAST_UPDATE_DATE,
5434: LAST_UPDATED_BY
5435: )
5436: select
5437: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5438: 'OE_CUST_ITEM_SETTINGS',
5439: m.customer_merge_header_id,
5440: a.cust_item_setting_id,
5441: a.site_use_id,

Line 5483: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

5479: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
5480: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
5481:
5482: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5483: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
5484: MERGE_LOG_ID,
5485: TABLE_NAME,
5486: MERGE_HEADER_ID,
5487: PRIMARY_KEY_ID1,

Line 5499: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5495: LAST_UPDATE_DATE,
5496: LAST_UPDATED_BY
5497: )
5498: select
5499: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5500: 'OE_CUST_ITEM_SETTINGS',
5501: m.customer_merge_header_id,
5502: a.cust_item_setting_id,
5503: a.customer_id,

Line 5623: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

5619:
5620: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5621: IF sets_set_id_tab.COUNT <> 0 THEN
5622: forall i in sets_set_id_tab.FIRST..sets_set_id_tab.LAST
5623: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
5624: MERGE_LOG_ID,
5625: TABLE_NAME,
5626: MERGE_HEADER_ID,
5627: PRIMARY_KEY_ID1,

Line 5638: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5634: LAST_UPDATE_LOGIN,
5635: LAST_UPDATE_DATE,
5636: LAST_UPDATED_BY
5637: ) VALUES (
5638: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5639: 'OE_SETS',
5640: MERGE_HEADER_ID_LIST(I),
5641: sets_set_id_tab(I),
5642: sets_ship_to_org_id_tab(I),

Line 5791: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

5787:
5788: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5789: IF attrib_id_tab.COUNT <> 0 THEN
5790: FORALL I in attrib_id_tab.FIRST..attrib_id_tab.LAST
5791: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
5792: MERGE_LOG_ID,
5793: TABLE_NAME,
5794: MERGE_HEADER_ID,
5795: PRIMARY_KEY_ID1,

Line 5806: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5802: LAST_UPDATE_LOGIN,
5803: LAST_UPDATE_DATE,
5804: LAST_UPDATED_BY
5805: ) VALUES (
5806: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5807: 'OE_PRICE_ADJ_ATTRIBS',
5808: MERGE_HEADER_ID_LIST(I),
5809: attrib_id_tab(I),
5810: pricing_attr_value_from_tab(I),

Line 6085: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

6081: --insert audit information for customer merge
6082: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
6083: IF hdr_header_id_tab.COUNT <> 0 THEN
6084: forall i in hdr_header_id_tab.FIRST..hdr_header_id_tab.LAST
6085: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
6086: MERGE_LOG_ID,
6087: TABLE_NAME,
6088: MERGE_HEADER_ID,
6089: PRIMARY_KEY_ID1,

Line 6108: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6104: LAST_UPDATE_LOGIN,
6105: LAST_UPDATE_DATE,
6106: LAST_UPDATED_BY
6107: ) VALUES (
6108: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6109: 'OE_BLANKET_HEADERS_ALL',
6110: MERGE_HEADER_ID_LIST(I),
6111: hdr_header_id_tab(I),
6112: old_hdr_sold_to_org_id_tab(I),

Line 6311: insert into HZ_CUSTOMER_MERGE_LOG (

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 (
6312: MERGE_LOG_ID,
6313: TABLE_NAME,
6314: MERGE_HEADER_ID,
6315: PRIMARY_KEY_ID1,

Line 6328: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6324: LAST_UPDATE_DATE,
6325: LAST_UPDATED_BY
6326: )
6327: select
6328: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6329: 'OE_BLANKET_HEADERS_HIST',
6330: m.customer_merge_header_id,
6331: h.header_id,
6332: h.version_number,

Line 6378: insert into HZ_CUSTOMER_MERGE_LOG (

6374: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
6375: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
6376:
6377: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
6378: insert into HZ_CUSTOMER_MERGE_LOG (
6379: MERGE_LOG_ID,
6380: TABLE_NAME,
6381: MERGE_HEADER_ID,
6382: PRIMARY_KEY_ID1,

Line 6395: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6391: LAST_UPDATE_DATE,
6392: LAST_UPDATED_BY
6393: )
6394: select
6395: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6396: 'OE_BLANKET_HEADERS_HIST',
6397: m.CUSTOMER_MERGE_HEADER_ID,
6398: h.version_number,
6399: h.header_id,

Line 6445: insert into HZ_CUSTOMER_MERGE_LOG (

6441: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
6442:
6443:
6444: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
6445: insert into HZ_CUSTOMER_MERGE_LOG (
6446: MERGE_LOG_ID,
6447: TABLE_NAME,
6448: MERGE_HEADER_ID,
6449: PRIMARY_KEY_ID1,

Line 6462: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6458: LAST_UPDATE_DATE,
6459: LAST_UPDATED_BY
6460: )
6461: select
6462: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6463: 'OE_BLANKET_HEADERS_HIST',
6464: m.CUSTOMER_MERGE_HEADER_ID,
6465: h.header_id,
6466: h.version_number,

Line 6514: insert into HZ_CUSTOMER_MERGE_LOG (

6510: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6511:
6512:
6513: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
6514: insert into HZ_CUSTOMER_MERGE_LOG (
6515: MERGE_LOG_ID,
6516: TABLE_NAME,
6517: MERGE_HEADER_ID,
6518: PRIMARY_KEY_ID1,

Line 6531: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6527: LAST_UPDATE_DATE,
6528: LAST_UPDATED_BY
6529: )
6530: select
6531: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6532: 'OE_BLANKET_HEADERS_HIST',
6533: m.customer_merge_header_id,
6534: h.header_id,
6535: h.version_number,

Line 6587: insert into HZ_CUSTOMER_MERGE_LOG (

6583: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_HIST', FALSE );
6584:
6585:
6586: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
6587: insert into HZ_CUSTOMER_MERGE_LOG (
6588: MERGE_LOG_ID,
6589: TABLE_NAME,
6590: MERGE_HEADER_ID,
6591: PRIMARY_KEY_ID1,

Line 6604: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6600: LAST_UPDATE_DATE,
6601: LAST_UPDATED_BY
6602: )
6603: select
6604: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6605: 'OE_BLANKET_HEADERS_HIST',
6606: m.customer_merge_header_id,
6607: h.header_id,
6608: h.version_number,

Line 6886: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

6882: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
6883: IF line_line_id_tab.COUNT <> 0 THEN
6884: forall i in line_line_id_tab.FIRST..line_line_id_tab.LAST
6885: --insert audit information for customer merge
6886: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
6887: MERGE_LOG_ID,
6888: TABLE_NAME,
6889: MERGE_HEADER_ID,
6890: PRIMARY_KEY_ID1,

Line 6907: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6903: LAST_UPDATE_LOGIN,
6904: LAST_UPDATE_DATE,
6905: LAST_UPDATED_BY
6906: ) VALUES (
6907: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6908: 'OE_BLANKET_LINES_ALL',
6909: MERGE_HEADER_ID_LIST(I),
6910: line_line_id_tab(I),
6911: line_sold_to_org_id_tab(I),

Line 7222: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

7218: --insert audit information for customer merge
7219: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
7220: IF lhst_line_id_tab.COUNT <> 0 THEN
7221: forall i in lhst_line_id_tab.FIRST..lhst_line_id_tab.LAST
7222: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
7223: MERGE_LOG_ID,
7224: TABLE_NAME,
7225: MERGE_HEADER_ID,
7226: PRIMARY_KEY_ID1,

Line 7244: HZ_CUSTOMER_MERGE_LOG_s.nextval,

7240: LAST_UPDATE_LOGIN,
7241: LAST_UPDATE_DATE,
7242: LAST_UPDATED_BY
7243: ) VALUES (
7244: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7245: 'OE_BLANKET_LINES_HIST',
7246: MERGE_HEADER_ID_LIST(I),
7247: lhst_line_id_tab(I),
7248: lhst_version_number_tab(I),

Line 7385: insert into HZ_CUSTOMER_MERGE_LOG (

7381: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7382: arp_message.set_token( 'TABLE_NAME', 'OE_EM_INFORMATION_ALL', FALSE );
7383:
7384: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
7385: insert into HZ_CUSTOMER_MERGE_LOG (
7386: MERGE_LOG_ID,
7387: TABLE_NAME,
7388: MERGE_HEADER_ID,
7389: PRIMARY_KEY1,

Line 7401: HZ_CUSTOMER_MERGE_LOG_s.nextval,

7397: LAST_UPDATE_DATE,
7398: LAST_UPDATED_BY)
7399:
7400: SELECT
7401: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7402: 'OE_EM_INFORMATION_ALL',
7403: m.CUSTOMER_MERGE_HEADER_ID,
7404: h.ORIG_SYS_DOCUMENT_REF,
7405: h.sold_to_org_id,