[Home] [Help]
1249: )
1250: IS
1251:
1252: BEGIN
1253: INSERT INTO hr_application_ownerships
1254: (key_name
1255: ,product_name
1256: ,key_value)
1257: (
1260: ,p_key_value
1261: FROM dual
1262: WHERE NOT EXISTS
1263: (SELECT NULL
1264: FROM hr_application_ownerships
1265: WHERE product_name = p_product_name
1266: AND key_name = p_key_name
1267: AND key_value = p_key_value
1268: )
1270:
1271: END insert_ownership;
1272:
1273: -- ---------------------------------------------------------------------
1274: -- This procedure inserts the ownership in hr_application_ownerships
1275: -- table for element classifications belonging to 'ZZ' legislation.
1276: -- ---------------------------------------------------------------------
1277: PROCEDURE ins_element_class_ownership IS
1278:
1295:
1296: END ins_element_class_ownership;
1297:
1298: -- ---------------------------------------------------------------------
1299: -- This procedure inserts the ownership in hr_application_ownerships
1300: -- table for balance types belonging to 'ZZ' legislation.
1301: -- ---------------------------------------------------------------------
1302: PROCEDURE ins_bal_type_ownership IS
1303:
1320:
1321: END ins_bal_type_ownership;
1322:
1323: -- ---------------------------------------------------------------------
1324: -- This procedure inserts the ownership in hr_application_ownerships
1325: -- table for balance types belonging to 'ZZ' legislation.
1326: -- ---------------------------------------------------------------------
1327: PROCEDURE ins_bal_dim_ownership IS
1328:
1345:
1346: END ins_bal_dim_ownership;
1347:
1348: -- ---------------------------------------------------------------------
1349: -- This procedure inserts the ownership in hr_application_ownerships
1350: -- table for defined balances belonging to 'ZZ' legislation.
1351: -- ---------------------------------------------------------------------
1352: PROCEDURE ins_def_bal_ownership IS
1353:
1376:
1377: END ins_def_bal_ownership;
1378:
1379: -- ---------------------------------------------------------------------
1380: -- This procedure inserts the ownership in hr_application_ownerships
1381: -- table for routes belonging to 'ZZ' legislation.
1382: -- ---------------------------------------------------------------------
1383: PROCEDURE ins_route_ownership IS
1384:
1412:
1413: END ins_route_ownership;
1414:
1415: -- ---------------------------------------------------------------------
1416: -- This procedure inserts the ownership in hr_application_ownerships
1417: -- table for balance categories belonging to 'ZZ' legislation.
1418: -- ---------------------------------------------------------------------
1419: PROCEDURE ins_bal_cat_ownership IS
1420:
1440:
1441:
1442:
1443: -- ---------------------------------------------------------------------
1444: -- This procedure inserts the ownership in hr_application_ownerships
1445: -- table.
1446: -- ---------------------------------------------------------------------
1447: PROCEDURE insert_all_ownerships IS
1448: