[Home] [Help]
1: package body PN_VAR_DEFAULTS_PKG as
2: /* $Header: PNVRDFTB.pls 120.0 2007/10/03 14:28:49 rthumma noship $ */
3:
4: /*********** Comment out code duplicate also found in PNCHCALS.pls
5:
654: --AND break_type = 'NATURAL';
655:
656: BEGIN
657: --pnp_debug_pkg.enable_file_debug(l_pathname,l_filename);
658: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_DEFAULT_LINES (+)');
659: l_var_rent_id := x_var_rent_id;
660: PNP_DEBUG_PKG.log('Parameter : x_var_rent_id = '|| l_var_rent_id);
661: FOR c_period_rec IN c_periods
662: LOOP
1134: WHERE var_rent_id = l_var_rent_id
1135: AND bkhd_start_date IS NULL
1136: AND bkhd_end_date IS NULL;
1137: --PNP_DEBUG_PKG.disable_file_debug;
1138: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_DEFAULT_LINES (-)');
1139:
1140: end create_default_lines;
1141:
1142: /*===========================================================================+
1469: l_proration_days NUMBER := 0;
1470:
1471: BEGIN
1472:
1473: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.calculate_partial_first_year (+)');
1474:
1475: /*open csr_check_no_days (X_VAR_RENT_ID);
1476: fetch csr_check_no_days into l_start_date, l_end_date, l_reporting_date;
1477: close csr_check_no_days;
1501: NULL;
1502:
1503: RETURN l_sum_sales;
1504:
1505: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.calculate_partial_first_year (-)');
1506:
1507: END calculate_partial_first_year;
1508:
1509: /*===========================================================================+
1540: l_base_rent NUMBER;
1541:
1542: BEGIN
1543:
1544: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.CALCULATE_DEFAULT_BASE_RENT (+)');
1545:
1546: IF (p_base_rent_type = 'ROLLING') THEN
1547:
1548: SELECT sum(item.ACTUAL_AMOUNT)
1591: WHEN OTHERS
1592: THEN
1593: RETURN NULL;
1594:
1595: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.CALCULATE_DEFAULT_BASE_RENT (-)');
1596:
1597: END CALCULATE_DEFAULT_BASE_RENT;
1598:
1599: /*===========================================================================+
1660: l_proration_days NUMBER := 0;
1661:
1662: BEGIN
1663:
1664: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.calculate_partial_last_year (+)');
1665:
1666: /*open csr_check_no_days (X_VAR_RENT_ID);
1667: fetch csr_check_no_days into l_reporting_date, l_start_date, l_end_date;
1668: close csr_check_no_days;
1692: NULL;
1693:
1694: RETURN l_sum_sales;
1695:
1696: PNP_DEBUG_PKG.debug ('PN_VAR_DEFAULTS_PKG.calcuLate_partial_last_year (-)');
1697:
1698: END calculate_partial_last_year;
1699:
1700: FUNCTION find_if_line_defaults_exist (p_var_rent_id NUMBER)
2023: | MODIFICATION HISTORY
2024: |
2025: | 07-JUL-06 PIkhar o Created
2026: | 28-FEB-07 PIkhar o Bug 5904246. Added
2027: | pn_var_defaults_pkg.delete_default_lines
2028: |
2029: +=============================================================================*/
2030: PROCEDURE CREATE_SETUP_DATA (X_VAR_RENT_ID IN NUMBER) IS
2031:
2126: where bkhd_default_id = p_bkhd_def_id);
2127:
2128: BEGIN
2129:
2130: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_SETUP_DATA (+)');
2131: /* dbms_output.put_line('PN_VAR_DEFAULTS_PKG.CREATE_SETUP_DATA (+)'); */
2132:
2133: l_var_rent_id := x_var_rent_id;
2134:
2127:
2128: BEGIN
2129:
2130: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_SETUP_DATA (+)');
2131: /* dbms_output.put_line('PN_VAR_DEFAULTS_PKG.CREATE_SETUP_DATA (+)'); */
2132:
2133: l_var_rent_id := x_var_rent_id;
2134:
2135: pn_var_defaults_pkg.delete_default_lines (l_var_rent_id);
2131: /* dbms_output.put_line('PN_VAR_DEFAULTS_PKG.CREATE_SETUP_DATA (+)'); */
2132:
2133: l_var_rent_id := x_var_rent_id;
2134:
2135: pn_var_defaults_pkg.delete_default_lines (l_var_rent_id);
2136:
2137: FOR per_rec IN cur_periods
2138: LOOP
2139:
2363: UPDATE pn_var_lines_all
2364: SET bkpt_update_flag = 'Y'
2365: WHERE var_rent_id = l_var_rent_id;
2366:
2367: PNP_DEBUG_PKG.log('PN_VAR_DEFAULTS_PKG.CREATE_SETUP_DATA (-)');
2368:
2369: END CREATE_SETUP_DATA;
2370:
2371:
2374: BEGIN
2375: pnp_debug_pkg.debug(p_str);
2376: END put_log;
2377:
2378: END PN_VAR_DEFAULTS_PKG;
2379: