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_CALC_SUBMISSION_PUB dependencies on CN_API

Line 16: := cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE');

12:
13: g_org_id NUMBER;
14:
15: g_calc_sub_name CONSTANT VARCHAR2(80)
16: := cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE');
17: g_calc_sub_start_date CONSTANT VARCHAR2(80)
18: := cn_api.get_lkup_meaning('START_DATE', 'CALC_SUBMISSION_OBJECT_TYPE');
19: g_calc_sub_end_date CONSTANT VARCHAR2(80)
20: := cn_api.get_lkup_meaning('END_DATE', 'CALC_SUBMISSION_OBJECT_TYPE');

Line 18: := cn_api.get_lkup_meaning('START_DATE', 'CALC_SUBMISSION_OBJECT_TYPE');

14:
15: g_calc_sub_name CONSTANT VARCHAR2(80)
16: := cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE');
17: g_calc_sub_start_date CONSTANT VARCHAR2(80)
18: := cn_api.get_lkup_meaning('START_DATE', 'CALC_SUBMISSION_OBJECT_TYPE');
19: g_calc_sub_end_date CONSTANT VARCHAR2(80)
20: := cn_api.get_lkup_meaning('END_DATE', 'CALC_SUBMISSION_OBJECT_TYPE');
21: g_calc_sub_calc_type CONSTANT VARCHAR2(80)
22: := cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');

Line 20: := cn_api.get_lkup_meaning('END_DATE', 'CALC_SUBMISSION_OBJECT_TYPE');

16: := cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE');
17: g_calc_sub_start_date CONSTANT VARCHAR2(80)
18: := cn_api.get_lkup_meaning('START_DATE', 'CALC_SUBMISSION_OBJECT_TYPE');
19: g_calc_sub_end_date CONSTANT VARCHAR2(80)
20: := cn_api.get_lkup_meaning('END_DATE', 'CALC_SUBMISSION_OBJECT_TYPE');
21: g_calc_sub_calc_type CONSTANT VARCHAR2(80)
22: := cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');
23: g_calc_sub_salesrep_option CONSTANT VARCHAR2(80)
24: := cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE');

Line 22: := cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');

18: := cn_api.get_lkup_meaning('START_DATE', 'CALC_SUBMISSION_OBJECT_TYPE');
19: g_calc_sub_end_date CONSTANT VARCHAR2(80)
20: := cn_api.get_lkup_meaning('END_DATE', 'CALC_SUBMISSION_OBJECT_TYPE');
21: g_calc_sub_calc_type CONSTANT VARCHAR2(80)
22: := cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');
23: g_calc_sub_salesrep_option CONSTANT VARCHAR2(80)
24: := cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE');
25: g_calc_sub_hierarchy_flag CONSTANT VARCHAR2(80)
26: := cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');

Line 24: := cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE');

20: := cn_api.get_lkup_meaning('END_DATE', 'CALC_SUBMISSION_OBJECT_TYPE');
21: g_calc_sub_calc_type CONSTANT VARCHAR2(80)
22: := cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');
23: g_calc_sub_salesrep_option CONSTANT VARCHAR2(80)
24: := cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE');
25: g_calc_sub_hierarchy_flag CONSTANT VARCHAR2(80)
26: := cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');
27: g_calc_sub_concurrent_flag CONSTANT VARCHAR2(80)
28: := cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');

Line 26: := cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');

22: := cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');
23: g_calc_sub_salesrep_option CONSTANT VARCHAR2(80)
24: := cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE');
25: g_calc_sub_hierarchy_flag CONSTANT VARCHAR2(80)
26: := cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');
27: g_calc_sub_concurrent_flag CONSTANT VARCHAR2(80)
28: := cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');
29: g_calc_sub_intelligent_flag CONSTANT VARCHAR2(80)
30: := cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');

Line 28: := cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');

24: := cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE');
25: g_calc_sub_hierarchy_flag CONSTANT VARCHAR2(80)
26: := cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');
27: g_calc_sub_concurrent_flag CONSTANT VARCHAR2(80)
28: := cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');
29: g_calc_sub_intelligent_flag CONSTANT VARCHAR2(80)
30: := cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');
31: g_calc_sub_interval_type CONSTANT VARCHAR2(80)
32: := cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');

Line 30: := cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');

26: := cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');
27: g_calc_sub_concurrent_flag CONSTANT VARCHAR2(80)
28: := cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');
29: g_calc_sub_intelligent_flag CONSTANT VARCHAR2(80)
30: := cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');
31: g_calc_sub_interval_type CONSTANT VARCHAR2(80)
32: := cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');
33: g_calc_sub_emp_num CONSTANT VARCHAR2(80)
34: := cn_api.get_lkup_meaning('EMPLOYEE_NUMBER', 'CALC_SUBMISSION_OBJECT_TYPE');

Line 32: := cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');

