APPS.CN_COMP_PLAN_PUB dependencies on CN_COMP_PLANS

Line 31: l_rc_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;

27: )
28: IS
29: l_api_name CONSTANT VARCHAR2 (30) := 'valid_pe_assign';
30: l_dummy NUMBER;
31: l_rc_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;
32: l_rev_class_total NUMBER := 0;
33: l_rev_class_total_unique NUMBER := 0;
34: l_quota_type_code cn_quotas.quota_type_code%TYPE;
35: l_quota_start_date DATE;

Line 87: FROM cn_comp_plans

83: -- Check if CP exist
84: BEGIN
85: SELECT comp_plan_id, allow_rev_class_overlap
86: INTO x_cp_id, l_rc_overlap
87: FROM cn_comp_plans
88: WHERE NAME = p_cp_name AND org_id = p_org_id;
89: EXCEPTION
90: WHEN NO_DATA_FOUND
91: THEN

Line 258: p_comp_plan_name IN cn_comp_plans.NAME%TYPE,

254: := fnd_api.g_valid_level_full,
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_comp_plan_name IN cn_comp_plans.NAME%TYPE,
259: p_comp_start_date IN DATE,
260: p_comp_end_date IN DATE,
261: p_plan_element_name IN cn_quotas.NAME%TYPE,
262: p_org_id IN cn_quotas.org_id%TYPE,

Line 322: -- Create comp plan into cn_comp_plans

318: THEN
319: RAISE fnd_api.g_exc_error;
320: ELSIF x_loading_status <> 'PLN_QUOTA_ASSIGNED'
321: THEN
322: -- Create comp plan into cn_comp_plans
323: cn_quota_assigns_pkg.begin_record
324: (x_operation => 'INSERT',
325: x_comp_plan_id => l_comp_plan_id,
326: x_quota_id => l_pe_id,

Line 414: FROM cn_comp_plans

410: CURSOR c_cp_csr
411: IS
412: SELECT NAME, description, start_date, end_date, status_code,
413: allow_rev_class_overlap
414: FROM cn_comp_plans
415: WHERE NAME = p_cp_rec.NAME
416: AND org_id = p_cp_rec.org_id;
417:
418:

Line 634: FROM cn_comp_plans

630: -- check for start/end period range
631: BEGIN
632: SELECT 'CP_EXIST'
633: INTO x_loading_status
634: FROM cn_comp_plans
635: WHERE NAME = p_cp_rec.NAME
636: AND org_id = p_cp_rec.org_id;
637: EXCEPTION
638: WHEN NO_DATA_FOUND

Line 744: l_status_code cn_comp_plans.status_code%TYPE;

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;
748: l_bind_data_id NUMBER;

Line 957: -- Create comp plan into cn_comp_plans

953: THEN
954: RAISE fnd_api.g_exc_error;
955: ELSIF x_loading_status <> 'CP_EXIST'
956: THEN
957: -- Create comp plan into cn_comp_plans
958: cn_comp_plans_pkg.begin_record
959: (x_operation => 'INSERT',
960: x_rowid => g_rowid,
961: x_comp_plan_id => x_comp_plan_id,

Line 958: cn_comp_plans_pkg.begin_record

954: RAISE fnd_api.g_exc_error;
955: ELSIF x_loading_status <> 'CP_EXIST'
956: THEN
957: -- Create comp plan into cn_comp_plans
958: cn_comp_plans_pkg.begin_record
959: (x_operation => 'INSERT',
960: x_rowid => g_rowid,
961: x_comp_plan_id => x_comp_plan_id,
962: x_name => l_cp_rec.NAME,

Line 1010: p_source_object_code => 'CN_COMP_PLANS',

1006: x_return_status => x_return_status,
1007: x_msg_count => x_msg_count,
1008: x_msg_data => x_msg_data,
1009: p_source_object_id => x_comp_plan_id,
1010: p_source_object_code => 'CN_COMP_PLANS',
1011: p_notes => l_note_msg,
1012: p_notes_detail => l_note_msg,
1013: p_note_type => 'CN_SYSGEN', -- for system generated
1014: x_jtf_note_id => l_note_id -- returned

Line 1020: FROM cn_comp_plans

1016: ELSE
1017: -- Comp plan already exist, get comp_plan_id ,status_code
1018: SELECT comp_plan_id, status_code
1019: INTO x_comp_plan_id, l_status_code
1020: FROM cn_comp_plans
1021: WHERE NAME = l_cp_rec.NAME
1022: AND org_id = l_cp_rec.org_id;
1023: END IF;
1024:

Line 1074: cn_comp_plans_pkg.set_status (x_comp_plan_id => x_comp_plan_id,

1070: AND (l_cp_rec.plan_element_name IS NOT NULL)
1071: )
1072: OR ((l_new_cp_flag = 'N') AND (l_status_code = 'COMPLETE'))
1073: THEN
1074: cn_comp_plans_pkg.set_status (x_comp_plan_id => x_comp_plan_id,
1075: x_quota_id => NULL,
1076: x_rate_schedule_id => NULL,
1077: x_status_code => 'COMPLETE',
1078: x_event => NULL