APPS.CN_COMP_PLAN_PUB dependencies on CN_LOOKUPS

Line 268: l_lk_meaning cn_lookups.meaning%TYPE;

264: )
265: IS
266: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Plan_Element_Assign';
267: l_api_version CONSTANT NUMBER := 1.0;
268: l_lk_meaning cn_lookups.meaning%TYPE;
269: l_comp_plan_id cn_quota_assigns.comp_plan_id%TYPE;
270: l_pe_id cn_quota_assigns.quota_id%TYPE;
271: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
272: l_loading_status VARCHAR2 (1000);

Line 420: l_lkup_meaning cn_lookups.meaning%TYPE;

416: AND org_id = p_cp_rec.org_id;
417:
418:
419: l_cp_csr c_cp_csr%ROWTYPE;
420: l_lkup_meaning cn_lookups.meaning%TYPE;
421: BEGIN
422: x_return_status := fnd_api.g_ret_sts_success;
423: x_loading_status := p_loading_status;
424:

Line 550: l_lkup_meaning cn_lookups.meaning%TYPE;

546: IS
547: l_api_name CONSTANT VARCHAR2 (30) := 'valid_comp_plan';
548: l_start_date cn_periods.start_date%TYPE;
549: l_end_date cn_periods.end_date%TYPE;
550: l_lkup_meaning cn_lookups.meaning%TYPE;
551: l_loading_status VARCHAR2 (30);
552: BEGIN
553: -- Initialize API return status to success
554: x_return_status := fnd_api.g_ret_sts_success;

Line 740: l_lk_meaning cn_lookups.meaning%TYPE;

736: IS
737: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Comp_Plan';
738: l_api_version CONSTANT NUMBER := 1.0;
739: l_cp_rec comp_plan_rec_type := g_miss_comp_plan_rec;
740: l_lk_meaning cn_lookups.meaning%TYPE;
741: l_index NUMBER;
742: l_start_date cn_periods.start_date%TYPE;
743: l_end_date cn_periods.start_date%TYPE;
744: l_status_code cn_comp_plans.status_code%TYPE;

Line 891: FROM cn_lookups

887: FROM SYS.DUAL;
888:
889: -- Set status_code lookup code = INCOMPLETE
890: /* SELECT lookup_code INTO l_cp_rec.status
891: FROM cn_lookups
892: WHERE lookup_type = 'PLAN_OBJECT_STATUS'
893: AND Upper(meaning) = 'INCOMPLETE'; */
894: l_cp_rec.status := 'INCOMPLETE';
895: