DBA Data[Home] [Help]

APPS.PON_CF_TYPE_GRP dependencies on PON_PRICE_ELEMENT_TYPES

Line 20: ,p_price_element_id IN pon_price_element_types.price_element_type_id%TYPE

16: --------------------------------------------------------------------------------
17:
18: PROCEDURE get_Cost_Factor_details(
19: p_api_version IN NUMBER
20: ,p_price_element_id IN pon_price_element_types.price_element_type_id%TYPE
21: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE DEFAULT NULL
22: ,p_name IN pon_price_element_types_tl.name%TYPE DEFAULT NULL
23: ,x_cost_factor_rec OUT NOCOPY pon_price_element_types_vl%ROWTYPE
24: ,x_return_status OUT NOCOPY VARCHAR2

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

17:
18: PROCEDURE get_Cost_Factor_details(
19: p_api_version IN NUMBER
20: ,p_price_element_id IN pon_price_element_types.price_element_type_id%TYPE
21: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE DEFAULT NULL
22: ,p_name IN pon_price_element_types_tl.name%TYPE DEFAULT NULL
23: ,x_cost_factor_rec OUT NOCOPY pon_price_element_types_vl%ROWTYPE
24: ,x_return_status OUT NOCOPY VARCHAR2
25: ,x_msg_data OUT NOCOPY VARCHAR2

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

18: PROCEDURE get_Cost_Factor_details(
19: p_api_version IN NUMBER
20: ,p_price_element_id IN pon_price_element_types.price_element_type_id%TYPE
21: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE DEFAULT NULL
22: ,p_name IN pon_price_element_types_tl.name%TYPE DEFAULT NULL
23: ,x_cost_factor_rec OUT NOCOPY pon_price_element_types_vl%ROWTYPE
24: ,x_return_status OUT NOCOPY VARCHAR2
25: ,x_msg_data OUT NOCOPY VARCHAR2
26: ,x_msg_count OUT NOCOPY NUMBER

Line 23: ,x_cost_factor_rec OUT NOCOPY pon_price_element_types_vl%ROWTYPE

19: p_api_version IN NUMBER
20: ,p_price_element_id IN pon_price_element_types.price_element_type_id%TYPE
21: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE DEFAULT NULL
22: ,p_name IN pon_price_element_types_tl.name%TYPE DEFAULT NULL
23: ,x_cost_factor_rec OUT NOCOPY pon_price_element_types_vl%ROWTYPE
24: ,x_return_status OUT NOCOPY VARCHAR2
25: ,x_msg_data OUT NOCOPY VARCHAR2
26: ,x_msg_count OUT NOCOPY NUMBER
27: ) IS

Line 34: TYPE cost_factor_type IS REF CURSOR RETURN pon_price_element_types_vl%ROWTYPE;

30: l_api_version CONSTANT NUMBER := 1.0;
31: l_stage VARCHAR2(50);
32:
33:
34: TYPE cost_factor_type IS REF CURSOR RETURN pon_price_element_types_vl%ROWTYPE;
35: cost_factor_cur cost_factor_type;
36:
37: l_query_ind VARCHAR2(1);
38:

Line 74: FOR SELECT * FROM pon_price_element_types_vl

70: l_stage := '30: running query';
71: IF l_query_ind = 'I' THEN
72: l_stage := '40: running query for ID';
73: OPEN cost_factor_cur
74: FOR SELECT * FROM pon_price_element_types_vl
75: WHERE price_element_type_id = p_price_element_id;
76: FETCH cost_factor_cur INTO x_cost_factor_rec;
77: IF cost_factor_cur%NOTFOUND THEN
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 86: FOR SELECT * FROM pon_price_element_types_vl

82:
83: ELSIF l_query_ind = 'C' THEN
84: l_stage := '50: running query for CODE';
85: OPEN cost_factor_cur
86: FOR SELECT * FROM pon_price_element_types_vl
87: WHERE price_element_code = p_price_element_code;
88: FETCH cost_factor_cur INTO x_cost_factor_rec;
89: IF cost_factor_cur%NOTFOUND THEN
90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 98: FOR SELECT * FROM pon_price_element_types_vl

94:
95: ELSIF l_query_ind = 'N' THEN
96: l_stage := '40: running query for NAME';
97: OPEN cost_factor_cur
98: FOR SELECT * FROM pon_price_element_types_vl
99: WHERE name = p_name;
100: FETCH cost_factor_cur INTO x_cost_factor_rec;
101: IF cost_factor_cur%NOTFOUND THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 150: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE

146:
147:
148: PROCEDURE opm_create_update_cost_factor(
149: p_api_version IN NUMBER
150: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE
151: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE
152: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
153: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
154: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE

Line 151: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE

147:
148: PROCEDURE opm_create_update_cost_factor(
149: p_api_version IN NUMBER
150: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE
151: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE
152: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
153: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
154: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
155: ,p_name IN pon_price_element_types_tl.name%TYPE

Line 152: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE

148: PROCEDURE opm_create_update_cost_factor(
149: p_api_version IN NUMBER
150: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE
151: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE
152: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
153: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
154: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
155: ,p_name IN pon_price_element_types_tl.name%TYPE
156: ,p_description IN pon_price_element_types_tl.name%TYPE

Line 153: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE

149: p_api_version IN NUMBER
150: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE
151: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE
152: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
153: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
154: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
155: ,p_name IN pon_price_element_types_tl.name%TYPE
156: ,p_description IN pon_price_element_types_tl.name%TYPE
157: ,x_insert_update_action OUT NOCOPY VARCHAR2

Line 154: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE

150: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE
151: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE
152: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
153: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
154: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
155: ,p_name IN pon_price_element_types_tl.name%TYPE
156: ,p_description IN pon_price_element_types_tl.name%TYPE
157: ,x_insert_update_action OUT NOCOPY VARCHAR2
158: ,x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE

Line 155: ,p_name IN pon_price_element_types_tl.name%TYPE

151: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE
152: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
153: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
154: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
155: ,p_name IN pon_price_element_types_tl.name%TYPE
156: ,p_description IN pon_price_element_types_tl.name%TYPE
157: ,x_insert_update_action OUT NOCOPY VARCHAR2
158: ,x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE
159: ,x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE

Line 156: ,p_description IN pon_price_element_types_tl.name%TYPE

152: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
153: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
154: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
155: ,p_name IN pon_price_element_types_tl.name%TYPE
156: ,p_description IN pon_price_element_types_tl.name%TYPE
157: ,x_insert_update_action OUT NOCOPY VARCHAR2
158: ,x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE
159: ,x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE
160: ,x_return_status OUT NOCOPY VARCHAR2

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

154: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
155: ,p_name IN pon_price_element_types_tl.name%TYPE
156: ,p_description IN pon_price_element_types_tl.name%TYPE
157: ,x_insert_update_action OUT NOCOPY VARCHAR2
158: ,x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE
159: ,x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE
160: ,x_return_status OUT NOCOPY VARCHAR2
161: ,x_msg_data OUT NOCOPY VARCHAR2
162: ,x_msg_count OUT NOCOPY NUMBER

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

155: ,p_name IN pon_price_element_types_tl.name%TYPE
156: ,p_description IN pon_price_element_types_tl.name%TYPE
157: ,x_insert_update_action OUT NOCOPY VARCHAR2
158: ,x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE
159: ,x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE
160: ,x_return_status OUT NOCOPY VARCHAR2
161: ,x_msg_data OUT NOCOPY VARCHAR2
162: ,x_msg_count OUT NOCOPY NUMBER
163: ) IS

Line 170: l_price_element_type_id pon_price_element_types.price_element_type_id%TYPE;

166: l_api_version CONSTANT NUMBER := 1.0;
167: l_stage VARCHAR2(50);
168: l_temp VARCHAR2(3);
169:
170: l_price_element_type_id pon_price_element_types.price_element_type_id%TYPE;
171:
172: l_source_language fnd_languages.language_code%TYPE;
173:
174: BEGIN

Line 201: FROM pon_price_element_types

197: SELECT price_element_type_id
198: ,pricing_basis
199: INTO l_price_element_type_id
200: ,x_pricing_basis
201: FROM pon_price_element_types
202: WHERE price_element_code = p_price_element_code;
203:
204: l_stage := '25: PE Code found';
205:

Line 291: INSERT INTO PON_PRICE_ELEMENT_TYPES

287: THEN
288:
289: l_stage := '100: Insert cost factor';
290:
291: INSERT INTO PON_PRICE_ELEMENT_TYPES
292: (
293: price_element_type_id
294: ,trading_partner_id
295: ,price_element_code

Line 311: pon_price_element_types_s.NEXTVAL

307: ,cost_acquisition_code
308: )
309: VALUES
310: (
311: pon_price_element_types_s.NEXTVAL
312: ,0 -- trading_partner_id
313: ,p_price_element_code
314: ,p_pricing_basis
315: ,'Y' -- enabled_flag

Line 339: INSERT INTO pon_price_element_types_tl

335: -- The id is passed back so that OPM can update their tables
336:
337: l_stage := '120: Insert cost factor tl';
338:
339: INSERT INTO pon_price_element_types_tl
340: ( price_element_type_id
341: ,trading_partner_id
342: ,name
343: ,description

Line 372: UPDATE pon_price_element_types

368: -- the OPM team
369:
370: l_stage := '150: Update cost factor';
371:
372: UPDATE pon_price_element_types
373: SET
374: last_update_date = SYSDATE
375: ,last_updated_by = fnd_global.user_id
376: ,cost_analysis_code = p_cost_analysis_code

Line 443: p_price_element_id IN pon_price_element_types.price_element_type_id%TYPE

439: --- OVERLOADED get_cost_factor_details --
440: --------------------------------------------------------------------------------
441:
442: FUNCTION get_Cost_Factor_details(
443: p_price_element_id IN pon_price_element_types.price_element_type_id%TYPE
444: )
445: RETURN pon_price_element_types_vl%ROWTYPE IS
446:
447: l_api_name CONSTANT VARCHAR2(30) := 'get_cost_factor_details';

Line 445: RETURN pon_price_element_types_vl%ROWTYPE IS

441:
442: FUNCTION get_Cost_Factor_details(
443: p_price_element_id IN pon_price_element_types.price_element_type_id%TYPE
444: )
445: RETURN pon_price_element_types_vl%ROWTYPE IS
446:
447: l_api_name CONSTANT VARCHAR2(30) := 'get_cost_factor_details';
448: l_stage VARCHAR2(30);
449:

Line 452: FROM pon_price_element_types_vl

448: l_stage VARCHAR2(30);
449:
450: CURSOR cost_factor_cur (p_cf_type_id NUMBER) IS
451: SELECT *
452: FROM pon_price_element_types_vl
453: WHERE price_element_type_id = p_cf_type_id;
454:
455: l_cost_factor_type_rec cost_factor_cur%ROWTYPE;
456:

Line 496: p_price_element_code IN pon_price_element_types.price_element_code%TYPE

492: --- OVERLOADED get_cost_factor_details --
493: --------------------------------------------------------------------------------
494:
495: FUNCTION get_Cost_Factor_details(
496: p_price_element_code IN pon_price_element_types.price_element_code%TYPE
497: )
498: RETURN pon_price_element_types_vl%ROWTYPE IS
499:
500: l_api_name CONSTANT VARCHAR2(30) := 'get_cost_factor_details';

Line 498: RETURN pon_price_element_types_vl%ROWTYPE IS

494:
495: FUNCTION get_Cost_Factor_details(
496: p_price_element_code IN pon_price_element_types.price_element_code%TYPE
497: )
498: RETURN pon_price_element_types_vl%ROWTYPE IS
499:
500: l_api_name CONSTANT VARCHAR2(30) := 'get_cost_factor_details';
501: l_stage VARCHAR2(30);
502:

Line 505: FROM pon_price_element_types_vl

501: l_stage VARCHAR2(30);
502:
503: CURSOR cost_factor_cur (p_cf_code VARCHAR2) IS
504: SELECT *
505: FROM pon_price_element_types_vl
506: WHERE price_element_code = p_cf_code;
507:
508: l_cost_factor_type_rec cost_factor_cur%ROWTYPE;
509: