1 PACKAGE AST_API_RECORDS_PKG AUTHID CURRENT_USER AS
2 /* $Header: astutirs.pls 120.4 2005/11/07 07:54:09 rkumares ship $ */
3
4 -- Start of comments
5 -- API name : Init_JTF_Perz_Query_Raw_Rec
6 -- Type : Private
7 -- Pre-reqs : None.
8 -- Function : Initializes and returns a new raw SQL query record type
9 -- as required by JTF_PERZ_QUERY_PUB
10 -- Parameters : None
11 -- Returns : JTF_PERZ_QUERY_PUB.QUERY_RAW_SQL_REC_TYPE
12 -- Version : Current version 1.0
13 -- Initial version 1.0
14 -- End of comments
15 FUNCTION Init_JTF_Perz_Query_Raw_Rec RETURN JTF_PERZ_QUERY_PUB.QUERY_RAW_SQL_REC_TYPE;
16 -- Start of comments
17 -- API name : Init_JTF_Perz_Query_Param_Rec
18 -- Type : Private
19 -- Pre-reqs : None.
20 -- Function : Initializes and returns a new query parameter record type
21 -- as required by JTF_PERZ_QUERY_PUB
22 -- Parameters : None
23 -- Returns : JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_REC_TYPE
24 -- Version : Current version 1.0
25 -- Initial version 1.0
26 -- End of comments
27 FUNCTION Init_JTF_Perz_Query_Param_Rec RETURN JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_REC_TYPE;
28 -- Start of comments
29 -- API name : Init_JTF_Perz_Query_Order_Rec
30 -- Type : Private
31 -- Pre-reqs : None.
32 -- Function : Initializes and returns a new query order-by record type
33 -- as required by JTF_PERZ_QUERY_PUB
34 -- Parameters : None
35 -- Returns : JTF_PERZ_QUERY_PUB.QUERY_ORDER_BY_REC_TYPE
36 -- Version : Current version 1.0
37 -- Initial version 1.0
38 -- End of comments
39 FUNCTION Init_JTF_Perz_Query_Order_Rec RETURN JTF_PERZ_QUERY_PUB.QUERY_ORDER_BY_REC_TYPE;
40 -- Start of comments
41 -- API name : Init_JTF_Perz_Prof_Attr_Rec
42 -- Type : Private
43 -- Pre-reqs : None.
44 -- Function : Initializes and returns a new personal profile attributes record type
45 -- as required by JTF_PERZ_PROFILE_PUB
46 -- Parameters : None
47 -- Returns : JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_REC_TYPE
48 -- Version : Current version 1.0
49 -- Initial version 1.0
50 -- End of comments
51 FUNCTION Init_JTF_Perz_Prof_Attr_Rec RETURN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_REC_TYPE;
52 -- Start of comments
53 -- API name : Init_Record
54 -- Type : Private
55 -- Pre-reqs : None.
56 -- Function : Initializes and returns a new raw SQL query record type
57 -- as required by JTF_PERZ_QUERY_PUB
58 -- Parameters :
59 -- x_query_raw_rec IN OUT JTF_PERZ_QUERY_PUB.QUERY_RAW_SQL_REC_TYPE
60 --
61 -- Version : Current version 1.0
62 -- Initial version 1.0
63 -- End of comments
64 PROCEDURE Init_Record ( x_query_raw_rec IN OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_QUERY_PUB.QUERY_RAW_SQL_REC_TYPE);
65 -- Start of comments
66 -- API name : Init_Record
67 -- Type : Private
68 -- Pre-reqs : None.
69 -- Function : Initializes a query parameter record type
70 -- as required by JTF_PERZ_QUERY_PUB
71 -- Parameters :
72 -- x_query_param_rec IN OUT JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_REC_TYPE Required
73 --
74 -- Version : Current version 1.0
75 -- Initial version 1.0
76 -- End of comments
77 PROCEDURE Init_Record ( x_query_param_rec IN OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_REC_TYPE);
78 -- Start of comments
79 -- API name : Init_Record
80 -- Type : Private
81 -- Pre-reqs : None.
82 -- Function : Initializes a query order-by record type
83 -- as required by JTF_PERZ_QUERY_PUB
84 -- Parameters :
85 -- x_query_order_rec IN OUT JTF_PERZ_QUERY_PUB.QUERY_ORDER_BY_REC_TYPE Required
86 --
87 -- Version : Current version 1.0
88 -- Initial version 1.0
89 -- End of comments
90 PROCEDURE Init_Record ( x_query_order_rec IN OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_QUERY_PUB.QUERY_ORDER_BY_REC_TYPE);
91 -- Start of comments
92 -- API name : Init_Record
93 -- Type : Private
94 -- Pre-reqs : None.
95 -- Function : Initializes a personal profile attributes record type
96 -- as required by JTF_PERZ_PROFILE_PUB
97 -- Parameters :
98 -- x_profile_attr_rec IN OUT JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_REC_TYPE Required
99 --
100 -- Version : Current version 1.0
101 -- Initial version 1.0
102 -- End of comments
103 PROCEDURE Init_Record ( x_profile_attr_rec IN OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_REC_TYPE);
104 -- Start of comments
105 -- Start of initialization functions to initialize HZ related record types
106 -- Used by the customer, contact modules in sales Center and response center
107 -- API name : INIT_HZ_INTEREST_REC
108 -- Type : Private
109 -- Pre-reqs : None.
110 -- Function : Initializes and returns the record type for HZ_INTEREST_REC
111 -- Parameters : None
112 -- Returns : HZ_PERSON_INFO_PUB.PER_INTEREST_REC_TYPE
113 -- Version : Current version 1.0
114 -- Initial version 1.0
115 -- End of comments
116 FUNCTION INIT_AS_INTEREST_REC RETURN AS_INTEREST_PUB.INTEREST_REC_TYPE;
117 -- Start of comments
118 -- Start of initialization functions to initialize JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE
119 -- Used by the customer, contact modules in sales Center and response center
120 -- API name : INIT_AS_INTEREST_REC
121 -- Type : Private
122 -- Pre-reqs : None.
123 -- Function : Initializes and returns the record type for JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE
124 -- Parameters : None
125 -- Returns : AS_INTEREST_PUB.INTEREST_REC_TYPE
126 -- Version : Current version 1.0
127 -- Initial version 1.0
128 -- End of comments
129 FUNCTION INIT_JTF_NOTES_PUB_CONTEXT_TBL RETURN JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
130
131 -- Start of comments
132 -- Start of initialization functions to initialize HZ_CUSTOMER_ACCOUNTS_PUB.account_rec_type
133 -- Used by the customer, contact modules in sales Center and response center
134 -- API name :
135 -- Type : Private
136 -- Pre-reqs : None.
137 -- Function : Initializes and returns the record type for AS_INTEREST_PUB.INTEREST_REC_TYPE
138 -- Parameters : None
139 -- Returns : AS_INTEREST_PUB.INTEREST_REC_TYPE
140 -- Version : Current version 1.0
141 -- Initial version 1.0
142 -- End of comments
143 -- swkhanna 6/22/00 added the following record types for Accounts tab and Accounts Details
144
145
146
147
148
149 -- nprasad 3/28/02 added the following record type for Partner tab in Lead Center
150
151 FUNCTION Get_PV_Entity_Rec_Type RETURN PV_ENTY_ATTR_VALUE_PVT.enty_attr_val_rec_type;
152
153 -- end modification by swkhanna 06/21/00
154
155 -- Start of comments
156 -- API name : Get_OE_Order_Header_Rec
157 -- Type : Private
158 -- Pre-reqs : None.
159 -- Function : Initializes and returns the record type for ASO_ORDER_INT.Order_Header_rec_type
160 -- Parameters : None
161 -- Returns : ASO_ORDER_INT.Order_Header_rec_type
162 -- Version : Current version 1.0
163 -- Initial version 1.0
164 -- End of comments
165 FUNCTION Get_OE_Order_Header_Rec RETURN ASO_ORDER_INT.Order_Header_rec_type;
166
167
168
169 -- Start of comments
170 -- Start of initialization functions to initialize HZ related record types
171 -- Used by the customer, contact modules in response center
172 -- API name : INIT_HZ_ORG_REC
173 -- Type : Private
174 -- Pre-reqs : None.
175 -- Function : Initializes and returns the record type for HZ_ORG_REC
176 -- Parameters : None
177 -- Returns : HZ_PARTY_PUB.ORGANIZATION_REC_TYPE
178 -- Version : Current version 1.0
179 -- Initial version 1.0
180 -- End of comments
181 END AST_API_RECORDS_PKG;