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 938: -- Create comp plan into cn_comp_plans

934: THEN
935: RAISE fnd_api.g_exc_error;
936: ELSIF x_loading_status <> 'CP_EXIST'
937: THEN
938: -- Create comp plan into cn_comp_plans
939: cn_comp_plans_pkg.begin_record
940: (x_operation => 'INSERT',
941: x_rowid => g_rowid,
942: x_comp_plan_id => x_comp_plan_id,

Line 939: cn_comp_plans_pkg.begin_record

935: RAISE fnd_api.g_exc_error;
936: ELSIF x_loading_status <> 'CP_EXIST'
937: THEN
938: -- Create comp plan into cn_comp_plans
939: cn_comp_plans_pkg.begin_record
940: (x_operation => 'INSERT',
941: x_rowid => g_rowid,
942: x_comp_plan_id => x_comp_plan_id,
943: x_name => l_cp_rec.NAME,

Line 990: p_source_object_code => 'CN_COMP_PLANS',

986: x_return_status => x_return_status,
987: x_msg_count => x_msg_count,
988: x_msg_data => x_msg_data,
989: p_source_object_id => x_comp_plan_id,
990: p_source_object_code => 'CN_COMP_PLANS',
991: p_notes => l_note_msg,
992: p_notes_detail => l_note_msg,
993: p_note_type => 'CN_SYSGEN', -- for system generated
994: x_jtf_note_id => l_note_id -- returned

Line 1000: FROM cn_comp_plans

996: ELSE
997: -- Comp plan already exist, get comp_plan_id ,status_code
998: SELECT comp_plan_id, status_code
999: INTO x_comp_plan_id, l_status_code
1000: FROM cn_comp_plans
1001: WHERE NAME = l_cp_rec.NAME
1002: AND org_id = l_cp_rec.org_id;
1003: END IF;
1004:

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

1050: AND (l_cp_rec.plan_element_name IS NOT NULL)
1051: )
1052: OR ((l_new_cp_flag = 'N') AND (l_status_code = 'COMPLETE'))
1053: THEN
1054: cn_comp_plans_pkg.set_status (x_comp_plan_id => x_comp_plan_id,
1055: x_quota_id => NULL,
1056: x_rate_schedule_id => NULL,
1057: x_status_code => 'COMPLETE',
1058: x_event => NULL