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 3643: l_attribute_name := ' decode(accept_standardized_flag, ''Y'', a.' || l_attribute_name || ', a.' || p_attribute_name || ')' ;

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

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

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