[Home] [Help]
53: --Bug 4176129. Removed the UNION clause as at any point only one of the 2 SQLs would get executed
54: cursor chk_ra_exists_csr(c_budget_version_id pa_budget_versions.budget_version_id%type,
55: c_period_type gl_date_period_map.period_type%type,
56: c_period_set_name gl_sets_of_books.period_set_name%type) is
57: select 'Y' from dual
58: where exists (select 'Y' from pa_resource_assignments ra
59: where budget_version_id = c_budget_version_id
60: and ra.planning_start_date is NOT NULL /* bug 3673111 */
61: and ra.planning_end_date is NOT NULL /* bug 3673111 */
70:
71:
72:
73: cursor chk_ra_for_bl_exists_csr(c_budget_version_id pa_budget_versions.budget_version_id%type) is
74: select 'Y' from dual
75: where exists (select 'Y' from pa_budget_lines bl
76: where bl.budget_version_id = c_budget_version_id
77: group by resource_assignment_id
78: having count(*) > 1);
98:
99: cursor chk_pa_gl_per_exists_csr(c_period_type pa_implementations_all.pa_period_type%type
100: ,c_budget_version_id pa_budget_versions.budget_version_id%type
101: ,c_period_set_name gl_sets_of_books.period_set_name%type) is
102: select 'Y' from dual
103: where exists ( select 'Y'
104: from pa_budget_lines bl
105: ,gl_periods gl
106: where bl.budget_version_id = c_budget_version_id
147: -- Bug 3988010. Removed the Calls to pa_misc.spread_amount function as that function
148: -- rounds the amounts. The amounts will be upgraded without applying the round function.
149:
150: -- Bug 4215637. Used ratio_to_report Function to address the fractions of the date range falling into
151: -- individual periods not summing upto 1
152:
153: -- Bug 4299635. The amounts are rounded to atmost 5 digits. This is done to make sure that the amounts
154: -- for date range budgets are correctly upgraded to periodic budgets. PC/PFC amounts need not be rounded
155: -- since they will re-derived by MC api which is called in PAFPUPGB.pls
415:
416: l_project_start_date := NULL;
417: l_org_id := NULL;
418:
419: select trunc(sysdate) into l_min_date from dual;
420:
421: --Bug 4919018
422: open ftch_period_details_csr(l_get_elig_bud_ver_csr.org_id);
423: fetch ftch_period_details_csr into l_pi_pa_period_type, l_sob_accounted_period_type, l_sob_period_set_name;
570: or
571: the record that is processed is a project/plan type level record. */
572:
573: IF l_project_start_date IS NULL THEN
574: select trunc(sysdate) into l_project_start_date from dual;
575: END IF;
576:
577: end;
578:
936: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
937: end if;
938:
939: -- Loop for Resource Assignment Id for given Budget Version
940: select decode(g_upgrade_mode,'PA_Period_Upgrade',l_pa_period_type,l_accounted_per_type) into l_per_type from dual;
941: for l_get_res_assign_id_csr in get_res_assign_id_csr(l_get_elig_bud_ver_csr.budget_version_id)
942: loop
943:
944:
1514: l_get_budget_lines_tbl(i).spr_project_revenue/l_get_budget_lines_tbl(i).spr_txn_revenue),
1515: NULL, --project_rev_rate_date_type
1516: NULL --project_rev_rate_date
1517: --Bug 4046524.Columns included for this bug end here
1518: from dual;
1519: null;
1520:
1521: end loop;
1522:
1666: --errors because of infinite digits after decimal point
1667: CURSOR c_derive_time_phase_csr(c_period_type gl_periods.period_type%TYPE)
1668: IS
1669: SELECT 1
1670: FROM dual
1671: WHERE EXISTS
1672: (SELECT 1
1673: FROM (SELECT to_number(NVL(SUM(
1674: (decode(least(bl.start_date, gl.start_date),
1692: UNION ALL
1693: SELECT to_date(NULL) start_date,
1694: to_date(NULL) end_date,
1695: to_char(NULL) period_name
1696: FROM dual) gl
1697: WHERE bl.budget_version_id = p_budget_version_id
1698: AND( (bl.start_date BETWEEN gl.start_date AND gl.end_date
1699: OR bl.end_date BETWEEN gl.start_date AND gl.end_date
1700: OR (gl.start_date > bl.start_date AND gl.end_date < bl.end_date))