[Home] [Help]
29: Date Name Vers Bug No Description
30: ----------- ---------- ------ ------- -------------------------------
31: 23-APR-2004 sdahiya 115.0 Created.
32: 12-MAY-2004 sdahiya 115.1 Modified phase to plb.
33: 17-MAY-2004 sdahiya 115.2 3622290 Added fnd_date.canonical_to_date
34: while converting varchar to date.
35: 18-MAY-2004 sdahiya 115.3 2658290, - Moved dedn amount calculation
36: 1481913, from cal_formula_bo to
37: base_formula.
660: l_proc_name := l_package_name||'BASE_FORMULA';
661:
662: default_number := -9999;
663: default_string := 'NOT ENTERED';
664: default_date := fnd_date.canonical_to_date('0001/01/01');
665: sub_prio_max := 9999;
666: l_garn_fee_max_fee_amt := NULL;
667: GLB_NUM_ELEM := nvl(GLB_NUM_ELEM ,0);
668: --bug 9788510
1640: BEGIN
1641: l_proc_name := l_package_name||'CAL_FORMULA_SS';
1642: hr_utility.trace('Entering '||l_proc_name);
1643:
1644: default_date := fnd_date.canonical_to_date('0001/01/01');
1645: default_string := 'NOT ENTERED';
1646: default_number := -9999;
1647: INV_DED_OVR_GRN_EX_DI_PCT := default_number;
1648: INV_DED_OVR_GRN_EX_DI_PCT_ARR := default_number;
4003: l_proc_name := l_package_name||'CAL_FORMULA_BO';
4004: hr_utility.trace('Entering '||l_proc_name);
4005:
4006: default_number := -9999;
4007: default_date := fnd_date.canonical_to_date('0001/01/01');
4008: sub_prio_max := 9999;
4009: amount := GLB_AMT(P_CTX_ORIGINAL_ENTRY_ID);
4010: percentage := GLB_PCT(P_CTX_ORIGINAL_ENTRY_ID);
4011: num_dependents := GLB_NUM_DEPS(P_CTX_ORIGINAL_ENTRY_ID);
4749: ELSIF GARN_EXEMPTION_CALC_RULE = 'MARSTAT_RULE' OR
4750: GARN_EXEMPTION_CALC_RULE = 'ONE_MARSTAT_RULE' THEN
4751: IF SUBSTR(Jurisdiction,1,2) = '02' /* Alaska */ THEN
4752:
4753: IF P_CTX_DATE_EARNED < fnd_date.canonical_to_date('2009/01/01') THEN
4754: IF Filing_Status = '01' THEN /* SINGLE */
4755: DI_state_exemption_amt := 420;
4756: ELSE /* otherwise considered H OF H */
4757: DI_state_exemption_amt := 660;
4845: IF date_served = default_date THEN
4846: open csr_get_entry_start_date;
4847: fetch csr_get_entry_start_date into ld_entry_start_date;
4848: close csr_get_entry_start_date;
4849: IF ld_entry_start_date >= fnd_date.canonical_to_date('2006/01/01') THEN
4850: lb_use_state_min_wage := TRUE;
4851: DI_state_exemption_amt := GREATEST(DI_state_exemption_amt,
4852: NVL(ln_M_S_factor, GARN_EXEMPTION_MIN_WAGE_FACTOR) * NVL(c_State_Minimum_Wage, c_Federal_Minimum_Wage));
4853: END IF;
4850: lb_use_state_min_wage := TRUE;
4851: DI_state_exemption_amt := GREATEST(DI_state_exemption_amt,
4852: NVL(ln_M_S_factor, GARN_EXEMPTION_MIN_WAGE_FACTOR) * NVL(c_State_Minimum_Wage, c_Federal_Minimum_Wage));
4853: END IF;
4854: ELSIF date_served >= fnd_date.canonical_to_date('2006/01/01') THEN
4855: lb_use_state_min_wage := TRUE;
4856: DI_state_exemption_amt := GREATEST(DI_state_exemption_amt,
4857: NVL(ln_M_S_factor, GARN_EXEMPTION_MIN_WAGE_FACTOR) * NVL(c_State_Minimum_Wage, c_Federal_Minimum_Wage));
4858: END IF;
5069: /*Below code added for 12529733, changed for 12795985. It is gross wage that
5070: needs to be considered and not DI.
5071: Bug 12529733, 12795985 changes starts here*/
5072: IF SUBSTR(Jurisdiction,1,2) = '22' and garn_category IN ('CD', 'G') then
5073: IF P_CTX_DATE_EARNED > fnd_date.canonical_to_date('2011/04/06') THEN
5074: DI_state_exemption_amt := c_MA_gross_erngs_exmpt_pct * GROSS_EARNINGS_ASG_GRE_RUN;
5075: DI_state_exemption_amt := Total_DI - (GROSS_EARNINGS_ASG_GRE_RUN - DI_state_exemption_amt);
5076: DI_state_exemption_amt := Convert_Period_Type(SCL_ASG_US_WORK_SCHEDULE,
5077: ASG_HOURS,
6069:
6070: l_proc_name := l_package_name||'CAL_FORMULA_TL';
6071: hr_utility.trace('Entering '||l_proc_name);
6072:
6073: default_date := fnd_date.canonical_to_date('0001/01/01');
6074: sub_prio_max := 9999;
6075: default_number := -9999;
6076: amount := GLB_AMT(P_CTX_ORIGINAL_ENTRY_ID);
6077: filing_status := GLB_FIL_STAT(P_CTX_ORIGINAL_ENTRY_ID);