28: := cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');
29: g_calc_sub_intelligent_flag CONSTANT VARCHAR2(80)
30: := cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');
31: g_calc_sub_interval_type CONSTANT VARCHAR2(80)
32: := cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');
33: g_calc_sub_emp_num CONSTANT VARCHAR2(80)
34: := cn_api.get_lkup_meaning('EMPLOYEE_NUMBER', 'CALC_SUBMISSION_OBJECT_TYPE');
35: g_calc_sub_emp_type CONSTANT VARCHAR2(80)
36: := cn_api.get_lkup_meaning('EMPLOYEE_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');

Line 34: := cn_api.get_lkup_meaning('EMPLOYEE_NUMBER', 'CALC_SUBMISSION_OBJECT_TYPE');

30: := cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE');
31: g_calc_sub_interval_type CONSTANT VARCHAR2(80)
32: := cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');
33: g_calc_sub_emp_num CONSTANT VARCHAR2(80)
34: := cn_api.get_lkup_meaning('EMPLOYEE_NUMBER', 'CALC_SUBMISSION_OBJECT_TYPE');
35: g_calc_sub_emp_type CONSTANT VARCHAR2(80)
36: := cn_api.get_lkup_meaning('EMPLOYEE_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');
37: g_calc_sub_user_name CONSTANT VARCHAR2(80)
38: := cn_api.get_lkup_meaning('USER_NAME', 'CALC_SUBMISSION_OBJECT_TYPE');

Line 36: := cn_api.get_lkup_meaning('EMPLOYEE_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');

32: := cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');
33: g_calc_sub_emp_num CONSTANT VARCHAR2(80)
34: := cn_api.get_lkup_meaning('EMPLOYEE_NUMBER', 'CALC_SUBMISSION_OBJECT_TYPE');
35: g_calc_sub_emp_type CONSTANT VARCHAR2(80)
36: := cn_api.get_lkup_meaning('EMPLOYEE_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');
37: g_calc_sub_user_name CONSTANT VARCHAR2(80)
38: := cn_api.get_lkup_meaning('USER_NAME', 'CALC_SUBMISSION_OBJECT_TYPE');
39: g_calc_sub_resp_name CONSTANT VARCHAR2(80)
40: := cn_api.get_lkup_meaning('RESPONSIBILITY_NAME', 'CALC_SUBMISSION_OBJECT_TYPE');

Line 38: := cn_api.get_lkup_meaning('USER_NAME', 'CALC_SUBMISSION_OBJECT_TYPE');

34: := cn_api.get_lkup_meaning('EMPLOYEE_NUMBER', 'CALC_SUBMISSION_OBJECT_TYPE');
35: g_calc_sub_emp_type CONSTANT VARCHAR2(80)
36: := cn_api.get_lkup_meaning('EMPLOYEE_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');
37: g_calc_sub_user_name CONSTANT VARCHAR2(80)
38: := cn_api.get_lkup_meaning('USER_NAME', 'CALC_SUBMISSION_OBJECT_TYPE');
39: g_calc_sub_resp_name CONSTANT VARCHAR2(80)
40: := cn_api.get_lkup_meaning('RESPONSIBILITY_NAME', 'CALC_SUBMISSION_OBJECT_TYPE');
41:
42: TYPE salesrep_id_tbl_type IS TABLE OF cn_salesreps.salesrep_id%TYPE

Line 40: := cn_api.get_lkup_meaning('RESPONSIBILITY_NAME', 'CALC_SUBMISSION_OBJECT_TYPE');

36: := cn_api.get_lkup_meaning('EMPLOYEE_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE');
37: g_calc_sub_user_name CONSTANT VARCHAR2(80)
38: := cn_api.get_lkup_meaning('USER_NAME', 'CALC_SUBMISSION_OBJECT_TYPE');
39: g_calc_sub_resp_name CONSTANT VARCHAR2(80)
40: := cn_api.get_lkup_meaning('RESPONSIBILITY_NAME', 'CALC_SUBMISSION_OBJECT_TYPE');
41:
42: TYPE salesrep_id_tbl_type IS TABLE OF cn_salesreps.salesrep_id%TYPE
43: INDEX BY BINARY_INTEGER;
44:

