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 609: IF ( (cn_api.chk_miss_char_para

605:
606: IF p_rt_quota_asgns_rec_tbl.COUNT > 0 THEN
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

Line 615: ELSIF ( (cn_api.chk_null_char_para

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

Line 890: IF ( (cn_api.chk_miss_char_para

886: IF p_rt_quota_asgns_rec_tbl.COUNT > 0 THEN
887:
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

Line 896: ELSIF ( (cn_api.chk_null_char_para

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

Line 933: p_rate_schedule_id => cn_api.get_rate_table_id(

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