eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_CF_TYPE_GRP dependencies on PON_PRICE_ELEMENT_TYPES

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 18: -- pon_price_element_types%ROWTYPE.

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
21: -- accept cost factor id, code or name and attempt to query the VL in that order
22: -- If no record correponding record is found, the API will return status of E to

Line 28: -- p_price_element_id pon_price_element_types.price_element_type_id%TYPE

24: -- return status of success
25: --
26: -- IN Parameters:
27: -- p_api_version NUMBER
28: -- p_price_element_id pon_price_element_types.price_element_type_id%TYPE
29: -- p_price_element_code pon_price_element_types.price_element_code%TYPE
30: -- p_name pon_price_element_types_tl.name%TYPE
31: --
32: -- OUT Parameters

Line 29: -- p_price_element_code pon_price_element_types.price_element_code%TYPE

25: --
26: -- IN Parameters:
27: -- p_api_version NUMBER
28: -- p_price_element_id pon_price_element_types.price_element_type_id%TYPE
29: -- p_price_element_code pon_price_element_types.price_element_code%TYPE
30: -- p_name pon_price_element_types_tl.name%TYPE
31: --
32: -- OUT Parameters
33: --

Line 30: -- p_name pon_price_element_types_tl.name%TYPE

26: -- IN Parameters:
27: -- p_api_version NUMBER
28: -- p_price_element_id pon_price_element_types.price_element_type_id%TYPE
29: -- p_price_element_code pon_price_element_types.price_element_code%TYPE
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;

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 48: ,p_price_element_id IN pon_price_element_types.price_element_type_id%TYPE DEFAULT NULL

