eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_DATE_RANGE_PKG dependencies on PA_IMPLEMENTATIONS_ALL

Line 48: pa_implementations_all pi,

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

Line 84: from pa_implementations_all pi,

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
87: and sob.set_of_books_id = pi.set_of_books_id
88: and exists

Line 99: cursor chk_pa_gl_per_exists_csr(c_period_type pa_implementations_all.pa_period_type%type

95: -- Begin Bug 3890562, 17-SEP-2004, jwhite ---------------------------------
96: -- Make query similar to get_budget_lines_csr, which explodes date-range into PA/GL periodic data.
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'

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 252: l_pa_period_type pa_implementations_all.pa_period_type%type;

248: l_pa_per_exists varchar2(1) := 'N';
249: l_gl_per_exists varchar2(1) := 'N';
250: l_budget_version_id pa_budget_versions.budget_version_id%type;
251: l_time_phased_mode varchar2(1) := null;
252: l_pa_period_type pa_implementations_all.pa_period_type%type;
253: l_per_type pa_implementations_all.pa_period_type%type;
254: l_accounted_per_type pa_implementations_all.pa_period_type%type;
255: l_min_date date;
256: g_upgrade_mode varchar2(100);

Line 253: l_per_type pa_implementations_all.pa_period_type%type;

249: l_gl_per_exists varchar2(1) := 'N';
250: l_budget_version_id pa_budget_versions.budget_version_id%type;
251: l_time_phased_mode varchar2(1) := null;
252: l_pa_period_type pa_implementations_all.pa_period_type%type;
253: l_per_type pa_implementations_all.pa_period_type%type;
254: l_accounted_per_type pa_implementations_all.pa_period_type%type;
255: l_min_date date;
256: g_upgrade_mode varchar2(100);
257: l_counter number := 0;

Line 254: l_accounted_per_type pa_implementations_all.pa_period_type%type;

250: l_budget_version_id pa_budget_versions.budget_version_id%type;
251: l_time_phased_mode varchar2(1) := null;
252: l_pa_period_type pa_implementations_all.pa_period_type%type;
253: l_per_type pa_implementations_all.pa_period_type%type;
254: l_accounted_per_type pa_implementations_all.pa_period_type%type;
255: l_min_date date;
256: g_upgrade_mode varchar2(100);
257: l_counter number := 0;
258: l_attribute_category pa_budget_lines.attribute_category%type;

Line 317: l_pi_pa_period_type pa_implementations_all.pa_period_type%type;

313: l_max_st_dt_in_plan_txn_tbl varchar2_indexed_date_tbl_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:

Line 1661: ,p_pa_period_type IN pa_implementations_all.pa_period_type%TYPE

1657: --This function will be called from the upgrade script paupg102.sql and PADTRNGB.DATE_RANGE_UPGRD.No validations are done
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

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'