APPS.CN_COMP_PLAN_PUB dependencies on CN_PERIODS

Line 548: l_start_date cn_periods.start_date%TYPE;

544: x_loading_status OUT NOCOPY VARCHAR2
545: )
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

Line 549: l_end_date cn_periods.end_date%TYPE;

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

Line 742: l_start_date cn_periods.start_date%TYPE;

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;
745: l_new_cp_flag VARCHAR2 (1) := 'N';
746: l_p_comp_plan_rec comp_plan_rec_type;

Line 743: l_end_date cn_periods.start_date%TYPE;

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;
745: l_new_cp_flag VARCHAR2 (1) := 'N';
746: l_p_comp_plan_rec comp_plan_rec_type;
747: l_oai_array jtf_usr_hks.oai_data_array_type;