APPS.PON_CF_TYPE_GRP dependencies on PON_PRICE_ELEMENT_TYPES_VL

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 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 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: