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.HZ_IMP_DQM_STAGE dependencies on HZ_IMP_DQM_STAGE

Line 1: PACKAGE BODY HZ_IMP_DQM_STAGE AS

1: PACKAGE BODY HZ_IMP_DQM_STAGE AS
2: /* $Header: ARHDISTB.pls 120.22.12020000.2 2012/11/28 09:09:39 amstephe ship $ */
3:
4: /*
5: Developer Notes:

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_IMP_DQM_STAGE' ;

8: TYPE coltab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
9: l_trans_list coltab;
10:
11: TYPE StageImpContactCurTyp IS REF CURSOR;
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_IMP_DQM_STAGE' ;
13:
14:
15: NO_STD_CHK CONSTANT INTEGER := 1;
16: DO_STD_CHK CONSTANT INTEGER := 2;

Line 661: log('calling HZ_IMP_DQM_STAGE.POP_INTERFACE_SEARCH_TAB');

657: IF (l_row_id IS NULL) THEN
658: EXIT;
659: END IF;
660: COMMIT;
661: log('calling HZ_IMP_DQM_STAGE.POP_INTERFACE_SEARCH_TAB');
662: log ('p_batch_id = ' || p_batch_id);
663: log ('p_match_rule_id = ' || p_match_rule_id);
664: log ('l_from_osr = ' || l_from_osr);
665: log ('l_to_osr = ' || l_to_osr);

Line 666: HZ_IMP_DQM_STAGE.POP_INTERFACE_SEARCH_TAB(to_number(p_batch_id),

662: log ('p_batch_id = ' || p_batch_id);
663: log ('p_match_rule_id = ' || p_match_rule_id);
664: log ('l_from_osr = ' || l_from_osr);
665: log ('l_to_osr = ' || l_to_osr);
666: HZ_IMP_DQM_STAGE.POP_INTERFACE_SEARCH_TAB(to_number(p_batch_id),
667: to_number(p_match_rule_id), l_from_osr, l_to_osr,
668: x_return_status, x_msg_count, x_msg_data);
669:
670: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

Line 762: -- HZ_IMP_DQM_STAGE.dqm_pre_imp_cleanup(p_batch_id, x_return_status, x_msg_count, x_msg_data);

758:
759: chk_table('HZ_INT_DUP_RESULTS', p_batch_id);
760: UPDATE HZ_IMP_BATCH_SUMMARY set BATCH_DEDUP_STATUS = 'PROCESSING' where batch_id = p_batch_id;
761: COMMIT;
762: -- HZ_IMP_DQM_STAGE.dqm_pre_imp_cleanup(p_batch_id, x_return_status, x_msg_count, x_msg_data);
763: FOR I in 1..to_number(p_num_of_workers) LOOP
764: log('I = ' || I);
765: l_sub_requests(i) := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDIDIW',
766: 'Interface Duplicate Identification Worker' || to_char(i),

Line 966: and HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'Y'

962: -- FOR TX IN (select decode(attribute_name, 'PARTY_NAME', 'ORGANIZATION_NAME', attribute_name) as attribute_name
963: FOR TX IN (select attribute_name
964: from hz_trans_attributes_b
965: where entity_name = p_entity_name
966: and HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'Y'
967: and custom_attribute_procedure is null
968: /* and attribute_name not in
969: ('SIC_CODE', 'SIC_CODE_TYPE', 'TAX_NAME', 'CATEGORY_CODE', 'IDENTIFYING_ADDRESS_FLAG', 'STATUS', 'PRIMARY_FLAG', 'REFERENCE_USE_FLAG' ) */
970: and attribute_id in ( select attribute_id

Line 1125: and HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'Y'

1121: select attribute_id
1122: from hz_match_rule_secondary
1123: where match_rule_id = p_rule_id)
1124: and entity_name = p_entity_name
1125: and HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'Y'
1126: and custom_attribute_procedure is null
1127: /* and attribute_name not in
1128: ('SIC_CODE', 'SIC_CODE_TYPE', 'TAX_NAME', 'CATEGORY_CODE', 'IDENTIFYING_ADDRESS_FLAG', 'STATUS', 'PRIMARY_FLAG', 'REFERENCE_USE_FLAG' ) */
1129: ) LOOP

Line 1301: or HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'N'

1297: and attribute_id not in (
1298: select attribute_id
1299: from hz_trans_attributes_b
1300: where custom_attribute_procedure is not null
1301: or HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'N'
1302: /* or attribute_name in
1303: ('SIC_CODE', 'SIC_CODE_TYPE', 'TAX_NAME', 'CATEGORY_CODE', 'IDENTIFYING_ADDRESS_FLAG', 'STATUS', 'PRIMARY_FLAG', 'REFERENCE_USE_FLAG' ) */
1304: ) order by STAGED_ATTRIBUTE_COLUMN
1305: ) LOOP

