APPS.PA_CROSS_BUSINESS_GRP dependencies on PA_PLSQL_DATATYPES

Line 127: l_From_Job_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;

123: * arrays of data for process and requires that arrays of data be passed
124: * to it. Once returning from GetMappedToJobs the single value is extracted
125: * and returned in the OUT variable.
126: */
127: l_From_Job_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;
128: l_To_Job_Group_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_To_Job_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;
130: l_Status_Code_Tab PA_PLSQL_DATATYPES.Char30TabTyp;
131: l_Error_Stage VARCHAR2(150) := NULL ;

Line 128: l_To_Job_Group_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;

124: * to it. Once returning from GetMappedToJobs the single value is extracted
125: * and returned in the OUT variable.
126: */
127: l_From_Job_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;
128: l_To_Job_Group_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_To_Job_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;
130: l_Status_Code_Tab PA_PLSQL_DATATYPES.Char30TabTyp;
131: l_Error_Stage VARCHAR2(150) := NULL ;
132: l_Error_Code NUMBER := NULL ;

Line 129: l_To_Job_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;

125: * and returned in the OUT variable.
126: */
127: l_From_Job_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;
128: l_To_Job_Group_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_To_Job_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;
130: l_Status_Code_Tab PA_PLSQL_DATATYPES.Char30TabTyp;
131: l_Error_Stage VARCHAR2(150) := NULL ;
132: l_Error_Code NUMBER := NULL ;
133:

Line 130: l_Status_Code_Tab PA_PLSQL_DATATYPES.Char30TabTyp;

126: */
127: l_From_Job_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;
128: l_To_Job_Group_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_To_Job_Id_Tab PA_PLSQL_DATATYPES.IdTabTyp;
130: l_Status_Code_Tab PA_PLSQL_DATATYPES.Char30TabTyp;
131: l_Error_Stage VARCHAR2(150) := NULL ;
132: l_Error_Code NUMBER := NULL ;
133:
134: BEGIN

Line 179: P_From_Job_Id_Tab IN PA_PLSQL_DATATYPES.IdTabTyp,

175:
176: END GetMappedToJob;
177:
178: PROCEDURE GetMappedToJobs (
179: P_From_Job_Id_Tab IN PA_PLSQL_DATATYPES.IdTabTyp,
180: P_To_Job_Group_Id_Tab IN PA_PLSQL_DATATYPES.IdTabTyp,
181: X_To_Job_Id_Tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
182: X_StatusTab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
183: X_Error_Stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 180: P_To_Job_Group_Id_Tab IN PA_PLSQL_DATATYPES.IdTabTyp,

176: END GetMappedToJob;
177:
178: PROCEDURE GetMappedToJobs (
179: P_From_Job_Id_Tab IN PA_PLSQL_DATATYPES.IdTabTyp,
180: P_To_Job_Group_Id_Tab IN PA_PLSQL_DATATYPES.IdTabTyp,
181: X_To_Job_Id_Tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
182: X_StatusTab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
183: X_Error_Stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
184: X_Error_Code OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895

Line 181: X_To_Job_Id_Tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895

177:
178: PROCEDURE GetMappedToJobs (
179: P_From_Job_Id_Tab IN PA_PLSQL_DATATYPES.IdTabTyp,
180: P_To_Job_Group_Id_Tab IN PA_PLSQL_DATATYPES.IdTabTyp,
181: X_To_Job_Id_Tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
182: X_StatusTab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
183: X_Error_Stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
184: X_Error_Code OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895
185:

Line 182: X_StatusTab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895

178: PROCEDURE GetMappedToJobs (
179: P_From_Job_Id_Tab IN PA_PLSQL_DATATYPES.IdTabTyp,
180: P_To_Job_Group_Id_Tab IN PA_PLSQL_DATATYPES.IdTabTyp,
181: X_To_Job_Id_Tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
182: X_StatusTab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
183: X_Error_Stage OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
184: X_Error_Code OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895
185:
186: IS