[Home] [Help]
2062: financials_system_params_all fsp
2063: WHERE hr.set_of_books_id = gsob.set_of_books_id
2064: AND mo_global.check_access(hr.organization_id) = 'Y'
2065: AND hr.organization_id NOT IN
2066: ( SELECT DISTINCT ORG_ID FROM GHG_EMISSION_FORMULAS_ALL)
2067: AND hr.organization_id = fsp.org_id;
2068:
2069: /* Cursor to get the formulas for ORG_ID -1 */
2070: Cursor seed_formula IS
2071: SELECT FORMULA_ID,
2072: DESCRIPTION,
2073: FORMULA_CONTENT,
2074: SECONDARY_FORMULA_ID
2075: FROM GHG_EMISSION_FORMULAS_ALL
2076: WHERE ORG_ID = -1;
2077:
2078: /* Variables */
2079: v_seed_row_count NUMBER := 0;
2091: /* Check if the formulas have been seeded for ORG_ID -1. If not then raise an exception */
2092: write_to_log('Checking if formula exists for ORG_ID -1');
2093: SELECT COUNT(*)
2094: INTO v_seed_row_count
2095: FROM GHG_EMISSION_FORMULAS_ALL
2096: WHERE ORG_ID = -1;
2097:
2098: IF v_seed_row_count = 0 THEN --Formula not seeded for ORG_ID -1
2099: write_to_log('No formula found for ORG_ID -1');
2100: RAISE NO_DATA_FOUND;
2101: END IF;
2102:
2103: /* Copy the formula for ORG_ID -1 into the master list of organizations and
2104: insert into GHG_EMISSION_FORMULAS_ALL table */
2105: write_to_log('Copy the formula for ORG_ID -1 into the master list of organizations');
2106: For orgs_rec IN orgs_master_list
2107: LOOP
2108: FOR seed_formula_rec in seed_formula
2106: For orgs_rec IN orgs_master_list
2107: LOOP
2108: FOR seed_formula_rec in seed_formula
2109: LOOP
2110: write_to_log('Inserting into GHG_EMISSION_FORMULAS_ALL table');
2111: INSERT INTO GHG_EMISSION_FORMULAS_ALL ( FORMULA_ID,
2112: DESCRIPTION,
2113: FORMULA_CONTENT,
2114: ORG_ID,
2107: LOOP
2108: FOR seed_formula_rec in seed_formula
2109: LOOP
2110: write_to_log('Inserting into GHG_EMISSION_FORMULAS_ALL table');
2111: INSERT INTO GHG_EMISSION_FORMULAS_ALL ( FORMULA_ID,
2112: DESCRIPTION,
2113: FORMULA_CONTENT,
2114: ORG_ID,
2115: SECONDARY_FORMULA_ID)