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_REP_UTIL_SCREEN dependencies on PA_REP_UTIL_SCREEN

Line 1: PACKAGE BODY PA_REP_UTIL_SCREEN AS

1: PACKAGE BODY PA_REP_UTIL_SCREEN AS
2: /* $Header: PARRSCRB.pls 120.3.12010000.2 2009/05/29 12:53:00 nisinha ship $ */
3:
4:
5: /*

Line 26: delete from PA_REP_UTIL_SCREEN_TMP;

22: )
23: IS
24: BEGIN
25:
26: delete from PA_REP_UTIL_SCREEN_TMP;
27:
28:
29: /*
30: * BEGINNING of Case 1 for U2

Line 35: INSERT INTO PA_REP_UTIL_SCREEN_TMP (

31: * GE view
32: */
33: IF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeGe) THEN
34:
35: INSERT INTO PA_REP_UTIL_SCREEN_TMP (
36: Organization_id
37: , Person_id
38: , Resource_id
39: , Resource_Name

Line 102: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(

98: , Decode(summbal.amount_type_id
99: , 10, NVL(summbal.period_balance,0)
100: , 0)
101: , 0)))
102: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(
103: PA_REP_UTIL_GLOB.GetOrgId
104: , PA_REP_UTIL_GLOB.GetBalTypeActuals
105: , max(paobj.person_id)
106: , max(summbal.version_id)

Line 214: , PA_REP_UTIL_SCREEN.calculate_capacity(

210: , 0)
211: , 0))
212: , 1)
213: )
214: , PA_REP_UTIL_SCREEN.calculate_capacity(
215: PA_REP_UTIL_GLOB.GetOrgId
216: , PA_REP_UTIL_GLOB.GetBalTypeActuals
217: , max(paobj.person_id)
218: , max(summbal.version_id)

Line 287: , PA_REP_UTIL_SCREEN.calculate_capacity(

283: , 0)
284: , 0))
285: , 1)
286: )
287: , PA_REP_UTIL_SCREEN.calculate_capacity(
288: PA_REP_UTIL_GLOB.GetOrgId
289: , PA_REP_UTIL_GLOB.GetBalTypeActuals
290: , max(paobj.person_id)
291: , max(summbal.version_id)

Line 336: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(

332: , Decode(summbal.amount_type_id
333: , 10, NVL(summbal.period_balance,0)
334: , 0)
335: , 0)))
336: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(
337: PA_REP_UTIL_GLOB.GetOrgId
338: , PA_REP_UTIL_GLOB.GetBalTypeForecast
339: , max(paobj.person_id)
340: , max(summbal.version_id)

Line 547: , PA_REP_UTIL_SCREEN.calculate_capacity(

543: , 0)
544: , 0))
545: , 1)
546: )
547: , PA_REP_UTIL_SCREEN.calculate_capacity(
548: PA_REP_UTIL_GLOB.GetOrgId
549: , PA_REP_UTIL_GLOB.GetBalTypeForecast
550: , max(paobj.person_id)
551: , max(summbal.version_id)

Line 620: , PA_REP_UTIL_SCREEN.calculate_capacity(

616: , 0)
617: , 0))
618: , 1)
619: )
620: , PA_REP_UTIL_SCREEN.calculate_capacity(
621: PA_REP_UTIL_GLOB.GetOrgId
622: , PA_REP_UTIL_GLOB.GetBalTypeForecast
623: , max(paobj.person_id)
624: , max(summbal.version_id)

Line 722: INSERT INTO PA_REP_UTIL_SCREEN_TMP (

718: */
719: IF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeGl OR
720: p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypePa) THEN
721:
722: INSERT INTO PA_REP_UTIL_SCREEN_TMP (
723: Organization_id
724: , Person_id
725: , Resource_id
726: , Resource_Name

Line 789: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(

785: , Decode(summbal.amount_type_id
786: , 10, NVL(summbal.period_balance,0)
787: , 0)
788: , 0)))
789: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(
790: PA_REP_UTIL_GLOB.GetOrgId
791: , PA_REP_UTIL_GLOB.GetBalTypeActuals
792: , max(paobj.person_id)
793: , max(summbal.version_id)

Line 902: , PA_REP_UTIL_SCREEN.calculate_capacity(

898: , 0)
899: , 0))
900: , 1)
901: )
902: , PA_REP_UTIL_SCREEN.calculate_capacity(
903: PA_REP_UTIL_GLOB.GetOrgId
904: , PA_REP_UTIL_GLOB.GetBalTypeActuals
905: , max(paobj.person_id)
906: , max(summbal.version_id)

Line 975: , PA_REP_UTIL_SCREEN.calculate_capacity(

971: , 0)
972: , 0))
973: , 1)
974: )
975: , PA_REP_UTIL_SCREEN.calculate_capacity(
976: PA_REP_UTIL_GLOB.GetOrgId
977: , PA_REP_UTIL_GLOB.GetBalTypeActuals
978: , max(paobj.person_id)
979: , max(summbal.version_id)

Line 1024: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(

1020: , Decode(summbal.amount_type_id
1021: , 10, NVL(summbal.period_balance,0)
1022: , 0)
1023: , 0)))
1024: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(
1025: PA_REP_UTIL_GLOB.GetOrgId
1026: , PA_REP_UTIL_GLOB.GetBalTypeForecast
1027: , max(paobj.person_id)
1028: , max(summbal.version_id)

Line 1235: , PA_REP_UTIL_SCREEN.calculate_capacity(

1231: , 0)
1232: , 0))
1233: , 1)
1234: )
1235: , PA_REP_UTIL_SCREEN.calculate_capacity(
1236: PA_REP_UTIL_GLOB.GetOrgId
1237: , PA_REP_UTIL_GLOB.GetBalTypeForecast
1238: , max(paobj.person_id)
1239: , max(summbal.version_id)

Line 1308: , PA_REP_UTIL_SCREEN.calculate_capacity(

1304: , 0)
1305: , 0))
1306: , 1)
1307: )
1308: , PA_REP_UTIL_SCREEN.calculate_capacity(
1309: PA_REP_UTIL_GLOB.GetOrgId
1310: , PA_REP_UTIL_GLOB.GetBalTypeForecast
1311: , max(paobj.person_id)
1312: , max(summbal.version_id)

Line 1411: INSERT INTO PA_REP_UTIL_SCREEN_TMP (

1407: * QR view
1408: */
1409: IF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeQr) THEN
1410:
1411: INSERT INTO PA_REP_UTIL_SCREEN_TMP (
1412: Organization_id
1413: , Person_id
1414: , Resource_id
1415: , Resource_Name

Line 1478: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(

1474: , Decode(summbal.amount_type_id
1475: , 10, NVL(summbal.period_balance,0)
1476: , 0)
1477: , 0)))
1478: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(
1479: PA_REP_UTIL_GLOB.GetOrgId
1480: , PA_REP_UTIL_GLOB.GetBalTypeActuals
1481: , max(paobj.person_id)
1482: , max(summbal.version_id)

Line 1592: , PA_REP_UTIL_SCREEN.calculate_capacity(

1588: , 0)
1589: , 0))
1590: , 1)
1591: )
1592: , PA_REP_UTIL_SCREEN.calculate_capacity(
1593: PA_REP_UTIL_GLOB.GetOrgId
1594: , PA_REP_UTIL_GLOB.GetBalTypeActuals
1595: , max(paobj.person_id)
1596: , max(summbal.version_id)

Line 1668: , PA_REP_UTIL_SCREEN.calculate_capacity(

1664: , 0)
1665: , 0))
1666: , 1)
1667: )
1668: , PA_REP_UTIL_SCREEN.calculate_capacity(
1669: PA_REP_UTIL_GLOB.GetOrgId
1670: , PA_REP_UTIL_GLOB.GetBalTypeActuals
1671: , max(paobj.person_id)
1672: , max(summbal.version_id)

Line 1720: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(

1716: , Decode(summbal.amount_type_id
1717: , 10, NVL(summbal.period_balance,0)
1718: , 0)
1719: , 0)))
1720: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(
1721: PA_REP_UTIL_GLOB.GetOrgId
1722: , PA_REP_UTIL_GLOB.GetBalTypeForecast
1723: , max(paobj.person_id)
1724: , max(summbal.version_id)

Line 1933: , PA_REP_UTIL_SCREEN.calculate_capacity(

1929: , 0)
1930: , 0))
1931: , 1)
1932: )
1933: , PA_REP_UTIL_SCREEN.calculate_capacity(
1934: PA_REP_UTIL_GLOB.GetOrgId
1935: , PA_REP_UTIL_GLOB.GetBalTypeForecast
1936: , max(paobj.person_id)
1937: , max(summbal.version_id)

Line 2009: , PA_REP_UTIL_SCREEN.calculate_capacity(

2005: , 0)
2006: , 0))
2007: , 1)
2008: )
2009: , PA_REP_UTIL_SCREEN.calculate_capacity(
2010: PA_REP_UTIL_GLOB.GetOrgId
2011: , PA_REP_UTIL_GLOB.GetBalTypeForecast
2012: , max(paobj.person_id)
2013: , max(summbal.version_id)

Line 2117: INSERT INTO PA_REP_UTIL_SCREEN_TMP (

2113: * YR view
2114: */
2115: IF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeYr) THEN
2116:
2117: INSERT INTO PA_REP_UTIL_SCREEN_TMP (
2118: Organization_id
2119: , Person_id
2120: , Resource_id
2121: , Resource_Name

Line 2184: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(

2180: , Decode(summbal.amount_type_id
2181: , 10, NVL(summbal.period_balance,0)
2182: , 0)
2183: , 0)))
2184: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(
2185: PA_REP_UTIL_GLOB.GetOrgId
2186: , PA_REP_UTIL_GLOB.GetBalTypeActuals
2187: , max(paobj.person_id)
2188: , max(summbal.version_id)

Line 2297: , PA_REP_UTIL_SCREEN.calculate_capacity(

2293: , 0)
2294: , 0))
2295: , 1)
2296: )
2297: , PA_REP_UTIL_SCREEN.calculate_capacity(
2298: PA_REP_UTIL_GLOB.GetOrgId
2299: , PA_REP_UTIL_GLOB.GetBalTypeActuals
2300: , max(paobj.person_id)
2301: , max(summbal.version_id) /*8528649 changes for actuals_weighted_hours_p*/

Line 2372: , PA_REP_UTIL_SCREEN.calculate_capacity(

2368: , 0)
2369: , 0))
2370: , 1)
2371: )
2372: , PA_REP_UTIL_SCREEN.calculate_capacity(
2373: PA_REP_UTIL_GLOB.GetOrgId
2374: , PA_REP_UTIL_GLOB.GetBalTypeActuals
2375: , max(paobj.person_id)
2376: , max(summbal.version_id) /*8528649 changes for ACTUALS_CAP_OR_TOT_HRS*/

Line 2423: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(

2419: , Decode(summbal.amount_type_id
2420: , 10, NVL(summbal.period_balance,0)
2421: , 0)
2422: , 0)))
2423: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(
2424: PA_REP_UTIL_GLOB.GetOrgId
2425: , PA_REP_UTIL_GLOB.GetBalTypeForecast
2426: , max(paobj.person_id)
2427: , max(summbal.version_id)

Line 2635: , PA_REP_UTIL_SCREEN.calculate_capacity(

2631: , 0)
2632: , 0))
2633: , 1)
2634: )
2635: , PA_REP_UTIL_SCREEN.calculate_capacity(
2636: PA_REP_UTIL_GLOB.GetOrgId
2637: , PA_REP_UTIL_GLOB.GetBalTypeForecast
2638: , max(paobj.person_id)
2639: , max(summbal.version_id) /*8528649 changes for FORECAST_WEIGHTED_HOURS_P*/

Line 2710: , PA_REP_UTIL_SCREEN.calculate_capacity(

2706: , 0)
2707: , 0))
2708: , 1)
2709: )
2710: , PA_REP_UTIL_SCREEN.calculate_capacity(
2711: PA_REP_UTIL_GLOB.GetOrgId
2712: , PA_REP_UTIL_GLOB.GetBalTypeForecast
2713: , max(paobj.person_id)
2714: , max(summbal.version_id) /*8528649 changes for forecast_cap_or_tot_hrs*/

Line 2822: Update PA_REP_UTIL_SCREEN_TMP tmp

2818: * of EMPLOYEE for all the records now check against pa_resources_denorm
2819: * to update the resource_type_code to MANAGERS appropriately.
2820: */
2821:
2822: Update PA_REP_UTIL_SCREEN_TMP tmp
2823: Set (resource_type,resource_type_code) = (select lkup2.meaning,lkup2.lookup_code
2824: from pa_lookups lkup2
2825: where lkup2.lookup_type='PERSON_TYPE'
2826: and lkup2.lookup_code = 'MANAGER')

Line 2836: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_REP_UTIL_SCREEN.poplt_screen_tmp_table'

2832:
2833: EXCEPTION
2834:
2835: WHEN OTHERS THEN
2836: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_REP_UTIL_SCREEN.poplt_screen_tmp_table'
2837: , p_procedure_name => PA_DEBUG.G_Err_Stack);
2838: RAISE;
2839:
2840:

Line 3295: END PA_REP_UTIL_SCREEN;

3291: );
3292: */
3293: COMMIT;
3294: END poplt_u1_screen_tmp_table;
3295: END PA_REP_UTIL_SCREEN;