[Home] [Help]
53: <> pqh_rct_shd.g_old_rec.routing_category_id) then
54: --
55: -- raise error as PK has changed
56: --
57: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_PK');
58: --
59: elsif not l_api_updating then
60: --
61: -- check if PK is null
63: if p_routing_category_id is not null then
64: --
65: -- raise error as PK is not null
66: --
67: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_PK');
68: --
69: end if;
70: --
71: end if;
139: --
140: -- raise error as FK does not relate to PK in
141: -- pqh_transaction_categories table.
142: --
143: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK2');
144: --
145: end if;
146: --
147: close c1;
459: --
460: -- raise error as FK does not relate to PK in
461: -- pqh_transaction_categories table.
462: --
463: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK2');
464: --
465: end if;
466: --
467: close c1;
794: --
795: -- raise error as FK does not relate to PK in pqh_routing_lists
796: -- table.
797: --
798: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK1');
799: --
800: end if;
801: --
802: close c1;
1088: --
1089: -- raise error as FK does not relate to PK in per_position_structures
1090: -- table.
1091: --
1092: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK3');
1093: --
1094: end if;
1095: --
1096: close c1;
1177: --
1178: -- raise error as FK does not relate to PK in hr_all_positions_f
1179: -- table.
1180: --
1181: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK4');
1182: --
1183: end if;
1184: --
1185: close c1;
1239: --
1240: --
1241: l_routing_type pqh_transaction_categories.member_cd%type;
1242: --
1243: l_prev_routing_cat pqh_routing_categories.routing_category_id%type;
1244: l_prev_range_name pqh_attribute_ranges.range_name%type;
1245: l_prev_list_name varchar2(250);
1246: null_rule_flag varchar2(1);
1247: --
1244: l_prev_range_name pqh_attribute_ranges.range_name%type;
1245: l_prev_list_name varchar2(250);
1246: null_rule_flag varchar2(1);
1247: --
1248: l_routing_category_id pqh_routing_categories.routing_category_id%type;
1249: l_list_name varchar2(250);
1250: l_range_name pqh_attribute_ranges.range_name%type;
1251: l_attribute_id pqh_attribute_ranges.attribute_id%type;
1252: l_from_char pqh_attribute_ranges.from_char%type;
1288: ||''''||'PQH_SUPERVISORY_HIERARCHY'||''''||','
1289: ||''''||'SUPERVISORY_HIERARCHY'||''''||'),';
1290: End if;
1291:
1292: sql_stmt := sql_stmt ||'a.range_name, a.attribute_id, a.from_char, a.to_char, a.from_number, a.to_number, a.from_date, a.to_date from pqh_attribute_ranges a,pqh_routing_categories b, pqh_routing_lists RLT, per_position_structures PPS ';
1293:
1294: sql_stmt := sql_stmt ||' Where b.transaction_category_id = :p_transaction_category_id and b.enable_flag = :p_enable_flag '
1295: ||' and nvl(b.default_flag,:null_val) <> :p_default_flag and nvl(b.delete_flag,:null_val2) <> :p_delete_flag and b.routing_category_id = a.routing_category_id(+) ';
1296:
1422: type cur_type IS REF CURSOR;
1423: rct_cur cur_type;
1424: sql_stmt varchar2(1000);
1425: --
1426: l_routing_category_id pqh_routing_categories.routing_category_id%type;
1427: --
1428: l_proc varchar2(72) := g_package||'chk_if_routing_cat_exists';
1429: --
1430: Begin
1430: Begin
1431: --
1432: hr_utility.set_location('Entering:'|| l_proc, 10);
1433: --
1434: sql_stmt := 'Select routing_category_id from pqh_routing_categories where transaction_category_id = :t';
1435: --
1436: -- Select only the routing categories that belong to the current routing
1437: -- type of the transaction category.
1438: --