DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_FILTER_SETS

Line 1747: FROM CZ_FILTER_SETS

1743:
1744: if l_rule_type = RULE_TYPE_POPULATOR then
1745: BEGIN
1746: SELECT filter_set_id INTO l_filter_set_id
1747: FROM CZ_FILTER_SETS
1748: WHERE rule_id=p_rule_id AND rownum<2;
1749: EXCEPTION
1750: WHEN NO_DATA_FOUND THEN
1751: NULL;

Line 2136: l_new_filter_set_id := allocateId('CZ_FILTER_SETS_S');

2132: WHERE rule_id=p_rule_id AND deleted_flag='0';
2133:
2134: /* need to investigate this, sselahi */
2135: if l_rule_type = RULE_TYPE_POPULATOR then
2136: l_new_filter_set_id := allocateId('CZ_FILTER_SETS_S');
2137:
2138: INSERT INTO CZ_FILTER_SETS
2139: (
2140: FILTER_SET_ID

Line 2138: INSERT INTO CZ_FILTER_SETS

2134: /* need to investigate this, sselahi */
2135: if l_rule_type = RULE_TYPE_POPULATOR then
2136: l_new_filter_set_id := allocateId('CZ_FILTER_SETS_S');
2137:
2138: INSERT INTO CZ_FILTER_SETS
2139: (
2140: FILTER_SET_ID
2141: ,DEVL_PROJECT_ID
2142: ,RULE_ID

Line 2170: FROM CZ_FILTER_SETS

2166: ,CHECKOUT_USER
2167: ,SOURCE_SYNTAX
2168: ,SOURCE_VIEW_OWNER
2169: ,SOURCE_VIEW_NAME
2170: FROM CZ_FILTER_SETS
2171: WHERE rule_id = p_rule_id AND deleted_flag='0';
2172:
2173: l_new_populator_id := allocateId('CZ_POPULATORS_S');
2174: