APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_SEARCH_SELECTIONS_T

Line 289: INSERT INTO ozf_search_selections_t(attribute_value, attribute_id) VALUES(p_attr_value, p_attribute);

285:
286: x_return_status := FND_API.g_ret_sts_success;
287:
288: IF p_attribute = 'PRICING_ATTRIBUTE1' THEN
289: INSERT INTO ozf_search_selections_t(attribute_value, attribute_id) VALUES(p_attr_value, p_attribute);
290: ELSE
291: OPEN c_prod_stmt;
292: FETCH c_prod_stmt INTO l_prod_stmt, l_cond_id;
293: CLOSE c_prod_stmt;

Line 295: l_prod_stmt := 'INSERT INTO ozf_search_selections_t(attribute_value, attribute_id) ' || l_prod_stmt;

291: OPEN c_prod_stmt;
292: FETCH c_prod_stmt INTO l_prod_stmt, l_cond_id;
293: CLOSE c_prod_stmt;
294:
295: l_prod_stmt := 'INSERT INTO ozf_search_selections_t(attribute_value, attribute_id) ' || l_prod_stmt;
296:
297: IF l_cond_id IS NOT NULL THEN
298: IF INSTR(UPPER(l_prod_stmt),'WHERE') > 0 THEN
299: l_prod_stmt := l_prod_stmt || ' AND ' || l_cond_id || ' = :1 ';

Line 844: EXECUTE IMMEDIATE 'TRUNCATE TABLE ozf_search_selections_t';

840: IF l_stmt_temp IS NULL THEN
841: l_no_query_flag := 'Y';
842: ELSE
843: IF l_no_excl_products > 0 THEN
844: EXECUTE IMMEDIATE 'TRUNCATE TABLE ozf_search_selections_t';
845: FOR j IN c_excluded_products(l_offer_id,i.off_discount_product_id)
846: LOOP
847: IF j.product_level = 'PRODUCT' THEN
848: l_context_attr := 'PRICING_ATTRIBUTE1';

Line 875: --FND_DSQL.add_text(' MINUS select attribute_value product_id, attribute_id product_type from ozf_search_selections_t ');

871: p_comparison => NULL,
872: p_type => 'PROD' );
873:
874: END LOOP;
875: --FND_DSQL.add_text(' MINUS select attribute_value product_id, attribute_id product_type from ozf_search_selections_t ');
876: END IF;
877: END IF;
878:
879: FND_DSQL.add_text(')');

Line 1114: EXECUTE IMMEDIATE 'TRUNCATE TABLE ozf_search_selections_t';

1110: END IF;
1111: END LOOP; -- j loop
1112:
1113: IF l_no_excl_products > 0 THEN
1114: EXECUTE IMMEDIATE 'TRUNCATE TABLE ozf_search_selections_t';
1115: FOR k IN c_excluded_products(l_offer_id,i.offer_discount_line_id) LOOP
1116: insert_excl_prod(p_api_version => p_api_version,
1117: p_init_msg_list => p_init_msg_list,
1118: p_commit => p_commit,

Line 1137: --FND_DSQL.add_text(' MINUS select attribute_value product_id, attribute_id product_type from ozf_search_selections_t ');

1133: p_type => 'PROD'
1134: );
1135:
1136: END LOOP; -- k loop
1137: --FND_DSQL.add_text(' MINUS select attribute_value product_id, attribute_id product_type from ozf_search_selections_t ');
1138: END IF;
1139:
1140: l_no_query_flag := 'N';
1141: ELSE

Line 1977: EXECUTE IMMEDIATE 'TRUNCATE TABLE ozf_search_selections_t';

1973: IF l_stmt_temp IS NULL THEN
1974: l_no_query_flag := 'Y';
1975: ELSE
1976: IF l_no_excl_products > 0 THEN
1977: EXECUTE IMMEDIATE 'TRUNCATE TABLE ozf_search_selections_t';
1978: FOR j IN c_excluded_products(i.activity_product_id, l_org_id) LOOP
1979: IF j.level_type_code = 'PRODUCT' THEN
1980: l_context_attr := 'PRICING_ATTRIBUTE1';
1981: l_prod_attr_val := j.inventory_item_id;

Line 2006: --FND_DSQL.add_text(' MINUS select attribute_value product_id, attribute_id product_type from ozf_search_selections_t ');

2002: p_attr_value_to => NULL,
2003: p_comparison => NULL,
2004: p_type => 'PROD' );
2005: END LOOP;
2006: --FND_DSQL.add_text(' MINUS select attribute_value product_id, attribute_id product_type from ozf_search_selections_t ');
2007: END IF;
2008: END IF;
2009:
2010: FND_DSQL.add_text(')');

Line 2252: EXECUTE IMMEDIATE 'TRUNCATE TABLE ozf_search_selections_t';

2248: IF l_stmt_temp IS NULL THEN
2249: l_no_query_flag := 'Y';
2250: ELSE
2251: IF l_no_excl_products > 0 THEN
2252: EXECUTE IMMEDIATE 'TRUNCATE TABLE ozf_search_selections_t';
2253: FOR j IN c_products(i.list_line_id, 'Y') LOOP
2254: insert_excl_prod(p_api_version => p_api_version,
2255: p_init_msg_list => p_init_msg_list,
2256: p_commit => p_commit,

Line 2275: --FND_DSQL.add_text(' MINUS select attribute_value product_id, attribute_id product_type from ozf_search_selections_t ');

2271: p_type => 'PROD'
2272: );
2273:
2274: END LOOP;
2275: --FND_DSQL.add_text(' MINUS select attribute_value product_id, attribute_id product_type from ozf_search_selections_t ');
2276:
2277: END IF;
2278: END IF;
2279: