DBA Data[Home] [Help]

APPS.PON_CF_TYPE_GRP dependencies on PON_PRICE_ELEMENT_TYPES_VL

Line 16: -- Function: The procedure queries the pon_price_element_types_vl to retrieve

12: -- Type: Group
13: --
14: -- Pre-reqs: None
15: --
16: -- Function: The procedure queries the pon_price_element_types_vl to retrieve
17: -- the cost factor details and returns them in a record of type
18: -- pon_price_element_types%ROWTYPE.
19: --
20: -- Since the intended use of this API is to for Oracle Recieveing ROI, the API will

Line 34: -- x_cost_factor_rec pon_price_element_types_vl%ROWTYPE;

30: -- p_name pon_price_element_types_tl.name%TYPE
31: --
32: -- OUT Parameters
33: --
34: -- x_cost_factor_rec pon_price_element_types_vl%ROWTYPE;
35: --
36: -- x_return_status OUT NOCOPY VARCHAR2
37: -- U indicates Unexpected Error, S indicates success
38: -- x_msg_data OUT NOCOPY VARCHAR2

Line 51: ,x_cost_factor_rec OUT NOCOPY pon_price_element_types_vl%ROWTYPE

47: p_api_version IN NUMBER
48: ,p_price_element_id IN pon_price_element_types.price_element_type_id%TYPE DEFAULT NULL
49: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE DEFAULT NULL
50: ,p_name IN pon_price_element_types_tl.name%TYPE DEFAULT NULL
51: ,x_cost_factor_rec OUT NOCOPY pon_price_element_types_vl%ROWTYPE
52: ,x_return_status OUT NOCOPY VARCHAR2
53: ,x_msg_data OUT NOCOPY VARCHAR2
54: ,x_msg_count OUT NOCOPY NUMBER
55: );

Line 148: -- Function: The OVERLOADED API queries the pon_price_element_types_vl to retrieve

144: -- Type: Group
145: --
146: -- Pre-reqs: None
147: --
148: -- Function: The OVERLOADED API queries the pon_price_element_types_vl to retrieve
149: -- the cost factor details and returns them in a record of type
150: -- pon_price_element_types%ROWTYPE.
151: --
152: -- The intended use of this API is to for Oracle Recieveing ROI, the API will

Line 164: -- pon_price_element_types_vl%ROWTYPE

160: -- OUT Parameters
161: -- None
162: --
163: -- RETURNS:
164: -- pon_price_element_types_vl%ROWTYPE
165: --
166: -- End of Comments
167: --------------------------------------------------------------------------------
168:

Line 171: RETURN pon_price_element_types_vl%ROWTYPE;

167: --------------------------------------------------------------------------------
168:
169: FUNCTION get_Cost_Factor_details(
170: p_price_element_id IN pon_price_element_types.price_element_type_id%TYPE)
171: RETURN pon_price_element_types_vl%ROWTYPE;
172:
173: --------------------------------------------------------------------------------
174: -- get_cost_factor_details --
175: --------------------------------------------------------------------------------

Line 184: -- Function: The OVERLOADED API queries the pon_price_element_types_vl to retrieve

180: -- Type: Group
181: --
182: -- Pre-reqs: None
183: --
184: -- Function: The OVERLOADED API queries the pon_price_element_types_vl to retrieve
185: -- the cost factor details and returns them in a record of type
186: -- pon_price_element_types%ROWTYPE.
187: --
188: -- The intended use of this API is to for Oracle Recieveing ROI, the API will

Line 200: -- pon_price_element_types_vl%ROWTYPE

196: -- OUT Parameters
197: -- None
198: --
199: -- RETURNS:
200: -- pon_price_element_types_vl%ROWTYPE
201: --
202: -- End of Comments
203: --------------------------------------------------------------------------------
204:

Line 207: RETURN pon_price_element_types_vl%ROWTYPE;

203: --------------------------------------------------------------------------------
204:
205: FUNCTION get_Cost_Factor_details(
206: p_price_element_code IN pon_price_element_types.price_element_code%TYPE)
207: RETURN pon_price_element_types_vl%ROWTYPE;
208:
209: END PON_CF_TYPE_GRP;