PACKAGE: APPS.PA_CROSS_BUSINESS_GRP

Source

1 PACKAGE PA_CROSS_BUSINESS_GRP
2 --  $Header: PAXCBGAS.pls 120.1 2005/08/19 17:11:04 mwasowic noship $
3 AUTHID CURRENT_USER AS
4 
5 G_MasterGroupId		NUMBER ;
6 G_CrossBGProfile        VARCHAR2(1) ;
7 
8 FUNCTION IsMappedToJob	(P_From_Job_Id IN NUMBER,
9 			 P_To_Job_Group_Id IN NUMBER ) RETURN NUMBER;
10 pragma RESTRICT_REFERENCES ( IsMappedToJob, WNDS );
11 
12 PROCEDURE GetMappedToJob (
13 			P_From_Job_Id IN NUMBER,
14 			P_To_Job_Group_Id IN NUMBER,
15 			X_To_Job_Id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
16 			X_Status_Code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
17 			X_Error_Stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
18 			X_Error_Code OUT NOCOPY NUMBER ) ; --File.Sql.39 bug 4440895
19 
20 
21 PROCEDURE GetMappedToJobs (
22 		P_From_Job_Id_Tab IN PA_PLSQL_DATATYPES.IdTabTyp,
23 		P_To_Job_Group_Id_Tab IN PA_PLSQL_DATATYPES.IdTabTyp,
24 		X_To_Job_Id_Tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
25 		X_StatusTab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
26 		X_Error_Stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
27 		X_Error_Code OUT NOCOPY NUMBER ) ; --File.Sql.39 bug 4440895
28 
29 
30 FUNCTION IsCrossBGProfile RETURN VARCHAR2 ;
31 pragma RESTRICT_REFERENCES ( IsCrossBGProfile, WNDS);
32 
33 
34 PROCEDURE GetMasterGrpId  (
35 			P_Business_Group_Id IN NUMBER DEFAULT NULL,
36 			X_Master_Grp_Id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
37 			X_Status_Code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
38 			X_Error_Stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
39 			X_Error_Code OUT NOCOPY NUMBER ) ; --File.Sql.39 bug 4440895
40 
41 PROCEDURE GetGlobalHierarchy (
42 			P_Org_Structure_Id IN NUMBER,
43 			X_Global_Hierarchy OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
44 			X_Status_Code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
45 			X_Error_Stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
46 			X_Error_Code OUT NOCOPY NUMBER ) ; --File.Sql.39 bug 4440895
47 
48 
49 PROCEDURE GetJobIds (	P_HR_Job_Id IN NUMBER,
50 			P_Project_Id IN NUMBER,
51 			X_Bill_Job_Id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
52 			X_Bill_Job_Grp_Id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
53 			X_Cost_Job_Id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
54 			X_Cost_Job_Grp_Id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
55 			X_PP_Bill_Job_Id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
56 			X_Status_Code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
57 			X_Error_Stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58 			X_Error_Code OUT NOCOPY NUMBER ) ; --File.Sql.39 bug 4440895
59 
60 FUNCTION GetDefProjJobGrpId ( P_Project_Id IN NUMBER,
61 			      P_Group_Type IN VARCHAR2 ) RETURN NUMBER ;
62 pragma RESTRICT_REFERENCES ( GetDefProjJobGrpId, WNDS, WNPS) ;
63 
64 FUNCTION FindJobIndex ( P_From_Job_To_Grp IN VARCHAR2 ) RETURN BINARY_INTEGER;
65 pragma RESTRICT_REFERENCES ( FindJobIndex, WNDS ) ;
66 
67 FUNCTION HRJobGroupIs (P_Business_Group_Id IN NUMBER ) RETURN NUMBER;
68 pragma RESTRICT_REFERENCES ( HRJobGroupIs, WNDS, WNPS ) ;
69 
70 PROCEDURE ErrorStage(P_Message IN VARCHAR2,
71                      X_Stage OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
72 
73 
74 End;