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_API

Line 60: l_lkup_meaning := cn_api.get_lkup_meaning('RATE_SCHEDULE_NAME','PE_OBJECT_TYPE');

56:
57:
58: -- Check Rate Schedule Name is not null
59:
60: l_lkup_meaning := cn_api.get_lkup_meaning('RATE_SCHEDULE_NAME','PE_OBJECT_TYPE');
61: IF ( (cn_api.chk_null_char_para
62: (p_char_para => p_rt_quota_asgns_rec.rate_schedule_name,
63: p_obj_name => l_lkup_meaning,
64: p_loading_status => x_loading_status,

Line 61: IF ( (cn_api.chk_null_char_para

57:
58: -- Check Rate Schedule Name is not null
59:
60: l_lkup_meaning := cn_api.get_lkup_meaning('RATE_SCHEDULE_NAME','PE_OBJECT_TYPE');
61: IF ( (cn_api.chk_null_char_para
62: (p_char_para => p_rt_quota_asgns_rec.rate_schedule_name,
63: p_obj_name => l_lkup_meaning,
64: p_loading_status => x_loading_status,
65: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN

Line 72: l_lkup_meaning := cn_api.get_lkup_meaning('RATE_START_DATE','PE_OBJECT_TYPE');

68:
69:
70: -- Check Start Date is not null
71:
72: l_lkup_meaning := cn_api.get_lkup_meaning('RATE_START_DATE','PE_OBJECT_TYPE');
73: IF ( (cn_api.chk_null_char_para
74: (p_char_para => p_rt_quota_asgns_rec.start_date,
75: p_obj_name => l_lkup_meaning,
76: p_loading_status => x_loading_status,

Line 73: IF ( (cn_api.chk_null_char_para

69:
70: -- Check Start Date is not null
71:
72: l_lkup_meaning := cn_api.get_lkup_meaning('RATE_START_DATE','PE_OBJECT_TYPE');
73: IF ( (cn_api.chk_null_char_para
74: (p_char_para => p_rt_quota_asgns_rec.start_date,
75: p_obj_name => l_lkup_meaning,
76: p_loading_status => x_loading_status,
77: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN

Line 85: := cn_api.get_rate_table_id(p_rt_quota_asgns_rec.rate_schedule_name,p_rt_quota_asgns_rec.org_id);

81:
82: -- get rate Schedule ID, raise an error if rate schedule id not found.
83:
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);

Line 122: p_rt_quota_asgns_rec.start_date_old <> cn_api.g_miss_date) OR

118: -- get the rt_quota Asgns ID if any one of the old value is not null
119: -- for Update only
120: -- clku, 8/27/2001, If condition enhanced to fix bug 1951983
121: IF ( (p_rt_quota_asgns_rec.start_date_old IS NOT NULL AND
122: p_rt_quota_asgns_rec.start_date_old <> cn_api.g_miss_date) OR
123: (p_rt_quota_asgns_rec.end_date_old IS NOT NULL AND
124: p_rt_quota_asgns_rec.end_date_old <> cn_api.g_miss_date) OR
125: (p_rt_quota_asgns_rec.rate_schedule_name_old IS NOT NULL AND
126: p_rt_quota_asgns_rec.rate_schedule_name_old <> cn_api.g_miss_char)) THEN

Line 124: p_rt_quota_asgns_rec.end_date_old <> cn_api.g_miss_date) OR

120: -- clku, 8/27/2001, If condition enhanced to fix bug 1951983
121: IF ( (p_rt_quota_asgns_rec.start_date_old IS NOT NULL AND
122: p_rt_quota_asgns_rec.start_date_old <> cn_api.g_miss_date) OR
123: (p_rt_quota_asgns_rec.end_date_old IS NOT NULL AND
124: p_rt_quota_asgns_rec.end_date_old <> cn_api.g_miss_date) OR
125: (p_rt_quota_asgns_rec.rate_schedule_name_old IS NOT NULL AND
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.

Line 126: p_rt_quota_asgns_rec.rate_schedule_name_old <> cn_api.g_miss_char)) THEN

122: p_rt_quota_asgns_rec.start_date_old <> cn_api.g_miss_date) OR
123: (p_rt_quota_asgns_rec.end_date_old IS NOT NULL AND
124: p_rt_quota_asgns_rec.end_date_old <> cn_api.g_miss_date) OR
125: (p_rt_quota_asgns_rec.rate_schedule_name_old IS NOT NULL AND
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

Line 132: p_rate_schedule_id => cn_api.get_rate_table_id

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,
135: p_start_date => p_rt_quota_asgns_rec.start_date_old,
136: p_end_date => p_rt_quota_asgns_rec.end_date_old

Line 315: IF ( (cn_api.chk_miss_char_para

311:
312: IF p_rt_quota_asgns_rec_tbl.COUNT > 0 THEN
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

Line 321: ELSIF ( (cn_api.chk_null_char_para

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
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

Line 610: IF ( (cn_api.chk_miss_char_para

606:
607: IF p_rt_quota_asgns_rec_tbl.COUNT > 0 THEN
608:
609: -- check quota name is missing or null, mandatory
610: IF ( (cn_api.chk_miss_char_para
611: ( p_char_para => p_quota_name,
612: p_para_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,
613: p_loading_status => x_loading_status,
614: x_loading_status => l_loading_status)) = FND_API.G_TRUE) THEN

Line 616: ELSIF ( (cn_api.chk_null_char_para

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

Line 892: IF ( (cn_api.chk_miss_char_para

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

Line 898: ELSIF ( (cn_api.chk_null_char_para

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

Line 935: p_rate_schedule_id => cn_api.get_rate_table_id(

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