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 242: ,pa_implementations imp --NPE changes

238: from pa_utilization_options ut ;
239:
240: /*Bug2440313 -- Commented this, the check for pa_implementaions is being done
241: above in the code
242: ,pa_implementations imp --NPE changes
243: where nvl(ut.org_id, -99) = nvl(imp.org_id,-99); --NPE changes
244: */
245:
246: IF (l_forecast_thru_date > sysdate

Line 320: pa_implementations imp,

316: paperiod.period_year,
317: paperiod.status_meaning
318: INTO l_prd_name,l_prd_yr,l_meaning
319: FROM pa_periods_v paperiod,
320: pa_implementations imp,
321: gl_period_statuses glpersts
322: WHERE glpersts.period_type = imp.pa_period_type
323: AND imp.set_of_books_id = paperiod.set_of_books_id
324: AND glpersts.set_of_books_id = imp.set_of_books_id

Line 371: FROM pa_implementations imp,

367: BEGIN -- NPE Changes
368:
369: SELECT glper.period_name,glper.period_year,gllkups.meaning
370: INTO l_prd_name,l_prd_yr,l_meaning
371: FROM pa_implementations imp,
372: gl_sets_of_books gl,
373: gl_periods glper,
374: gl_period_statuses glst,
375: gl_lookups gllkups

Line 483: FROM pa_implementations imp,

479: x_def_period_name_desc := NULL;
480: ELSIF ( l_period_type = 'QR') THEN
481: SELECT glper.quarter_num
482: INTO l_quarter_num
483: FROM pa_implementations imp,
484: gl_sets_of_books gl,
485: gl_periods glper,
486: gl_period_statuses glst
487: WHERE imp.set_of_books_id = gl.set_of_books_id

Line 977: FROM pa_implementations imp,

973: x_msg_count OUT NOCOPY NUMBER,
974: x_msg_data OUT NOCOPY VARCHAR2) IS
975:
976: /* CURSOR C1 IS SELECT glper.period_name,glper.period_year,glst.closing_status,glper.quarter_num,glst.effective_period_num
977: FROM pa_implementations imp,
978: gl_sets_of_books gl,
979: gl_periods glper,
980: gl_period_statuses glst
981: WHERE imp.set_of_books_id = gl.set_of_books_id

Line 999: pa_implementations imp,

995: paperiod.quarter_num,
996: glpersts.effective_period_num,
997: paperiod.status_meaning
998: FROM pa_periods_v paperiod,
999: pa_implementations imp,
1000: gl_period_statuses glpersts
1001: WHERE glpersts.period_type = imp.pa_period_type
1002: AND imp.set_of_books_id = paperiod.set_of_books_id
1003: AND glpersts.set_of_books_id = imp.set_of_books_id

Line 1017: FROM pa_implementations imp,

1013: ,glst.closing_status
1014: ,glper.quarter_num
1015: ,glst.effective_period_num
1016: ,gllkups.meaning
1017: FROM pa_implementations imp,
1018: gl_sets_of_books gl,
1019: gl_periods glper,
1020: gl_period_statuses glst,
1021: gl_lookups gllkups

Line 1090: from pa_implementations;

1086:
1087: /* Bug2440313 Begin */
1088: BEGIN
1089: select 'x' into dummy
1090: from pa_implementations;
1091: EXCEPTION
1092: WHEN NO_DATA_FOUND THEN
1093: x_return_status := FND_API.G_RET_STS_ERROR;
1094: PA_UTILS.Add_Message( p_app_short_name =>'PA',

Line 1197: ,pa_implementations imp --NPE changes

1193: from pa_utilization_options ut;
1194:
1195: /*Bug2440313 -- Commented this, the check for pa_implementaions is being done
1196: above in the code
1197: ,pa_implementations imp --NPE changes
1198: where nvl(ut.org_id, -99) = nvl(imp.org_id,-99); --NPE changes
1199: */
1200:
1201: IF (l_forecast_thru_date > sysdate

Line 1271: pa_implementations imp,

1267: glpersts.effective_period_num,
1268: paperiod.status_meaning
1269: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1270: FROM pa_periods_v paperiod,
1271: pa_implementations imp,
1272: gl_period_statuses glpersts
1273: WHERE glpersts.period_type = imp.pa_period_type
1274: AND imp.set_of_books_id = paperiod.set_of_books_id
1275: AND glpersts.set_of_books_id = imp.set_of_books_id

Line 1329: FROM pa_implementations imp,

1325: ,glper.quarter_num
1326: ,glst.effective_period_num
1327: ,gllkups.meaning
1328: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1329: FROM pa_implementations imp,
1330: gl_sets_of_books gl,
1331: gl_periods glper,
1332: gl_period_statuses glst,
1333: gl_lookups gllkups

Line 1459: pa_implementations imp,

1455: glpersts.effective_period_num,
1456: paperiod.status_meaning
1457: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1458: FROM pa_periods_v paperiod,
1459: pa_implementations imp,
1460: gl_period_statuses glpersts
1461: WHERE glpersts.period_type = imp.pa_period_type
1462: AND imp.set_of_books_id = paperiod.set_of_books_id
1463: AND glpersts.set_of_books_id = imp.set_of_books_id

Line 1488: FROM pa_implementations imp,

1484: ,glper.quarter_num
1485: ,glst.effective_period_num
1486: ,gllkups.meaning
1487: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1488: FROM pa_implementations imp,
1489: gl_sets_of_books gl,
1490: gl_periods glper,
1491: gl_period_statuses glst,
1492: gl_lookups gllkups