DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_FILTER_SETS

Line 1775: FROM CZ_FILTER_SETS

1771:
1772: if l_rule_type = RULE_TYPE_POPULATOR then
1773: BEGIN
1774: SELECT filter_set_id INTO l_filter_set_id
1775: FROM CZ_FILTER_SETS
1776: WHERE rule_id=p_rule_id AND rownum<2;
1777: EXCEPTION
1778: WHEN NO_DATA_FOUND THEN
1779: NULL;

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

2160: WHERE rule_id=p_rule_id AND deleted_flag='0';
2161:
2162: /* need to investigate this, sselahi */
2163: if l_rule_type = RULE_TYPE_POPULATOR then
2164: l_new_filter_set_id := allocateId('CZ_FILTER_SETS_S');
2165:
2166: INSERT INTO CZ_FILTER_SETS
2167: (
2168: FILTER_SET_ID

Line 2166: INSERT INTO CZ_FILTER_SETS

2162: /* need to investigate this, sselahi */
2163: if l_rule_type = RULE_TYPE_POPULATOR then
2164: l_new_filter_set_id := allocateId('CZ_FILTER_SETS_S');
2165:
2166: INSERT INTO CZ_FILTER_SETS
2167: (
2168: FILTER_SET_ID
2169: ,DEVL_PROJECT_ID
2170: ,RULE_ID

Line 2198: FROM CZ_FILTER_SETS

2194: ,CHECKOUT_USER
2195: ,SOURCE_SYNTAX
2196: ,SOURCE_VIEW_OWNER
2197: ,SOURCE_VIEW_NAME
2198: FROM CZ_FILTER_SETS
2199: WHERE rule_id = p_rule_id AND deleted_flag='0';
2200:
2201: l_new_populator_id := allocateId('CZ_POPULATORS_S');
2202: