DBA Data[Home] [Help]

APPS.PA_DATE_RANGE_PKG dependencies on GL_SETS_OF_BOOKS

Line 49: gl_sets_of_books sob

45: --Bug 4919018. SQL Repository Performance Activity
46: cursor ftch_period_details_csr(c_org_id pa_projects_all.org_id%type) is
47: select pi.pa_period_type,sob.accounted_period_type, sob.period_set_name from
48: pa_implementations_all pi,
49: gl_sets_of_books sob
50: where nvl(pi.org_id,-99) = c_org_id
51: and sob.set_of_books_id = pi.set_of_books_id;
52:
53: --Bug 4176129. Removed the UNION clause as at any point only one of the 2 SQLs would get executed

Line 56: c_period_set_name gl_sets_of_books.period_set_name%type) is

52:
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 */

Line 82: c_period_set_name gl_sets_of_books.period_set_name%type) is

78: having count(*) > 1);
79:
80: --Bug 4176129
81: cursor get_per_type_csr(c_org_id pa_projects_all.org_id%type,
82: c_period_set_name gl_sets_of_books.period_set_name%type) is
83: select pi.pa_period_type,sob.accounted_period_type
84: from pa_implementations_all pi,
85: gl_sets_of_books sob
86: where nvl(pi.org_id,-99) = c_org_id

Line 85: gl_sets_of_books sob

81: cursor get_per_type_csr(c_org_id pa_projects_all.org_id%type,
82: c_period_set_name gl_sets_of_books.period_set_name%type) is
83: select pi.pa_period_type,sob.accounted_period_type
84: from pa_implementations_all pi,
85: gl_sets_of_books sob
86: where nvl(pi.org_id,-99) = c_org_id
87: and sob.set_of_books_id = pi.set_of_books_id
88: and exists
89: (select 1

Line 101: ,c_period_set_name gl_sets_of_books.period_set_name%type) is

97:
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

Line 157: ,l_org_id pa_projects_all.org_id%type,l_per_type pa_implementations_all.pa_period_type%type,l_period_set_name gl_sets_of_books.period_set_name%type) is

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
156: cursor get_budget_lines_csr(l_budget_version_id pa_budget_lines.budget_version_id%type,l_res_assign_id pa_resource_assignments.resource_assignment_id%type
157: ,l_org_id pa_projects_all.org_id%type,l_per_type pa_implementations_all.pa_period_type%type,l_period_set_name gl_sets_of_books.period_set_name%type) is
158: select
159: rs.resource_assignment_id resource_assignment_id,
160: rs.txn_currency_code txn_currency_code,
161: rs.gl_start_date gl_start_date,

Line 318: l_sob_accounted_period_type gl_sets_of_books.accounted_period_type%type;

314: l_txn_curr_index pa_fp_txn_currencies.txn_currency_code%TYPE;
315: l_last_bl_index NUMBER;
316: --Bug 4919018
317: l_pi_pa_period_type pa_implementations_all.pa_period_type%type;
318: l_sob_accounted_period_type gl_sets_of_books.accounted_period_type%type;
319: l_sob_period_set_name gl_sets_of_books.period_set_name%type;
320:
321:
322:

Line 319: l_sob_period_set_name gl_sets_of_books.period_set_name%type;

315: l_last_bl_index NUMBER;
316: --Bug 4919018
317: l_pi_pa_period_type pa_implementations_all.pa_period_type%type;
318: l_sob_accounted_period_type gl_sets_of_books.accounted_period_type%type;
319: l_sob_period_set_name gl_sets_of_books.period_set_name%type;
320:
321:
322:
323:

Line 1662: ,p_gl_period_type IN gl_sets_of_books.accounted_period_type%TYPE

1658: --in this API and the calling APIs should take care of passing correct values.
1659: FUNCTION get_time_phase_mode
1660: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
1661: ,p_pa_period_type IN pa_implementations_all.pa_period_type%TYPE
1662: ,p_gl_period_type IN gl_sets_of_books.accounted_period_type%TYPE
1663: ,p_org_id IN pa_projects_all.org_id%TYPE) RETURN VARCHAR2
1664: IS
1665: --Bug 4174789. In the expression to derive factor, replaced the division with substraction to nullify
1666: --errors because of infinite digits after decimal point

Line 1686: FROM gl_periods gl, pa_implementations_all pi, gl_sets_of_books sob

1682: FROM pa_budget_lines bl,
1683: (SELECT gl.start_date start_date,
1684: gl.end_date end_date,
1685: gl.period_name period_name
1686: FROM gl_periods gl, pa_implementations_all pi, gl_sets_of_books sob
1687: WHERE gl.period_type=c_period_type
1688: AND sob.set_of_books_id=pi.set_of_books_id
1689: AND nvl(pi.org_id,-99)=nvl(p_org_id,-99)
1690: AND gl.adjustment_period_flag='N'