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 2007/02/06 09:56:44 dthakker 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 1665: , PA_REP_UTIL_SCREEN.calculate_capacity(

1661: , 0)
1662: , 0))
1663: , 1)
1664: )
1665: , PA_REP_UTIL_SCREEN.calculate_capacity(
1666: PA_REP_UTIL_GLOB.GetOrgId
1667: , PA_REP_UTIL_GLOB.GetBalTypeActuals
1668: , max(paobj.person_id)
1669: , max(summbal.version_id)

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

1710: , Decode(summbal.amount_type_id
1711: , 10, NVL(summbal.period_balance,0)
1712: , 0)
1713: , 0)))
1714: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(
1715: PA_REP_UTIL_GLOB.GetOrgId
1716: , PA_REP_UTIL_GLOB.GetBalTypeForecast
1717: , max(paobj.person_id)
1718: , max(summbal.version_id)

Line 1927: , PA_REP_UTIL_SCREEN.calculate_capacity(

1923: , 0)
1924: , 0))
1925: , 1)
1926: )
1927: , PA_REP_UTIL_SCREEN.calculate_capacity(
1928: PA_REP_UTIL_GLOB.GetOrgId
1929: , PA_REP_UTIL_GLOB.GetBalTypeForecast
1930: , max(paobj.person_id)
1931: , max(summbal.version_id)

Line 2000: , PA_REP_UTIL_SCREEN.calculate_capacity(

1996: , 0)
1997: , 0))
1998: , 1)
1999: )
2000: , PA_REP_UTIL_SCREEN.calculate_capacity(
2001: PA_REP_UTIL_GLOB.GetOrgId
2002: , PA_REP_UTIL_GLOB.GetBalTypeForecast
2003: , max(paobj.person_id)
2004: , max(summbal.version_id)

Line 2104: INSERT INTO PA_REP_UTIL_SCREEN_TMP (

2100: * YR view
2101: */
2102: IF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeYr) THEN
2103:
2104: INSERT INTO PA_REP_UTIL_SCREEN_TMP (
2105: Organization_id
2106: , Person_id
2107: , Resource_id
2108: , Resource_Name

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

2167: , Decode(summbal.amount_type_id
2168: , 10, NVL(summbal.period_balance,0)
2169: , 0)
2170: , 0)))
2171: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(
2172: PA_REP_UTIL_GLOB.GetOrgId
2173: , PA_REP_UTIL_GLOB.GetBalTypeActuals
2174: , max(paobj.person_id)
2175: , max(summbal.version_id)

Line 2284: , PA_REP_UTIL_SCREEN.calculate_capacity(

2280: , 0)
2281: , 0))
2282: , 1)
2283: )
2284: , PA_REP_UTIL_SCREEN.calculate_capacity(
2285: PA_REP_UTIL_GLOB.GetOrgId
2286: , PA_REP_UTIL_GLOB.GetBalTypeActuals
2287: , max(paobj.person_id)
2288: , max(summbal.version_id)

Line 2357: , PA_REP_UTIL_SCREEN.calculate_capacity(

2353: , 0)
2354: , 0))
2355: , 1)
2356: )
2357: , PA_REP_UTIL_SCREEN.calculate_capacity(
2358: PA_REP_UTIL_GLOB.GetOrgId
2359: , PA_REP_UTIL_GLOB.GetBalTypeActuals
2360: , max(paobj.person_id)
2361: , max(summbal.version_id)

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

2402: , Decode(summbal.amount_type_id
2403: , 10, NVL(summbal.period_balance,0)
2404: , 0)
2405: , 0)))
2406: ,+0)),PA_REP_UTIL_SCREEN.calculate_capacity(
2407: PA_REP_UTIL_GLOB.GetOrgId
2408: , PA_REP_UTIL_GLOB.GetBalTypeForecast
2409: , max(paobj.person_id)
2410: , max(summbal.version_id)

Line 2618: , PA_REP_UTIL_SCREEN.calculate_capacity(

2614: , 0)
2615: , 0))
2616: , 1)
2617: )
2618: , PA_REP_UTIL_SCREEN.calculate_capacity(
2619: PA_REP_UTIL_GLOB.GetOrgId
2620: , PA_REP_UTIL_GLOB.GetBalTypeForecast
2621: , max(paobj.person_id)
2622: , max(summbal.version_id)

Line 2691: , PA_REP_UTIL_SCREEN.calculate_capacity(

2687: , 0)
2688: , 0))
2689: , 1)
2690: )
2691: , PA_REP_UTIL_SCREEN.calculate_capacity(
2692: PA_REP_UTIL_GLOB.GetOrgId
2693: , PA_REP_UTIL_GLOB.GetBalTypeForecast
2694: , max(paobj.person_id)
2695: , max(summbal.version_id)

Line 2799: Update PA_REP_UTIL_SCREEN_TMP tmp

2795: * of EMPLOYEE for all the records now check against pa_resources_denorm
2796: * to update the resource_type_code to MANAGERS appropriately.
2797: */
2798:
2799: Update PA_REP_UTIL_SCREEN_TMP tmp
2800: Set (resource_type,resource_type_code) = (select lkup2.meaning,lkup2.lookup_code
2801: from pa_lookups lkup2
2802: where lkup2.lookup_type='PERSON_TYPE'
2803: and lkup2.lookup_code = 'MANAGER')

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

2809:
2810: EXCEPTION
2811:
2812: WHEN OTHERS THEN
2813: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_REP_UTIL_SCREEN.poplt_screen_tmp_table'
2814: , p_procedure_name => PA_DEBUG.G_Err_Stack);
2815: RAISE;
2816:
2817:

Line 3272: END PA_REP_UTIL_SCREEN;

3268: );
3269: */
3270: COMMIT;
3271: END poplt_u1_screen_tmp_table;
3272: END PA_REP_UTIL_SCREEN;