APPS.HZ_DQM_MR_PVT dependencies on HZ_IMP_DQM_STAGE

Line 359: HZ_IMP_DQM_STAGE.gen_pkg_spec(p_pkg_name, p_match_rule_id);

355: IS
356: BEGIN
357: l('CREATE or REPLACE PACKAGE ' || p_pkg_name || ' AUTHID CURRENT_USER AS');
358: l('PROCEDURE tca_join_entities(trap_explosion in varchar2, rows_in_chunk in number,inserted_duplicates out number);');
359: HZ_IMP_DQM_STAGE.gen_pkg_spec(p_pkg_name, p_match_rule_id);
360: l('');
361: l('');
362: l('PROCEDURE interface_tca_join_entities(p_batch_id in number,');
363: l(' from_osr in varchar2, to_osr in varchar2, p_threshold in number, p_auto_merge_threshold in number);');

Line 401: HZ_IMP_DQM_STAGE.gen_pkg_body(p_pkg_name, p_match_rule_id);

397: IS
398: temp number;
399: BEGIN
400: l('CREATE or REPLACE PACKAGE BODY ' || p_pkg_name || ' AS');
401: HZ_IMP_DQM_STAGE.gen_pkg_body(p_pkg_name, p_match_rule_id);
402: l('');
403: l('');
404: l('');
405: l('');

Line 1656: and HZ_IMP_DQM_STAGE.EXIST_COL(a.attribute_name, a.entity_name ) = 'Y'

1652: where p.match_rule_id=p_match_rule_id
1653: and p.attribute_id=a.attribute_id
1654: and a.entity_name = p_entity
1655: and nvl(p.filter_flag,'N') = 'Y'
1656: and HZ_IMP_DQM_STAGE.EXIST_COL(a.attribute_name, a.entity_name ) = 'Y'
1657: )
1658: LOOP
1659: -- between attributes
1660: IF FIRST1

Line 1744: and HZ_IMP_DQM_STAGE.EXIST_COL(a.attribute_name, a.entity_name ) = 'Y'

1740: where p.match_rule_id=p_match_rule_id
1741: and p.attribute_id=a.attribute_id
1742: and a.entity_name = 'PARTY'
1743: and nvl(p.filter_flag,'N') = 'Y'
1744: and HZ_IMP_DQM_STAGE.EXIST_COL(a.attribute_name, a.entity_name ) = 'Y'
1745: )
1746: LOOP
1747: IF FIRST1
1748: THEN

Line 1948: and HZ_IMP_DQM_STAGE.EXIST_COL(a.attribute_name, a.entity_name ) = 'Y'

1944: where p.match_rule_id=p_match_rule_id
1945: and p.attribute_id=a.attribute_id
1946: and a.entity_name = p_entity
1947: and nvl(p.filter_flag,'N') = 'Y'
1948: and HZ_IMP_DQM_STAGE.EXIST_COL(a.attribute_name, a.entity_name ) = 'Y'
1949: )
1950: LOOP
1951: -- between attributes
1952: IF FIRST1

Line 2755: and HZ_IMP_DQM_STAGE.EXIST_COL(a.attribute_name, a.entity_name ) = 'Y'

2751: where p.match_rule_id=p_match_rule_id
2752: and p.attribute_id=a.attribute_id
2753: and a.entity_name = p_entity
2754: and nvl(p.filter_flag,'N') = 'Y'
2755: and HZ_IMP_DQM_STAGE.EXIST_COL(a.attribute_name, a.entity_name ) = 'Y'
2756: )
2757: LOOP
2758: -- between attributes
2759: IF FIRST1

Line 2831: and HZ_IMP_DQM_STAGE.EXIST_COL(a.attribute_name, a.entity_name ) = 'Y'

2827: where p.match_rule_id=p_match_rule_id
2828: and p.attribute_id=a.attribute_id
2829: and a.entity_name = 'PARTY'
2830: and nvl(p.filter_flag,'N') = 'Y'
2831: and HZ_IMP_DQM_STAGE.EXIST_COL(a.attribute_name, a.entity_name ) = 'Y'
2832: )
2833: LOOP
2834: IF FIRST1
2835: THEN