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.30.12020000.5 2013/04/03 11:27:18 byeturi 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: AND o.business_group_id = X_bg_id)
327: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y'));
328: -- AND o.business_group_id = X_bg_id ));Commented for bug16068318

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

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

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

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

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

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

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

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

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

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

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

506:
507: G_PREV_PERSON_ID2 := x_person_id;
508: G_PREV_DATE4 := x_date;
509:
510: X_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS; --Moved the function call from inside where clause to here
511:
512: SELECT business_group_id --Moved selection of BG id from inside where clause to here
513: INTO X_business_group_id
514: FROM pa_implementations;

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

778:
779: G_PREV_PERSON_ID := x_person_id;
780: G_PREV_DATE3 := trunc(x_date);
781:
782: X_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS; --Moved the function call from inside where clause to here
783:
784: SELECT business_group_id --Moved selection of BG id from inside where clause to here
785: INTO X_business_group_id
786: FROM pa_implementations;

Line 1063: pa_utils.G_return_status := 'NO_ASSIGNMENT';

1059: return l_job_id;
1060:
1061: EXCEPTION
1062: when no_data_found then
1063: pa_utils.G_return_status := 'NO_ASSIGNMENT';
1064: return NULL;
1065: -- raise; -- should we handle it?
1066: when too_many_rows then
1067: pa_utils.G_return_status := 'PA_TOO_MANY_JOBS';

Line 1067: pa_utils.G_return_status := 'PA_TOO_MANY_JOBS';

1063: pa_utils.G_return_status := 'NO_ASSIGNMENT';
1064: return NULL;
1065: -- raise; -- should we handle it?
1066: when too_many_rows then
1067: pa_utils.G_return_status := 'PA_TOO_MANY_JOBS';
1068: return NULL;
1069: -- raise; -- should we handle it?
1070: END getJobId;
1071:

Line 1182: l_business_group_id := pa_utils.business_group_id;

1178: IS
1179: l_business_group_id NUMBER;
1180: BEGIN
1181: IF G_Business_Group_Id IS NULL THEN
1182: l_business_group_id := pa_utils.business_group_id;
1183: ELSE
1184: l_business_group_id := G_Business_Group_Id;
1185: END IF;
1186:

Line 1201: G_Business_Group_Id := pa_utils.business_group_id;

1197:
1198: PROCEDURE Set_business_group_id
1199: IS
1200: BEGIN
1201: G_Business_Group_Id := pa_utils.business_group_id;
1202:
1203: END Set_business_group_id;
1204:
1205: -- ==========================================================================

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

1793: -- bug 11741116 end
1794:
1795:
1796: BEGIN
1797: X_Cross_BG_Profile := pa_utils.IsCrossBGProfile_WNPS; /*Bug 6355926*/
1798: If (G_PersonIdPrev = X_Person_Id AND
1799: trunc(G_DatePrev) = trunc(X_Date) AND
1800: x_po_number is null AND
1801: x_po_line_num is null) Then

Line 2609: END pa_utils;

2605: END initialize;
2606:
2607: /* End for Bug 14851933 */
2608:
2609: END pa_utils;