APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_OFFR_ELIG_PROD_DENORM_PVT

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

329: FND_DSQL.add_text('(SELECT ''OFFR'', product_id ' );
330: FND_DSQL.add_text(' FROM ( ');
331:
332: /*kdass 05-MAY-2006 bug 5205721 - use refresh_products() as it considers excluded items
333: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql(p_context => 'ITEM'
334: ,p_attribute => p_product_attr
335: ,p_attr_value_from => p_product
336: ,p_attr_value_to => NULL
337: ,p_comparison => NULL

Line 346: ozf_offr_elig_prod_denorm_pvt.refresh_products(p_api_version => p_api_version

342: --kdass 21-JUN-2006 bug 5337761 - added exception handling code
343: BEGIN
344: SAVEPOINT refresh_prod;
345:
346: ozf_offr_elig_prod_denorm_pvt.refresh_products(p_api_version => p_api_version
347: ,p_init_msg_list => p_init_msg_list
348: ,p_commit => p_commit
349: ,p_list_header_id => p_list_header_id
350: ,p_calling_from_den => 'N'

Line 3003: ozf_offr_elig_prod_denorm_pvt.refresh_products(p_api_version => l_api_version

2999:
3000: BEGIN
3001: SAVEPOINT refresh_prod;
3002:
3003: ozf_offr_elig_prod_denorm_pvt.refresh_products(p_api_version => l_api_version
3004: ,p_init_msg_list => FND_API.G_FALSE
3005: ,p_commit => FND_API.G_FALSE
3006: ,p_list_header_id => l_listHeaderIdTbl(i)
3007: ,p_calling_from_den => 'N'

Line 6869: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql (

6865: --l_temp_sql := 'SELECT -1 product_id FROM DUAL';
6866: FND_DSQL.add_text('SELECT -1 product_id FROM DUAL');
6867: ----DBMS_output.put_line (' IN ALL products ');
6868: ELSE
6869: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql (
6870: p_context=> 'ITEM',
6871: p_attribute=> product_rec.product_attribute,
6872: p_attr_value_from=> product_rec.product_attr_value, -- product_id
6873: -- p_attr_value_from=> 199,