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_REPORT_UTIL dependencies on PA_IMPLEMENTATIONS

Line 79: from pa_implementations;

75:
76: /* Bug2440313 Begin */
77: BEGIN
78: select 'x' into dummy
79: from pa_implementations;
80: EXCEPTION
81: WHEN NO_DATA_FOUND THEN
82: x_return_status := FND_API.G_RET_STS_ERROR;
83: PA_UTILS.Add_Message( p_app_short_name =>'PA',

Line 265: ,pa_implementations imp --NPE changes

261: from pa_utilization_options ut ;
262:
263: /*Bug2440313 -- Commented this, the check for pa_implementaions is being done
264: above in the code
265: ,pa_implementations imp --NPE changes
266: where nvl(ut.org_id, -99) = nvl(imp.org_id,-99); --NPE changes
267: */
268:
269: IF (l_forecast_thru_date > sysdate

Line 344: pa_implementations imp,

340: paperiod.period_year,
341: paperiod.status_meaning
342: INTO l_prd_name,l_prd_yr,l_meaning
343: FROM pa_periods_v paperiod,
344: pa_implementations imp,
345: gl_period_statuses glpersts
346: WHERE glpersts.period_type = imp.pa_period_type
347: AND imp.set_of_books_id = paperiod.set_of_books_id
348: AND glpersts.set_of_books_id = imp.set_of_books_id

Line 404: FROM pa_implementations imp,

400: BEGIN -- NPE Changes
401:
402: SELECT glper.period_name,glper.period_year,gllkups.meaning
403: INTO l_prd_name,l_prd_yr,l_meaning
404: FROM pa_implementations imp,
405: gl_sets_of_books gl,
406: gl_periods glper,
407: gl_period_statuses glst,
408: gl_lookups gllkups

Line 516: FROM pa_implementations imp,

512: x_def_period_name_desc := NULL;
513: ELSIF ( l_period_type = 'QR') THEN
514: SELECT glper.quarter_num
515: INTO l_quarter_num
516: FROM pa_implementations imp,
517: gl_sets_of_books gl,
518: gl_periods glper,
519: gl_period_statuses glst
520: WHERE imp.set_of_books_id = gl.set_of_books_id

Line 1010: FROM pa_implementations imp,

1006: x_msg_count OUT NOCOPY NUMBER,
1007: x_msg_data OUT NOCOPY VARCHAR2) IS
1008:
1009: /* CURSOR C1 IS SELECT glper.period_name,glper.period_year,glst.closing_status,glper.quarter_num,glst.effective_period_num
1010: FROM pa_implementations imp,
1011: gl_sets_of_books gl,
1012: gl_periods glper,
1013: gl_period_statuses glst
1014: WHERE imp.set_of_books_id = gl.set_of_books_id

Line 1035: pa_implementations imp,

1031: paperiod.quarter_num,
1032: glpersts.effective_period_num,
1033: paperiod.status_meaning
1034: FROM pa_periods_v paperiod,
1035: pa_implementations imp,
1036: gl_period_statuses glpersts
1037: WHERE glpersts.period_type = imp.pa_period_type
1038: AND imp.set_of_books_id = paperiod.set_of_books_id
1039: AND glpersts.set_of_books_id = imp.set_of_books_id

Line 1053: FROM pa_implementations imp,

1049: ,glst.closing_status
1050: ,glper.quarter_num
1051: ,glst.effective_period_num
1052: ,gllkups.meaning
1053: FROM pa_implementations imp,
1054: gl_sets_of_books gl,
1055: gl_periods glper,
1056: gl_period_statuses glst,
1057: gl_lookups gllkups

Line 1126: from pa_implementations;

1122:
1123: /* Bug2440313 Begin */
1124: BEGIN
1125: select 'x' into dummy
1126: from pa_implementations;
1127: EXCEPTION
1128: WHEN NO_DATA_FOUND THEN
1129: x_return_status := FND_API.G_RET_STS_ERROR;
1130: PA_UTILS.Add_Message( p_app_short_name =>'PA',

Line 1233: ,pa_implementations imp --NPE changes

1229: from pa_utilization_options ut;
1230:
1231: /*Bug2440313 -- Commented this, the check for pa_implementaions is being done
1232: above in the code
1233: ,pa_implementations imp --NPE changes
1234: where nvl(ut.org_id, -99) = nvl(imp.org_id,-99); --NPE changes
1235: */
1236:
1237: IF (l_forecast_thru_date > sysdate

Line 1308: pa_implementations imp,

1304: glpersts.effective_period_num,
1305: paperiod.status_meaning
1306: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1307: FROM pa_periods_v paperiod,
1308: pa_implementations imp,
1309: gl_period_statuses glpersts
1310: WHERE glpersts.period_type = imp.pa_period_type
1311: AND imp.set_of_books_id = paperiod.set_of_books_id
1312: AND glpersts.set_of_books_id = imp.set_of_books_id

Line 1377: FROM pa_implementations imp,

1373: ,glper.quarter_num
1374: ,glst.effective_period_num
1375: ,gllkups.meaning
1376: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1377: FROM pa_implementations imp,
1378: gl_sets_of_books gl,
1379: gl_periods glper,
1380: gl_period_statuses glst,
1381: gl_lookups gllkups

Line 1509: pa_implementations imp,

1505: glpersts.effective_period_num,
1506: paperiod.status_meaning
1507: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1508: FROM pa_periods_v paperiod,
1509: pa_implementations imp,
1510: gl_period_statuses glpersts
1511: WHERE glpersts.period_type = imp.pa_period_type
1512: AND imp.set_of_books_id = paperiod.set_of_books_id
1513: AND glpersts.set_of_books_id = imp.set_of_books_id

Line 1551: FROM pa_implementations imp,

1547: ,glper.quarter_num
1548: ,glst.effective_period_num
1549: ,gllkups.meaning
1550: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1551: FROM pa_implementations imp,
1552: gl_sets_of_books gl,
1553: gl_periods glper,
1554: gl_period_statuses glst,
1555: gl_lookups gllkups