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_UTILS dependencies on PA_UTILS

Line 1: PACKAGE BODY PA_UTILS AS

1: PACKAGE BODY PA_UTILS AS
2: /* $Header: PAXGUTLB.pls 120.12.12010000.6 2008/12/19 09:19:03 anuragar ship $ */
3: -- ==========================================================================
4: -- Added for bug 5067511 : These global variables should be only used in the
5: -- function GetPersonInfo

Line 50: pa_utils.Global_employee_id := p_emp_id;

46:
47: PROCEDURE SetGlobalEmpId ( p_emp_id NUMBER )
48: IS
49: BEGIN
50: pa_utils.Global_employee_id := p_emp_id;
51: END SetGlobalEmpId;
52:
53: -- ==========================================================================
54: -- = FUNCTION GetGlobalEmpId

Line 60: RETURN ( pa_utils.Global_employee_id );

56:
57: FUNCTION GetGlobalEmpId RETURN NUMBER
58: IS
59: BEGIN
60: RETURN ( pa_utils.Global_employee_id );
61: END GetGlobalEmpId;
62:
63: -- ==========================================================================
64: -- = PROCEDURE GetTaskInfo

Line 289: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'

285: FROM
286: hr_organization_units o,
287: pa_implementations i
288: WHERE name = X_org_name
289: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
290: AND o.business_group_id = i.business_group_id)
291: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y'));
292:
293: RETURN ( X_org_id );

Line 291: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y'));

287: pa_implementations i
288: WHERE name = X_org_name
289: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
290: AND o.business_group_id = i.business_group_id)
291: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y'));
292:
293: RETURN ( X_org_id );
294:
295: EXCEPTION

Line 324: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'

320: FROM
321: hr_organization_units o,
322: pa_implementations i
323: WHERE name = X_org_name
324: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
325: AND o.business_group_id = i.business_group_id)
326: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y'
327: AND o.business_group_id = X_bg_id ));
328: Else

Line 326: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y'

322: pa_implementations i
323: WHERE name = X_org_name
324: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
325: AND o.business_group_id = i.business_group_id)
326: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y'
327: AND o.business_group_id = X_bg_id ));
328: Else
329: SELECT
330: organization_id

Line 337: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'

333: FROM
334: hr_organization_units o,
335: pa_implementations i
336: WHERE name = X_org_name
337: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
338: AND o.business_group_id = i.business_group_id)
339: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y' ));
340: End If;
341:

Line 339: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y' ));

335: pa_implementations i
336: WHERE name = X_org_name
337: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
338: AND o.business_group_id = i.business_group_id)
339: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y' ));
340: End If;
341:
342: EXCEPTION
343: WHEN NO_DATA_FOUND THEN

Line 372: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'

368: hr_organization_units o,
369: pa_implementations i
370: WHERE
371: organization_id = X_org_id
372: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
373: AND o.business_group_id = i.business_group_id)
374: OR pa_utils.IsCrossBGProfile_WNPS = 'Y' )
375: ;
376:

Line 374: OR pa_utils.IsCrossBGProfile_WNPS = 'Y' )

370: WHERE
371: organization_id = X_org_id
372: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
373: AND o.business_group_id = i.business_group_id)
374: OR pa_utils.IsCrossBGProfile_WNPS = 'Y' )
375: ;
376:
377:
378: RETURN ( X_org_name );

Line 499: X_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS; --Moved the function call from inside where clause to here

495:
496: G_PREV_PERSON_ID2 := x_person_id;
497: G_PREV_DATE4 := x_date;
498:
499: X_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS; --Moved the function call from inside where clause to here
500:
501: SELECT business_group_id --Moved selection of BG id from inside where clause to here
502: INTO X_business_group_id
503: FROM pa_implementations;

Line 710: X_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS; --Moved the function call from inside where clause to here

706:
707: G_PREV_PERSON_ID := x_person_id;
708: G_PREV_DATE3 := trunc(x_date);
709:
710: X_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS; --Moved the function call from inside where clause to here
711:
712: SELECT business_group_id --Moved selection of BG id from inside where clause to here
713: INTO X_business_group_id
714: FROM pa_implementations;

Line 938: l_business_group_id := pa_utils.business_group_id;

934: IS
935: l_business_group_id NUMBER;
936: BEGIN
937: IF G_Business_Group_Id IS NULL THEN
938: l_business_group_id := pa_utils.business_group_id;
939: ELSE
940: l_business_group_id := G_Business_Group_Id;
941: END IF;
942:

Line 957: G_Business_Group_Id := pa_utils.business_group_id;

953:
954: PROCEDURE Set_business_group_id
955: IS
956: BEGIN
957: G_Business_Group_Id := pa_utils.business_group_id;
958:
959: END Set_business_group_id;
960:
961: -- ==========================================================================

Line 1543: X_Cross_BG_Profile := pa_utils.IsCrossBGProfile_WNPS; /Bug 6355926/

1539: l_po_line_num NUMBER;
1540: X_Cross_BG_Profile VARCHAR2(2); /*Bug 6355926*/
1541:
1542: BEGIN
1543: X_Cross_BG_Profile := pa_utils.IsCrossBGProfile_WNPS; /*Bug 6355926*/
1544: If (G_PersonIdPrev = X_Person_Id AND
1545: trunc(G_DatePrev) = trunc(X_Date) AND
1546: x_po_number is null AND
1547: x_po_line_num is null) Then

Line 1766: END pa_utils;

1762:
1763: Return ('NOT_FOUND');
1764: END GetPersonInfo;
1765:
1766: END pa_utils;