APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_OFFR_ELIG_PROD_DENORM_PVT

Line 292: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql(p_context => 'ITEM'

288: FND_DSQL.add_text('(SELECT ''OFFR'', product_id ' );
289: FND_DSQL.add_text(' FROM ( ');
290:
291: /*kdass 05-MAY-2006 bug 5205721 - use refresh_products() as it considers excluded items
292: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql(p_context => 'ITEM'
293: ,p_attribute => p_product_attr
294: ,p_attr_value_from => p_product
295: ,p_attr_value_to => NULL
296: ,p_comparison => NULL

Line 305: ozf_offr_elig_prod_denorm_pvt.refresh_products(p_api_version => p_api_version

301: --kdass 21-JUN-2006 bug 5337761 - added exception handling code
302: BEGIN
303: SAVEPOINT refresh_prod;
304:
305: ozf_offr_elig_prod_denorm_pvt.refresh_products(p_api_version => p_api_version
306: ,p_init_msg_list => p_init_msg_list
307: ,p_commit => p_commit
308: ,p_list_header_id => p_list_header_id
309: ,p_calling_from_den => 'N'

Line 2841: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql (

2837: --l_temp_sql := 'SELECT -1 product_id FROM DUAL';
2838: FND_DSQL.add_text('SELECT -1 product_id FROM DUAL');
2839: ----DBMS_output.put_line (' IN ALL products ');
2840: ELSE
2841: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql (
2842: p_context=> 'ITEM',
2843: p_attribute=> product_rec.product_attribute,
2844: p_attr_value_from=> product_rec.product_attr_value, -- product_id
2845: -- p_attr_value_from=> 199,