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 ;
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 ;
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:
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
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
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
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:
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