APPS.HZ_IMP_DQM_STAGE dependencies on STANDARD

Line 2280: --l(' and nvl(a.accept_standardized_flag, ''N'') <> ''Y'' ');

2276: l(' from hz_imp_addresses_int a, hz_imp_addresses_sg b ');
2277: l(' where a.batch_id = p_batch_id ');
2278: l(' and b.action_flag = ''I'' ');
2279: l(' and b.int_row_id = a.rowid ');
2280: --l(' and nvl(a.accept_standardized_flag, ''N'') <> ''Y'' ');
2281: l(' and a.party_orig_system_reference >= p_from_osr ');
2282: l(' and a.party_orig_system_reference <= p_to_osr ');
2283: l(' and b.batch_mode_flag = p_batch_mode_flag ');
2284: l(' and interface_status is null ; ');

Line 2300: l(' and a.accept_standardized_flag = ''Y'' ');

2296: l(' from hz_imp_addresses_int a, hz_imp_addresses_sg b ');
2297: l(' where a.batch_id = p_batch_id ');
2298: l(' and b.action_flag = ''I'' ');
2299: l(' and b.int_row_id = a.rowid ');
2300: l(' and a.accept_standardized_flag = ''Y'' ');
2301: l(' and a.party_orig_system_reference >= p_from_osr ');
2302: l(' and a.party_orig_system_reference <= p_to_osr; ');
2303: */
2304: -- addition ends --

Line 3646: l_attribute_name := ' decode(accept_standardized_flag, ''Y'', a.' || l_attribute_name || ', a.' || p_attribute_name || ')' ;

3642: FETCH c1 INTO l_bool;
3643: IF c1%NOTFOUND THEN
3644: l_attribute_name := ' a.' || p_attribute_name;
3645: ELSE
3646: l_attribute_name := ' decode(accept_standardized_flag, ''Y'', a.' || l_attribute_name || ', a.' || p_attribute_name || ')' ;
3647: END IF;
3648: RETURN l_attribute_name;
3649: END IF;
3650: EXCEPTION WHEN OTHERS THEN

Line 3885: --Standard call to get message count and if count is 1, get message info.

3881: HZ_GEN_PLSQL.new(l_package_name, 'PACKAGE BODY');
3882: gen_pkg_body(l_package_name, l_rule_id);
3883: HZ_GEN_PLSQL.compile_code;
3884:
3885: --Standard call to get message count and if count is 1, get message info.
3886: FND_MSG_PUB.Count_And_Get(
3887: p_encoded => FND_API.G_FALSE,
3888: p_count => x_msg_count,
3889: p_data => x_msg_data);