44: --------------------------------------------------------------------------------
45:
46: PROCEDURE get_Cost_Factor_details(
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

Line 49: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE DEFAULT NULL

45:
46: PROCEDURE get_Cost_Factor_details(
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

Line 50: ,p_name IN pon_price_element_types_tl.name%TYPE DEFAULT NULL

46: PROCEDURE get_Cost_Factor_details(
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

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 85: -- p_price_element_code pon_price_element_types.price_element_code%TYPE

81: -- their customers can decide how to handle it
82: --
83: -- IN Parameters:
84: -- p_api_version IN NUMBER
85: -- p_price_element_code pon_price_element_types.price_element_code%TYPE
86: -- p_pricing_basis pon_price_element_types.pricing_basis%TYPE
87: -- p_cost_component_class_id pon_price_element_types.cost_component_class_id%TYPE
88: -- p_cost_analysis_code pon_price_element_types.cost_analysis_code%TYPE
89: -- p_cost_acquisition_code pon_price_element_types.cost_acquisition_code%TYPE

Line 86: -- p_pricing_basis pon_price_element_types.pricing_basis%TYPE

82: --
83: -- IN Parameters:
84: -- p_api_version IN NUMBER
85: -- p_price_element_code pon_price_element_types.price_element_code%TYPE
86: -- p_pricing_basis pon_price_element_types.pricing_basis%TYPE
87: -- p_cost_component_class_id pon_price_element_types.cost_component_class_id%TYPE
88: -- p_cost_analysis_code pon_price_element_types.cost_analysis_code%TYPE
89: -- p_cost_acquisition_code pon_price_element_types.cost_acquisition_code%TYPE
90: -- p_name pon_price_element_types_tl.name%TYPE

Line 87: -- p_cost_component_class_id pon_price_element_types.cost_component_class_id%TYPE

83: -- IN Parameters:
84: -- p_api_version IN NUMBER
85: -- p_price_element_code pon_price_element_types.price_element_code%TYPE
86: -- p_pricing_basis pon_price_element_types.pricing_basis%TYPE
87: -- p_cost_component_class_id pon_price_element_types.cost_component_class_id%TYPE
88: -- p_cost_analysis_code pon_price_element_types.cost_analysis_code%TYPE
89: -- p_cost_acquisition_code pon_price_element_types.cost_acquisition_code%TYPE
90: -- p_name pon_price_element_types_tl.name%TYPE
91: -- p_description pon_price_element_types_tl.name%TYPE

Line 88: -- p_cost_analysis_code pon_price_element_types.cost_analysis_code%TYPE

84: -- p_api_version IN NUMBER
85: -- p_price_element_code pon_price_element_types.price_element_code%TYPE
86: -- p_pricing_basis pon_price_element_types.pricing_basis%TYPE
87: -- p_cost_component_class_id pon_price_element_types.cost_component_class_id%TYPE
88: -- p_cost_analysis_code pon_price_element_types.cost_analysis_code%TYPE
89: -- p_cost_acquisition_code pon_price_element_types.cost_acquisition_code%TYPE
90: -- p_name pon_price_element_types_tl.name%TYPE
91: -- p_description pon_price_element_types_tl.name%TYPE
92: --

Line 89: -- p_cost_acquisition_code pon_price_element_types.cost_acquisition_code%TYPE

85: -- p_price_element_code pon_price_element_types.price_element_code%TYPE
86: -- p_pricing_basis pon_price_element_types.pricing_basis%TYPE
87: -- p_cost_component_class_id pon_price_element_types.cost_component_class_id%TYPE
88: -- p_cost_analysis_code pon_price_element_types.cost_analysis_code%TYPE
89: -- p_cost_acquisition_code pon_price_element_types.cost_acquisition_code%TYPE
90: -- p_name pon_price_element_types_tl.name%TYPE
91: -- p_description pon_price_element_types_tl.name%TYPE
92: --
93: -- OUT Parameters

Line 90: -- p_name pon_price_element_types_tl.name%TYPE

86: -- p_pricing_basis pon_price_element_types.pricing_basis%TYPE
87: -- p_cost_component_class_id pon_price_element_types.cost_component_class_id%TYPE
88: -- p_cost_analysis_code pon_price_element_types.cost_analysis_code%TYPE
89: -- p_cost_acquisition_code pon_price_element_types.cost_acquisition_code%TYPE
90: -- p_name pon_price_element_types_tl.name%TYPE
91: -- p_description pon_price_element_types_tl.name%TYPE
92: --
93: -- OUT Parameters
94: --

Line 91: -- p_description pon_price_element_types_tl.name%TYPE

87: -- p_cost_component_class_id pon_price_element_types.cost_component_class_id%TYPE
88: -- p_cost_analysis_code pon_price_element_types.cost_analysis_code%TYPE
89: -- p_cost_acquisition_code pon_price_element_types.cost_acquisition_code%TYPE
90: -- p_name pon_price_element_types_tl.name%TYPE
91: -- p_description pon_price_element_types_tl.name%TYPE
92: --
93: -- OUT Parameters
94: --
95: --

Line 101: -- x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE

97: -- indicates whether a new cost factor was created
98: -- or whether an existing one was updated
99: -- Contains value INSERT or UPDATE
100: --
101: -- x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE
102: -- Identifier of the cost factor inserted or updated.
103: -- OPM will use this to update their mapping tables
104: --
105: -- x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE

Line 105: -- x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE

101: -- x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE
102: -- Identifier of the cost factor inserted or updated.
103: -- OPM will use this to update their mapping tables
104: --
105: -- x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE
106: -- If the record is updated and OPM finds that the
107: -- pricing basis passed in is different from that
108: -- present in the table, then an error will be printed
109: -- in the patch log

Line 121: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE

117: -- End of Comments
118: --------------------------------------------------------------------------------
119: PROCEDURE opm_create_update_cost_factor(
120: p_api_version IN NUMBER
121: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE
122: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE
123: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
124: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
125: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE

Line 122: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE

118: --------------------------------------------------------------------------------
119: PROCEDURE opm_create_update_cost_factor(
120: p_api_version IN NUMBER
121: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE
122: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE
123: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
124: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
125: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
126: ,p_name IN pon_price_element_types_tl.name%TYPE

Line 123: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE

119: PROCEDURE opm_create_update_cost_factor(
120: p_api_version IN NUMBER
121: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE
122: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE
123: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
124: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
125: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
126: ,p_name IN pon_price_element_types_tl.name%TYPE
127: ,p_description IN pon_price_element_types_tl.name%TYPE

Line 124: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE

120: p_api_version IN NUMBER
121: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE
122: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE
123: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
124: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
125: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
126: ,p_name IN pon_price_element_types_tl.name%TYPE
127: ,p_description IN pon_price_element_types_tl.name%TYPE
128: ,x_insert_update_action OUT NOCOPY VARCHAR2

Line 125: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE

121: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE
122: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE
123: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
124: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
125: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
126: ,p_name IN pon_price_element_types_tl.name%TYPE
127: ,p_description IN pon_price_element_types_tl.name%TYPE
128: ,x_insert_update_action OUT NOCOPY VARCHAR2
129: ,x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE

Line 126: ,p_name IN pon_price_element_types_tl.name%TYPE

122: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE
123: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
124: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
125: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
126: ,p_name IN pon_price_element_types_tl.name%TYPE
127: ,p_description IN pon_price_element_types_tl.name%TYPE
128: ,x_insert_update_action OUT NOCOPY VARCHAR2
129: ,x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE
130: ,x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE

Line 127: ,p_description IN pon_price_element_types_tl.name%TYPE

123: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
124: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
125: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
126: ,p_name IN pon_price_element_types_tl.name%TYPE
127: ,p_description IN pon_price_element_types_tl.name%TYPE
128: ,x_insert_update_action OUT NOCOPY VARCHAR2
129: ,x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE
130: ,x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE
131: ,x_return_status OUT NOCOPY VARCHAR2

Line 129: ,x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE

125: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
126: ,p_name IN pon_price_element_types_tl.name%TYPE
127: ,p_description IN pon_price_element_types_tl.name%TYPE
128: ,x_insert_update_action OUT NOCOPY VARCHAR2
129: ,x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE
130: ,x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE
131: ,x_return_status OUT NOCOPY VARCHAR2
132: ,x_msg_data OUT NOCOPY VARCHAR2
133: ,x_msg_count OUT NOCOPY NUMBER

Line 130: ,x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE

126: ,p_name IN pon_price_element_types_tl.name%TYPE
127: ,p_description IN pon_price_element_types_tl.name%TYPE
128: ,x_insert_update_action OUT NOCOPY VARCHAR2
129: ,x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE
130: ,x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE
131: ,x_return_status OUT NOCOPY VARCHAR2
132: ,x_msg_data OUT NOCOPY VARCHAR2
133: ,x_msg_count OUT NOCOPY NUMBER
134: );

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 150: -- pon_price_element_types%ROWTYPE.

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
153: -- accept cost factor id and attempt to query the VL.
154: -- If no record correponding record is found, the API will return a null record.

Line 158: -- p_price_element_id pon_price_element_types.price_element_type_id%TYPE

154: -- If no record correponding record is found, the API will return a null record.
155: -- Otherwise, the corresponding record will be returned.
156: --
157: -- IN Parameters:
158: -- p_price_element_id pon_price_element_types.price_element_type_id%TYPE
159: --
160: -- OUT Parameters
161: -- None
162: --

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 170: p_price_element_id IN pon_price_element_types.price_element_type_id%TYPE)

166: -- End of Comments
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 --

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 186: -- pon_price_element_types%ROWTYPE.

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
189: -- accept cost factor code and attempt to query the VL.
190: -- If no record correponding record is found, the API will return a null record.

Line 194: -- p_price_element_code pon_price_element_types.price_element_code%TYPE

190: -- If no record correponding record is found, the API will return a null record.
191: -- Otherwise, the corresponding record will be returned.
192: --
193: -- IN Parameters:
194: -- p_price_element_code pon_price_element_types.price_element_code%TYPE
195: --
196: -- OUT Parameters
197: -- None
198: --

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 206: p_price_element_code IN pon_price_element_types.price_element_code%TYPE)

202: -- End of Comments
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;

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;