Line 99: IF (cn_api.chk_miss_null_char_para

95:
96: -- batch_name can not be missing or null
97: -- and should uniquely identify the batch
98: IF p_name_validate_flag = 'Y' THEN
99: IF (cn_api.chk_miss_null_char_para
100: (p_char_para => p_calc_submission_rec.batch_name,
101: p_obj_name => g_calc_sub_name,
102: p_loading_status => x_loading_status,
103: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

Line 134: IF ( (cn_api.invalid_date_range

130:
131: -- start_date can not be null/missing
132: -- end_date can not be null/missing
133: -- start_date < end_date
134: IF ( (cn_api.invalid_date_range
135: (p_start_date => p_calc_submission_rec.start_date,
136: p_end_date => p_calc_submission_rec.end_date,
137: p_end_date_nullable => FND_API.G_TRUE,
138: p_loading_status => x_loading_status,

Line 191: IF ( (cn_api.chk_miss_null_char_para

187: RAISE FND_API.G_EXC_ERROR ;
188: END IF;
189:
190: -- calculation_type can not be null/missing, must be valid value
191: IF ( (cn_api.chk_miss_null_char_para
192: (p_char_para => p_calc_submission_rec.calculation_type,
193: p_obj_name => g_calc_sub_calc_type,
194: p_loading_status => x_loading_status,
195: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN

Line 218: IF ( (cn_api.chk_miss_null_char_para

214: RAISE FND_API.G_EXC_ERROR ;
215: END IF;
216:
217: -- salesrep_option can not be null/missing, must be valid value
218: IF ( (cn_api.chk_miss_null_char_para
219: (p_char_para => p_calc_submission_rec.salesrep_option,
220: p_obj_name => g_calc_sub_salesrep_option,
221: p_loading_status => x_loading_status,
222: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN

Line 248: IF ( (cn_api.chk_miss_null_char_para

244: RAISE FND_API.G_EXC_ERROR ;
245: END IF;
246:
247: -- entire_hierarchy can not be null/missing, must be valid value
248: IF ( (cn_api.chk_miss_null_char_para
249: (p_char_para => p_calc_submission_rec.entire_hierarchy,
250: p_obj_name => g_calc_sub_hierarchy_flag,
251: p_loading_status => x_loading_status,
252: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN

Line 278: IF ( (cn_api.chk_miss_null_char_para

274: RAISE FND_API.G_EXC_ERROR ;
275: END IF;
276:
277: -- concurrent_calculation can not be null/missing, must be valid value
278: IF ( (cn_api.chk_miss_null_char_para
279: (p_char_para => p_calc_submission_rec.concurrent_calculation,
280: p_obj_name => g_calc_sub_concurrent_flag,
281: p_loading_status => x_loading_status,
282: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN

Line 305: IF ( (cn_api.chk_miss_null_char_para

301: RAISE FND_API.G_EXC_ERROR ;
302: END IF;
303:
304: -- incremental_calculation can not be null/missing , must be valid value
305: IF ( (cn_api.chk_miss_null_char_para
306: (p_char_para => p_calc_submission_rec.incremental_calculation,
307: p_obj_name => g_calc_sub_intelligent_flag,
308: p_loading_status => x_loading_status,
309: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN

Line 338: IF ( (cn_api.chk_miss_null_char_para

334: END IF;
335:
336: -- interval_type can not be null/missing, must be valid value if calc_type = 'BONUS'
337: IF p_calc_submission_rec.calculation_type = 'BONUS' THEN
338: IF ( (cn_api.chk_miss_null_char_para
339: (p_char_para => p_calc_submission_rec.interval_type,
340: p_obj_name => g_calc_sub_interval_type,
341: p_loading_status => x_loading_status,
342: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN

Line 437: IF (cn_api.chk_miss_char_para

433:
434: BEGIN
435:
436: -- emp_num can not be missing
437: IF (cn_api.chk_miss_char_para
438: (p_char_para => p_salesrep_rec.employee_number,
439: p_para_name => g_calc_sub_emp_num,
440: p_loading_status => x_loading_status,
441: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

Line 446: IF (cn_api.chk_miss_char_para

442: RETURN FALSE;
443: END IF;
444:
445: -- type can not be missing
446: IF (cn_api.chk_miss_char_para
447: (p_char_para => p_salesrep_rec.TYPE,
448: p_para_name => g_calc_sub_emp_type,
449: p_loading_status => x_loading_status,
450: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

Line 473: cn_api.chk_and_get_salesrep_id( p_emp_num => p_salesrep_rec.employee_number,

469: end if;
470:
471: -- (employee_number + type) must uniquely identify one salesrep
472: -- in cn_salesreps
473: cn_api.chk_and_get_salesrep_id( p_emp_num => p_salesrep_rec.employee_number,
474: p_type => p_salesrep_rec.TYPE,
475: p_org_id => g_org_id,
476: x_salesrep_id => l_salesrep_id,
477: x_return_status => l_return_status,

Line 806: IF ( (cn_api.chk_miss_null_char_para

802:
803: -- Start of API body
804:
805: -- user_name cannot be missing/null
806: IF ( (cn_api.chk_miss_null_char_para
807: (p_char_para => p_app_user_resp_rec.user_name,
808: p_obj_name => g_calc_sub_user_name,
809: p_loading_status => x_loading_status,
810: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN

Line 847: IF ( (cn_api.chk_miss_null_char_para

843: RAISE FND_API.G_EXC_ERROR ;
844: END;
845:
846: -- responsibility_name can not be missing/null
847: IF ( (cn_api.chk_miss_null_char_para
848: (p_char_para => p_app_user_resp_rec.responsibility_name,
849: p_obj_name => g_calc_sub_resp_name,
850: p_loading_status => x_loading_status,
851: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN

Line 1806: IF (cn_api.chk_miss_null_char_para

1802:
1803: -- validate the p_calc_submission_rec_old exists
1804: -- old batch_name can not be missing or null
1805: -- and should uniquely identify the batch
1806: IF (cn_api.chk_miss_null_char_para
1807: (p_char_para => p_calc_submission_rec_old.batch_name,
1808: p_obj_name => g_calc_sub_name,
1809: p_loading_status => x_loading_status,
1810: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN