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_ACCUM_UTILS dependencies on PA_PERIODS

Line 234: FROM pa_periods_v

230: x_current_pa_end_date,
231: x_current_gl_start_date,
232: x_current_gl_end_date,
233: x_current_year
234: FROM pa_periods_v
235: WHERE
236: current_pa_period_flag = 'Y';
237: */
238:

Line 239: /* Replaced the query from pa_periods_v with the view definition Bug #2634995*/

235: WHERE
236: current_pa_period_flag = 'Y';
237: */
238:
239: /* Replaced the query from pa_periods_v with the view definition Bug #2634995*/
240: SELECT pap.period_name,
241: pap.gl_period_name,
242: pap.start_date,
243: pap.end_date,

Line 255: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,

251: x_current_pa_end_date,
252: x_current_gl_start_date,
253: x_current_gl_end_date,
254: x_current_year
255: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,
256: PA_IMPLEMENTATIONS PAIMP, PA_LOOKUPS PAL
257: WHERE PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
258: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
259: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id

Line 339: PA_PERIODS_V

335: x_prev_pa_year,
336: x_prev_pa_start_date,
337: x_prev_pa_end_date
338: FROM
339: PA_PERIODS_V
340: WHERE pa_start_date =
341: (SELECT max(start_date)
342: FROM
343: pa_periods

Line 343: pa_periods

339: PA_PERIODS_V
340: WHERE pa_start_date =
341: (SELECT max(start_date)
342: FROM
343: pa_periods
344: WHERE start_date < x_current_pa_start_date);
345:
346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN

Line 375: pa_periods_v

371: x_prev_gl_year,
372: x_prev_gl_start_date,
373: x_prev_gl_end_date
374: FROM
375: pa_periods_v
376: WHERE
377: gl_start_date =
378: (SELECT max(gl_start_date)
379: FROM pa_periods_v

Line 379: FROM pa_periods_v

375: pa_periods_v
376: WHERE
377: gl_start_date =
378: (SELECT max(gl_start_date)
379: FROM pa_periods_v
380: WHERE
381: gl_start_date < x_current_gl_start_date);
382:
383: EXCEPTION

Line 405: PA_PERIODS_V WHERE Period_name = x_prev_accum_period;

401: If x_impl_opt = 'PA' Then
402: Select PERIOD_YEAR,PA_START_DATE,PA_END_DATE
403: into x_prev_accum_year,x_prev_accum_start_date,
404: x_prev_accum_end_date from
405: PA_PERIODS_V WHERE Period_name = x_prev_accum_period;
406: Elsif
407: x_impl_opt = 'GL' Then
408: Select Distinct PERIOD_YEAR,GL_START_DATE,GL_END_DATE
409: into x_prev_accum_year,x_prev_accum_start_date,

Line 411: PA_PERIODS_V WHERE Gl_Period_name = x_prev_accum_period;

407: x_impl_opt = 'GL' Then
408: Select Distinct PERIOD_YEAR,GL_START_DATE,GL_END_DATE
409: into x_prev_accum_year,x_prev_accum_start_date,
410: x_prev_accum_end_date from
411: PA_PERIODS_V WHERE Gl_Period_name = x_prev_accum_period;
412: End If;
413:
414: EXCEPTION
415: WHEN NO_DATA_FOUND THEN

Line 430: pa_periods_v

426: SELECT DISTINCT
427: DECODE(x_impl_opt,'PA',PERIOD_NAME,'GL',GL_PERIOD_NAME,PERIOD_NAME)
428: INTO x_prev_prev_accum_period
429: FROM
430: pa_periods_v
431: WHERE
432: DECODE(x_impl_opt,
433: 'PA',pa_start_date,'GL',gl_start_date,pa_start_date) =
434: (SELECT max(DECODE(

Line 437: FROM pa_periods_v

433: 'PA',pa_start_date,'GL',gl_start_date,pa_start_date) =
434: (SELECT max(DECODE(
435: x_impl_opt,'PA',pa_start_date,
436: 'GL',gl_start_date,pa_start_date))
437: FROM pa_periods_v
438: WHERE
439: DECODE(x_impl_opt,
440: 'PA',pa_start_date,'GL',gl_start_date,pa_start_date)
441: < x_prev_accum_start_date);

Line 1220: -- 2) decomposed pa_periods_v; removed pa_lookup

1216: -- 01-FEB-01 jwhite Bug 1614284: Performance Fix for
1217: -- CURSOR selresaccums:
1218: -- 1) Added the following join
1219: -- AND PRAD.PROJECT_ID = PTA.PROJECT_ID
1220: -- 2) decomposed pa_periods_v; removed pa_lookup
1221: -- join.
1222: -- 24-JUL-02 rravipat Bug 2331201: Extended the procedure to use it for
1223: -- Financial Planning.Included fnctionality forthe case
1224: -- x_amount_type = 'A' which corresponds to a finplan

Line 1256: , PA_PERIODS PAP

1252: ,PTA.TOT_QUANTITY tot_quantity
1253: ,PTA.TOT_REVENUE tot_revenue
1254: FROM PA_TXN_ACCUM PTA
1255: , PA_RESOURCE_ACCUM_DETAILS PRAD
1256: , PA_PERIODS PAP
1257: , GL_PERIOD_STATUSES GLP
1258: , PA_IMPLEMENTATIONS PAIMP
1259: WHERE PRAD.PROJECT_ID = x_project_id
1260: AND PRAD.RESOURCE_LIST_ID = x_resource_list_id

Line 1304: , PA_PERIODS PAP

1300: ,PTA.TOT_QUANTITY tot_quantity
1301: ,PTA.TOT_REVENUE tot_revenue
1302: FROM PA_TXN_ACCUM PTA
1303: , PA_RESOURCE_ACCUM_DETAILS PRAD
1304: , PA_PERIODS PAP
1305: , GL_PERIOD_STATUSES GLP
1306: , PA_IMPLEMENTATIONS PAIMP
1307: WHERE PRAD.PROJECT_ID = x_project_id
1308: AND PRAD.RESOURCE_LIST_ID = x_resource_list_id

Line 1444: from PA_PERIODS_V pav, pa_implementations pai

1440: -- Return the end date of the passed period and set the global variable
1441: select decode( pai.accumulation_period_type, 'PA', pav.pa_end_date,
1442: 'GL', pav.gl_end_date )
1443: into lcl_end_date
1444: from PA_PERIODS_V pav, pa_implementations pai
1445: where period_name = x_period_name;
1446:
1447: pa_accum_utils.g_check_reporting_end_date := lcl_end_date;
1448:

Line 1462: --Replaced the pa_periods_v with the view definition

1458: -- return the current reporting period
1459: IF pa_accum_utils.g_check_reporting_end_date is null
1460: THEN
1461: /* Bug 2634995 begins */
1462: --Replaced the pa_periods_v with the view definition
1463: -- select decode( pai.accumulation_period_type, 'PA', pav.pa_end_date,
1464: -- 'GL', pav.gl_end_date )
1465: -- into lcl_end_date
1466: -- from PA_PERIODS_V pav, pa_implementations pai

Line 1466: -- from PA_PERIODS_V pav, pa_implementations pai

1462: --Replaced the pa_periods_v with the view definition
1463: -- select decode( pai.accumulation_period_type, 'PA', pav.pa_end_date,
1464: -- 'GL', pav.gl_end_date )
1465: -- into lcl_end_date
1466: -- from PA_PERIODS_V pav, pa_implementations pai
1467: -- where current_pa_period_flag = 'Y';
1468: select decode(paimp.accumulation_period_type, 'PA', pap.end_date,
1469: 'GL', glp.end_date)
1470: into lcl_end_date

Line 1471: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,

1467: -- where current_pa_period_flag = 'Y';
1468: select decode(paimp.accumulation_period_type, 'PA', pap.end_date,
1469: 'GL', glp.end_date)
1470: into lcl_end_date
1471: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,
1472: PA_IMPLEMENTATIONS PAIMP, PA_LOOKUPS PAL
1473: WHERE PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
1474: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
1475: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id

Line 1504: FROM pa_periods

1500: gl_period_name
1501: INTO
1502: g_current_pa_period,
1503: g_current_gl_period
1504: FROM pa_periods
1505: WHERE
1506: current_pa_period_flag = 'Y';
1507:
1508: Exception

Line 1536: FROM pa_periods

1532: SELECT
1533: period_name
1534: INTO
1535: l_current_pa_period
1536: FROM pa_periods
1537: WHERE
1538: current_pa_period_flag = 'Y';
1539: ELSE
1540: l_current_pa_period := pa_accum_utils.g_current_pa_period;

Line 1567: FROM pa_periods

1563: SELECT
1564: gl_period_name
1565: INTO
1566: l_current_gl_period
1567: FROM pa_periods
1568: WHERE
1569: current_pa_period_flag = 'Y';
1570: ELSE
1571: l_current_gl_period := pa_accum_utils.g_current_gl_period;

Line 1796: PA_PERIODS_V

1792: x_prev_pa_year,
1793: x_prev_pa_start_date,
1794: x_prev_pa_end_date
1795: FROM
1796: PA_PERIODS_V
1797: WHERE pa_start_date =
1798: (SELECT max(start_date)
1799: FROM
1800: pa_periods

Line 1800: pa_periods

1796: PA_PERIODS_V
1797: WHERE pa_start_date =
1798: (SELECT max(start_date)
1799: FROM
1800: pa_periods
1801: WHERE start_date < x_current_pa_start_date);
1802:
1803: EXCEPTION
1804: WHEN NO_DATA_FOUND THEN

Line 1832: pa_periods_v

1828: x_prev_gl_year,
1829: x_prev_gl_start_date,
1830: x_prev_gl_end_date
1831: FROM
1832: pa_periods_v
1833: WHERE
1834: gl_start_date =
1835: (SELECT max(gl_start_date)
1836: FROM pa_periods_v

Line 1836: FROM pa_periods_v

1832: pa_periods_v
1833: WHERE
1834: gl_start_date =
1835: (SELECT max(gl_start_date)
1836: FROM pa_periods_v
1837: WHERE
1838: gl_start_date < x_current_gl_start_date);
1839:
1840: EXCEPTION

Line 1890: PA_PERIODS_V WHERE Period_name = x_prev_accum_period;

1886: If x_impl_opt = 'PA' Then
1887: Select PERIOD_YEAR,PA_START_DATE,PA_END_DATE
1888: into x_prev_accum_year,x_prev_accum_start_date,
1889: x_prev_accum_end_date from
1890: PA_PERIODS_V WHERE Period_name = x_prev_accum_period;
1891: Elsif
1892: x_impl_opt = 'GL' Then
1893: Select Distinct PERIOD_YEAR,GL_START_DATE,GL_END_DATE
1894: into x_prev_accum_year,x_prev_accum_start_date,

Line 1896: PA_PERIODS_V WHERE Gl_Period_name = x_prev_accum_period;

1892: x_impl_opt = 'GL' Then
1893: Select Distinct PERIOD_YEAR,GL_START_DATE,GL_END_DATE
1894: into x_prev_accum_year,x_prev_accum_start_date,
1895: x_prev_accum_end_date from
1896: PA_PERIODS_V WHERE Gl_Period_name = x_prev_accum_period;
1897: End If;
1898:
1899: EXCEPTION
1900: WHEN NO_DATA_FOUND THEN

Line 1915: pa_periods_v

1911: If x_impl_opt = 'PA' Then
1912: SELECT DISTINCT PERIOD_NAME
1913: INTO x_prev_prev_accum_period
1914: FROM
1915: pa_periods_v
1916: WHERE
1917: pa_start_date =
1918: (SELECT max(pa_start_date)
1919: FROM pa_periods_v

Line 1919: FROM pa_periods_v

1915: pa_periods_v
1916: WHERE
1917: pa_start_date =
1918: (SELECT max(pa_start_date)
1919: FROM pa_periods_v
1920: WHERE pa_start_date < x_prev_accum_start_date);
1921: Elsif
1922: x_impl_opt = 'GL' Then
1923: SELECT DISTINCT GL_PERIOD_NAME

Line 1926: pa_periods_v

1922: x_impl_opt = 'GL' Then
1923: SELECT DISTINCT GL_PERIOD_NAME
1924: INTO x_prev_prev_accum_period
1925: FROM
1926: pa_periods_v
1927: WHERE gl_start_date =
1928: (SELECT max(gl_start_date)
1929: FROM pa_periods_v
1930: WHERE gl_start_date < x_prev_accum_start_date);

Line 1929: FROM pa_periods_v

1925: FROM
1926: pa_periods_v
1927: WHERE gl_start_date =
1928: (SELECT max(gl_start_date)
1929: FROM pa_periods_v
1930: WHERE gl_start_date < x_prev_accum_start_date);
1931: End If;
1932:
1933: EXCEPTION