Line 1494: or HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'N'

1490: and attribute_id not in (
1491: select attribute_id
1492: from hz_trans_attributes_b
1493: where custom_attribute_procedure is not null
1494: or HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'N'
1495:
1496: ) order by STAGED_ATTRIBUTE_COLUMN
1497: ) LOOP
1498: IF is_first THEN

Line 1820: and HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'Y'

1816: and match_rule_id = p_rule_id)
1817: and nvl(active_flag, 'Y') <> 'N'
1818: and entity_name = p_entity_name
1819: and custom_attribute_procedure is null
1820: and HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'Y'
1821: order by STAGED_ATTRIBUTE_COLUMN
1822: ) LOOP
1823: -- DO THIS IF AND ONLY IF THIS ATTRIBUTE IS A CONDITION ATTRIBUTE
1824: IF HZ_WORD_CONDITIONS_PKG.is_a_cond_attrib( TX.ATTRIBUTE_ID)

Line 1865: and HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'Y'

1861: and match_rule_id = p_rule_id)
1862: and nvl(active_flag, 'Y') <> 'N'
1863: and entity_name = p_entity_name
1864: and custom_attribute_procedure is null
1865: and HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'Y'
1866: -- and attribute_name not in
1867: -- ('SIC_CODE', 'SIC_CODE_TYPE', 'TAX_NAME', 'CATEGORY_CODE', 'IDENTIFYING_ADDRESS_FLAG', 'STATUS', 'PRIMARY_FLAG', 'REFERENCE_USE_FLAG' )
1868:
1869: order by STAGED_ATTRIBUTE_COLUMN

Line 2120: l(' l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id); ');

2116: l(' ');
2117: l(' count NUMBER := 0; ');
2118: l(' l_os VARCHAR2(30); ');
2119: l(' BEGIN ');
2120: l(' l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id); ');
2121: chk_et_req('PARTY', p_rule_id, x_bool);
2122: IF (x_bool = 'Y') THEN
2123: -- query for interface to TCA
2124: l(' open p_party_cur FOR ');

Line 2437: l(' l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id); ');

2433: l(' l_party_site_cur HZ_PARTY_STAGE.StageCurTyp; ');
2434: l(' ');
2435: l(' l_os VARCHAR2(30); ');
2436: l(' BEGIN ');
2437: l(' l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id); ');
2438: x_bool := 'N';
2439: chk_et_req('PARTY_SITES', p_rule_id, x_bool);
2440: IF (x_bool = 'Y') THEN
2441:

Line 2820: l(' l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id); ');

2816: l(' where match_rule_id = '|| p_rule_id ||' ) and rownum = 1; ');
2817: l(' ');
2818: l(' l_os VARCHAR2(30); ');
2819: l(' BEGIN --');
2820: l(' l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id); ');
2821: x_bool := 'N';
2822: chk_et_req('CONTACTS', p_rule_id, x_bool);
2823: IF (x_bool = 'Y') THEN
2824: l(' OPEN c1; ');

Line 3325: l(' l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id); ');

3321: l(' l_last_fetch BOOLEAN := FALSE; ');
3322: l(' l_cp_cur HZ_PARTY_STAGE.StageCurTyp; ');
3323: l(' l_os VARCHAR2(30); ');
3324: l(' BEGIN ');
3325: l(' l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id); ');
3326: x_bool := 'N';
3327: chk_et_req('CONTACT_POINTS', p_rule_id, x_bool);
3328: IF (x_bool = 'Y') THEN
3329: -- query for interface to tca

Line 3676: and HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'Y'

3672: --Fix for bug 4669257. Removing the hardcoded reference below.
3673: --where userenv('LANG') = 'US'
3674: where entity_name = p_entity_name
3675: and custom_attribute_procedure is null
3676: and HZ_IMP_DQM_STAGE.EXIST_COL(attribute_name, p_entity_name) = 'Y'
3677: -- and attribute_name not in ('SIC_CODE', 'SIC_CODE_TYPE', 'TAX_NAME', 'CATEGORY_CODE', 'IDENTIFYING_ADDRESS_FLAG', 'STATUS', 'PRIMARY_FLAG', 'REFERENCE_USE_FLAG' )
3678: and attribute_id in ( select attribute_id
3679: from hz_match_rule_primary
3680: where match_rule_id = p_rule_id

Line 3927: END HZ_IMP_DQM_STAGE;

3923: COMMIT;
3924:
3925: END gen_hz_dqm_imp_debug;
3926: */
3927: END HZ_IMP_DQM_STAGE;
3928: