DBA Data[Home] [Help]

PACKAGE: APPS.PA_PROJ_REQ_ASSOCIATIONS_PKG

Source


1 PACKAGE PA_PROJ_REQ_ASSOCIATIONS_PKG as
2 /* $Header: PAYRASSS.pls 120.1 2005/08/19 17:24:04 mwasowic noship $ */
3 
4 --
5 -- Procedure     : Insert_rows
6 -- Purpose       : Create Rows in PA_PROJ_REQ_ASSOCIATIONS_TEMP.
7 --
8 --
9 PROCEDURE insert_rows
10       ( p_object_type_tbl            IN PA_PLSQL_DATATYPES.Char30TabTyp      ,
11 				p_object_id1_tbl             IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
12 				p_object_id2_tbl             IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
13 				p_object_id3_tbl             IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
14 				p_object_id4_tbl             IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
15 				p_object_id5_tbl             IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
16 				p_object_name_tbl            IN PA_PLSQL_DATATYPES.Char80TabTyp      ,
17 				p_object_number_tbl          IN PA_PLSQL_DATATYPES.Char80TabTyp      ,
18 				p_object_type_name_tbl       IN PA_PLSQL_DATATYPES.Char80TabTyp      ,
19 				p_object_subtype_tbl         IN PA_PLSQL_DATATYPES.Char80TabTyp      ,
20 				p_status_name_tbl            IN PA_PLSQL_DATATYPES.Char80TabTyp      ,
21 				p_description_tbl            IN PA_PLSQL_DATATYPES.Char250TabTyp      ,
22         x_return_status              OUT  NOCOPY VARCHAR2                          , --File.Sql.39 bug 4440895
23         x_msg_count                  OUT  NOCOPY NUMBER                            , --File.Sql.39 bug 4440895
24         x_msg_data                   OUT  NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
25 
26 
27 END PA_PROJ_REQ_ASSOCIATIONS_PKG;