eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_RT_QUOTA_ASGNS_PVT dependencies on CN_CHK_PLAN_ELEMENT_PKG

Line 88: := cn_chk_plan_element_pkg.get_calc_formula_id(

84: x_rate_schedule_id
85: := cn_api.get_rate_table_id(p_rt_quota_asgns_rec.rate_schedule_name,p_rt_quota_asgns_rec.org_id);
86:
87: l_calc_formula_id
88: := cn_chk_plan_element_pkg.get_calc_formula_id(
89: p_rt_quota_asgns_rec.calc_formula_name,p_org_id);
90: x_calc_formula_id := l_calc_formula_id;
91:
92: -- Raise an error, if rate schedule id is null, not exists in the database

Line 130: x_rt_quota_asgn_id := cn_chk_plan_element_pkg.get_rt_quota_asgn_id

126: p_rt_quota_asgns_rec.rate_schedule_name_old <> cn_api.g_miss_char)) THEN
127:
128: -- Get the rt_quota_asgn_id to Update the exact record.
129:
130: x_rt_quota_asgn_id := cn_chk_plan_element_pkg.get_rt_quota_asgn_id
131: (p_quota_id => p_quota_id,
132: p_rate_schedule_id => cn_api.get_rate_table_id
133: (p_rt_quota_asgns_rec.rate_schedule_name_old,p_rt_quota_asgns_rec.org_id),
134: p_calc_formula_id => l_calc_formula_id,

Line 179: cn_chk_plan_element_pkg.chk_date_effective

175:
176: -- Check date Effetcivity, quota rate assigns start date and end must
177: -- be with start date and end date of the quota date
178:
179: cn_chk_plan_element_pkg.chk_date_effective
180: (
181: x_return_status => x_return_status,
182: p_start_date => p_rt_quota_asgns_rec.start_date,
183: p_end_date => p_rt_quota_asgns_rec.end_date,

Line 193: IF Nvl(cn_chk_plan_element_pkg.get_quota_type ( p_quota_id ),'NONE') = 'NONE' THEN

189: x_loading_status := l_loading_status;
190:
191: -- check quota type, if quota type is NONE you cannot have rates
192:
193: IF Nvl(cn_chk_plan_element_pkg.get_quota_type ( p_quota_id ),'NONE') = 'NONE' THEN
194: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
195: THEN
196: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_CANNOT_HAVE_RATE' );
197: FND_MSG_PUB.Add;

Line 317: p_para_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,

313:
314: -- check quota name is missing or null, mandatory
315: IF ( (cn_api.chk_miss_char_para
316: ( p_char_para => p_quota_name,
317: p_para_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,
318: p_loading_status => x_loading_status,
319: x_loading_status => l_loading_status)) = FND_API.G_TRUE) THEN
320: RAISE FND_API.G_EXC_ERROR ;
321: ELSIF ( (cn_api.chk_null_char_para

Line 323: p_obj_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,

319: x_loading_status => l_loading_status)) = FND_API.G_TRUE) THEN
320: RAISE FND_API.G_EXC_ERROR ;
321: ELSIF ( (cn_api.chk_null_char_para
322: (p_char_para => p_quota_name,
323: p_obj_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,
324: p_loading_status => x_loading_status,
325: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
326: RAISE FND_API.G_EXC_ERROR ;
327: END IF;

Line 332: l_quota_id := cn_chk_plan_element_pkg.get_quota_id(p_quota_name,p_org_id);

328:
329:
330: -- get Quota ID
331:
332: l_quota_id := cn_chk_plan_element_pkg.get_quota_id(p_quota_name,p_org_id);
333:
334:
335: -- if Quota id is null and name is not null then raise an error
336:

Line 461: cn_chk_plan_element_pkg.chk_rate_quota_iud

457:
458:
459: -- Check the sequence and overlap of the start date and the end date
460:
461: cn_chk_plan_element_pkg.chk_rate_quota_iud
462: (
463: x_return_status => x_return_status,
464: p_start_Date => l_rate_date_seq_rec_tbl(i).start_date,
465: p_end_date => l_rate_date_seq_rec_tbl(i).end_date,

Line 611: p_para_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,

607:
608: -- check quota name is missing or null, mandatory
609: IF ( (cn_api.chk_miss_char_para
610: ( p_char_para => p_quota_name,
611: p_para_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,
612: p_loading_status => x_loading_status,
613: x_loading_status => l_loading_status)) = FND_API.G_TRUE) THEN
614: RAISE FND_API.G_EXC_ERROR ;
615: ELSIF ( (cn_api.chk_null_char_para

Line 617: p_obj_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,

613: x_loading_status => l_loading_status)) = FND_API.G_TRUE) THEN
614: RAISE FND_API.G_EXC_ERROR ;
615: ELSIF ( (cn_api.chk_null_char_para
616: (p_char_para => p_quota_name,
617: p_obj_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,
618: p_loading_status => x_loading_status,
619: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
620: RAISE FND_API.G_EXC_ERROR ;
621: END IF;

Line 623: l_quota_id := cn_chk_plan_element_pkg.get_quota_id(p_quota_name,p_org_id);

619: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
620: RAISE FND_API.G_EXC_ERROR ;
621: END IF;
622:
623: l_quota_id := cn_chk_plan_element_pkg.get_quota_id(p_quota_name,p_org_id);
624:
625: -- get Quota id, if id is null and name is not null then raise an error
626:
627: IF (p_quota_name IS NOT NULL

Line 741: cn_chk_plan_element_pkg.chk_rate_quota_iud

737:
738:
739: -- Check the sequence and overlap of the start date and the end date
740:
741: cn_chk_plan_element_pkg.chk_rate_quota_iud
742: (
743: x_return_status => x_return_status,
744: p_start_Date => l_rate_date_seq_rec_tbl(i).start_date,
745: p_end_date => l_rate_date_seq_rec_tbl(i).end_date,

Line 892: p_para_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,

888: -- check quota name is missing or null, mandatory
889:
890: IF ( (cn_api.chk_miss_char_para
891: ( p_char_para => p_quota_name,
892: p_para_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,
893: p_loading_status => x_loading_status,
894: x_loading_status => l_loading_status)) = FND_API.G_TRUE) THEN
895: RAISE FND_API.G_EXC_ERROR ;
896: ELSIF ( (cn_api.chk_null_char_para

Line 898: p_obj_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,

894: x_loading_status => l_loading_status)) = FND_API.G_TRUE) THEN
895: RAISE FND_API.G_EXC_ERROR ;
896: ELSIF ( (cn_api.chk_null_char_para
897: (p_char_para => p_quota_name,
898: p_obj_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,
899: p_loading_status => x_loading_status,
900: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
901: RAISE FND_API.G_EXC_ERROR ;
902: END IF;

Line 904: l_quota_id := cn_chk_plan_element_pkg.get_quota_id(p_quota_name,p_org_id);

900: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
901: RAISE FND_API.G_EXC_ERROR ;
902: END IF;
903:
904: l_quota_id := cn_chk_plan_element_pkg.get_quota_id(p_quota_name,p_org_id);
905:
906: -- get Quota id, if id is null and name is not null then raise an error
907:
908: IF (p_quota_name IS NOT NULL

Line 930: l_rt_quota_asgn_id := cn_chk_plan_element_pkg.get_rt_quota_asgn_id

926: LOOP
927:
928: -- get rt quota Assign ID to delete the record
929:
930: l_rt_quota_asgn_id := cn_chk_plan_element_pkg.get_rt_quota_asgn_id
931: (
932: p_quota_id => l_quota_id,
933: p_rate_schedule_id => cn_api.get_rate_table_id(
934: p_rt_quota_asgns_rec_tbl(i).rate_schedule_name,p_rt_quota_asgns_rec_tbl(i).org_id),

Line 935: p_calc_formula_id => cn_chk_plan_element_pkg.get_calc_formula_id(

931: (
932: p_quota_id => l_quota_id,
933: p_rate_schedule_id => cn_api.get_rate_table_id(
934: p_rt_quota_asgns_rec_tbl(i).rate_schedule_name,p_rt_quota_asgns_rec_tbl(i).org_id),
935: p_calc_formula_id => cn_chk_plan_element_pkg.get_calc_formula_id(
936: p_rt_quota_asgns_rec_tbl(i).calc_formula_name,p_org_id),
937: p_start_date => p_rt_quota_asgns_rec_tbl(i).start_date,
938: p_end_date => p_rt_quota_asgns_rec_tbl(i).end_date
939: );

Line 958: cn_chk_plan_element_pkg.chk_rate_quota_iud

954: END IF;
955:
956: -- Check wheather delete is Allowed, this only first and last record can be deleted
957:
958: cn_chk_plan_element_pkg.chk_rate_quota_iud
959: (
960: x_return_status => x_return_status,
961: p_start_Date => p_rt_quota_asgns_rec_tbl(i).start_date,
962: p_end_date => p_rt_quota_asgns_rec_tbl(i).end_date,

Line 965: p_calc_formula_id => cn_chk_plan_element_pkg.get_calc_formula_id(

961: p_start_Date => p_rt_quota_asgns_rec_tbl(i).start_date,
962: p_end_date => p_rt_quota_asgns_rec_tbl(i).end_date,
963: p_iud_flag => 'D',
964: p_quota_id => l_quota_id,
965: p_calc_formula_id => cn_chk_plan_element_pkg.get_calc_formula_id(
966: p_rt_quota_asgns_rec_tbl(i).calc_formula_name,p_org_id),
967: p_rt_quota_asgn_id => l_rt_quota_asgn_id,
968: p_loading_status => x_loading_status,
969: x_loading_status => l_loading_status