APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_LOOKUPS

Line 29: FROM cn_lookups

25:
26: -- Check/Valid quota_type_code
27: SELECT COUNT (*)
28: INTO l_tmp_exist
29: FROM cn_lookups
30: WHERE lookup_type = 'PAYMENT_GROUP_CODE' AND lookup_code = p_payment_group_code;
31:
32: IF (l_tmp_exist = 0)
33: THEN

Line 157: l_element_type cn_lookups.meaning%TYPE;

153: x_rt_sched_custom_flag OUT NOCOPY VARCHAR2,
154: x_addup_from_rev_class_flag OUT NOCOPY VARCHAR2
155: )
156: IS
157: l_element_type cn_lookups.meaning%TYPE;
158: l_incentive_type cn_lookups.meaning%TYPE;
159: l_flag VARCHAR2 (10);
160: BEGIN
161: -- Trim code, remove all blank spaces at begin/end of the string

Line 158: l_incentive_type cn_lookups.meaning%TYPE;

154: x_addup_from_rev_class_flag OUT NOCOPY VARCHAR2
155: )
156: IS
157: l_element_type cn_lookups.meaning%TYPE;
158: l_incentive_type cn_lookups.meaning%TYPE;
159: l_flag VARCHAR2 (10);
160: BEGIN
161: -- Trim code, remove all blank spaces at begin/end of the string
162: -- Assign NULL value if code = FND_API.G_MISS_CHAR

Line 170: FROM cn_lookups

166: -- Convert x_quota_type_code
167: BEGIN
168: SELECT lookup_code
169: INTO x_quota_type_code
170: FROM cn_lookups
171: WHERE lookup_type = 'QUOTA_TYPE' AND UPPER (meaning) = UPPER (l_element_type);
172: EXCEPTION
173: WHEN NO_DATA_FOUND
174: THEN

Line 187: FROM cn_lookups

183: -- Convert x_incentive_type_code
184: BEGIN
185: SELECT lookup_code
186: INTO x_incentive_type_code
187: FROM cn_lookups
188: WHERE lookup_type = 'INCENTIVE_TYPE' AND UPPER (meaning) = UPPER (l_incentive_type);
189: EXCEPTION
190: WHEN NO_DATA_FOUND
191: THEN

Line 782: --| code is valid in cn_lookups or not null/not missing but not checking

778:
779: -- -------------------------------------------------------------------------+-+
780: --| Procedure : valid_lookup_code
781: --| Description : Valid lookup code for plan element. Just make sure the lookup
782: --| code is valid in cn_lookups or not null/not missing but not checking
783: --| correct setting for different plan element type
784: -- -------------------------------------------------------------------------+-+
785: PROCEDURE valid_lookup_code (
786: x_return_status OUT NOCOPY VARCHAR2,

Line 802: FROM cn_lookups

798:
799: -- Check/Valid quota_type_code
800: SELECT COUNT (*)
801: INTO l_tmp_exist
802: FROM cn_lookups
803: WHERE lookup_type = 'QUOTA_TYPE' AND lookup_code = p_pe_rec.quota_type_code;
804:
805: IF (l_tmp_exist = 0)
806: THEN

Line 821: FROM cn_lookups

817:
818: -- Check/Valid Incentive Type
819: SELECT COUNT (*)
820: INTO l_tmp_exist
821: FROM cn_lookups
822: WHERE lookup_type = 'INCENTIVE_TYPE' AND lookup_code = p_pe_rec.incentive_type_code;
823:
824: IF (l_tmp_exist = 0)
825: THEN

Line 1364: l_meaning cn_lookups.meaning%TYPE;

1360: l_api_name CONSTANT VARCHAR2 (30) := 'Trx_Factors';
1361: l_trx_factor_rec_tbl trx_factor_rec_tbl_type;
1362: l_rev_class_id NUMBER;
1363: l_quota_rule_id NUMBER;
1364: l_meaning cn_lookups.meaning%TYPE;
1365: l_loading_status VARCHAR2 (80);
1366: BEGIN
1367: -- Set Status
1368: x_return_status := fnd_api.g_ret_sts_success;

Line 2031: l_meaning cn_lookups.meaning%TYPE;

2027: l_trx_factor_rec_tbl trx_factor_rec_tbl_type;
2028: l_quota_rule_id cn_quota_rules.quota_rule_id%TYPE;
2029: l_per_quota_id cn_period_quotas.period_quota_id%TYPE;
2030: l_tmp NUMBER;
2031: l_meaning cn_lookups.meaning%TYPE;
2032: l_p_plan_element_rec plan_element_rec_type;
2033: l_p_revenue_class_rec_tbl revenue_class_rec_tbl_type;
2034: l_p_rev_uplift_rec_tbl rev_uplift_rec_tbl_type;
2035: