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 FND_API

Line 16: ( employee_number cn_salesreps.employee_number%TYPE := FND_API.G_MISS_CHAR,

12:
13: -- Comments for datatype, global constant or variables
14:
15: TYPE salesrep_rec_type IS RECORD
16: ( employee_number cn_salesreps.employee_number%TYPE := FND_API.G_MISS_CHAR,
17: type cn_salesreps.type%TYPE := FND_API.G_MISS_CHAR,
18: hierarchy_flag cn_calc_submission_entries.hierarchy_flag%TYPE := 'N'
19: );
20:

Line 17: type cn_salesreps.type%TYPE := FND_API.G_MISS_CHAR,

13: -- Comments for datatype, global constant or variables
14:
15: TYPE salesrep_rec_type IS RECORD
16: ( employee_number cn_salesreps.employee_number%TYPE := FND_API.G_MISS_CHAR,
17: type cn_salesreps.type%TYPE := FND_API.G_MISS_CHAR,
18: hierarchy_flag cn_calc_submission_entries.hierarchy_flag%TYPE := 'N'
19: );
20:
21:

Line 29: ( user_name fnd_user.user_name%TYPE := FND_API.G_MISS_CHAR,

25: TYPE plan_element_tbl_type IS TABLE OF cn_quotas.name%TYPE
26: INDEX BY BINARY_INTEGER;
27:
28: TYPE app_user_resp_rec_type IS RECORD
29: ( user_name fnd_user.user_name%TYPE := FND_API.G_MISS_CHAR,
30: responsibility_name fnd_responsibility_vl.responsibility_name%TYPE := FND_API.G_MISS_CHAR
31: );
32:
33: g_miss_app_user_resp_rec app_user_resp_rec_type;

Line 30: responsibility_name fnd_responsibility_vl.responsibility_name%TYPE := FND_API.G_MISS_CHAR

26: INDEX BY BINARY_INTEGER;
27:
28: TYPE app_user_resp_rec_type IS RECORD
29: ( user_name fnd_user.user_name%TYPE := FND_API.G_MISS_CHAR,
30: responsibility_name fnd_responsibility_vl.responsibility_name%TYPE := FND_API.G_MISS_CHAR
31: );
32:
33: g_miss_app_user_resp_rec app_user_resp_rec_type;
34: g_miss_salesrep_tbl salesrep_tbl_type;

Line 39: ( batch_name cn_calc_submission_batches.name%TYPE := FND_API.G_MISS_CHAR,

35: g_miss_pe_tbl plan_element_tbl_type;
36:
37: -- calc submission batch record type
38: TYPE calc_submission_rec_type IS RECORD
39: ( batch_name cn_calc_submission_batches.name%TYPE := FND_API.G_MISS_CHAR,
40: start_date cn_calc_submission_batches.start_date%TYPE := FND_API.G_MISS_DATE,
41: end_date cn_calc_submission_batches.end_date%TYPE := FND_API.G_MISS_DATE,
42: calculation_type cn_calc_submission_batches.calc_type%TYPE := FND_API.G_MISS_CHAR,
43: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE := FND_API.G_MISS_CHAR,

Line 40: start_date cn_calc_submission_batches.start_date%TYPE := FND_API.G_MISS_DATE,

36:
37: -- calc submission batch record type
38: TYPE calc_submission_rec_type IS RECORD
39: ( batch_name cn_calc_submission_batches.name%TYPE := FND_API.G_MISS_CHAR,
40: start_date cn_calc_submission_batches.start_date%TYPE := FND_API.G_MISS_DATE,
41: end_date cn_calc_submission_batches.end_date%TYPE := FND_API.G_MISS_DATE,
42: calculation_type cn_calc_submission_batches.calc_type%TYPE := FND_API.G_MISS_CHAR,
43: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE := FND_API.G_MISS_CHAR,
44: entire_hierarchy cn_calc_submission_batches.hierarchy_flag%TYPE := FND_API.G_MISS_CHAR,

Line 41: end_date cn_calc_submission_batches.end_date%TYPE := FND_API.G_MISS_DATE,

37: -- calc submission batch record type
38: TYPE calc_submission_rec_type IS RECORD
39: ( batch_name cn_calc_submission_batches.name%TYPE := FND_API.G_MISS_CHAR,
40: start_date cn_calc_submission_batches.start_date%TYPE := FND_API.G_MISS_DATE,
41: end_date cn_calc_submission_batches.end_date%TYPE := FND_API.G_MISS_DATE,
42: calculation_type cn_calc_submission_batches.calc_type%TYPE := FND_API.G_MISS_CHAR,
43: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE := FND_API.G_MISS_CHAR,
44: entire_hierarchy cn_calc_submission_batches.hierarchy_flag%TYPE := FND_API.G_MISS_CHAR,
45: concurrent_calculation cn_calc_submission_batches.concurrent_flag%TYPE := FND_API.G_MISS_CHAR,

Line 42: calculation_type cn_calc_submission_batches.calc_type%TYPE := FND_API.G_MISS_CHAR,

38: TYPE calc_submission_rec_type IS RECORD
39: ( batch_name cn_calc_submission_batches.name%TYPE := FND_API.G_MISS_CHAR,
40: start_date cn_calc_submission_batches.start_date%TYPE := FND_API.G_MISS_DATE,
41: end_date cn_calc_submission_batches.end_date%TYPE := FND_API.G_MISS_DATE,
42: calculation_type cn_calc_submission_batches.calc_type%TYPE := FND_API.G_MISS_CHAR,
43: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE := FND_API.G_MISS_CHAR,
44: entire_hierarchy cn_calc_submission_batches.hierarchy_flag%TYPE := FND_API.G_MISS_CHAR,
45: concurrent_calculation cn_calc_submission_batches.concurrent_flag%TYPE := FND_API.G_MISS_CHAR,
46: incremental_calculation cn_calc_submission_batches.intelligent_flag%TYPE := FND_API.G_MISS_CHAR,

Line 43: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE := FND_API.G_MISS_CHAR,

39: ( batch_name cn_calc_submission_batches.name%TYPE := FND_API.G_MISS_CHAR,
40: start_date cn_calc_submission_batches.start_date%TYPE := FND_API.G_MISS_DATE,
41: end_date cn_calc_submission_batches.end_date%TYPE := FND_API.G_MISS_DATE,
42: calculation_type cn_calc_submission_batches.calc_type%TYPE := FND_API.G_MISS_CHAR,
43: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE := FND_API.G_MISS_CHAR,
44: entire_hierarchy cn_calc_submission_batches.hierarchy_flag%TYPE := FND_API.G_MISS_CHAR,
45: concurrent_calculation cn_calc_submission_batches.concurrent_flag%TYPE := FND_API.G_MISS_CHAR,
46: incremental_calculation cn_calc_submission_batches.intelligent_flag%TYPE := FND_API.G_MISS_CHAR,
47: interval_type cn_interval_types.name%type := FND_API.G_MISS_CHAR,

Line 44: entire_hierarchy cn_calc_submission_batches.hierarchy_flag%TYPE := FND_API.G_MISS_CHAR,

40: start_date cn_calc_submission_batches.start_date%TYPE := FND_API.G_MISS_DATE,
41: end_date cn_calc_submission_batches.end_date%TYPE := FND_API.G_MISS_DATE,
42: calculation_type cn_calc_submission_batches.calc_type%TYPE := FND_API.G_MISS_CHAR,
43: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE := FND_API.G_MISS_CHAR,
44: entire_hierarchy cn_calc_submission_batches.hierarchy_flag%TYPE := FND_API.G_MISS_CHAR,
45: concurrent_calculation cn_calc_submission_batches.concurrent_flag%TYPE := FND_API.G_MISS_CHAR,
46: incremental_calculation cn_calc_submission_batches.intelligent_flag%TYPE := FND_API.G_MISS_CHAR,
47: interval_type cn_interval_types.name%type := FND_API.G_MISS_CHAR,
48: org_id cn_calc_submission_batches.org_id%TYPE := NULL,

Line 45: concurrent_calculation cn_calc_submission_batches.concurrent_flag%TYPE := FND_API.G_MISS_CHAR,

41: end_date cn_calc_submission_batches.end_date%TYPE := FND_API.G_MISS_DATE,
42: calculation_type cn_calc_submission_batches.calc_type%TYPE := FND_API.G_MISS_CHAR,
43: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE := FND_API.G_MISS_CHAR,
44: entire_hierarchy cn_calc_submission_batches.hierarchy_flag%TYPE := FND_API.G_MISS_CHAR,
45: concurrent_calculation cn_calc_submission_batches.concurrent_flag%TYPE := FND_API.G_MISS_CHAR,
46: incremental_calculation cn_calc_submission_batches.intelligent_flag%TYPE := FND_API.G_MISS_CHAR,
47: interval_type cn_interval_types.name%type := FND_API.G_MISS_CHAR,
48: org_id cn_calc_submission_batches.org_id%TYPE := NULL,
49: attribute_category cn_comp_plans.attribute_category%TYPE := FND_API.G_MISS_CHAR,

Line 46: incremental_calculation cn_calc_submission_batches.intelligent_flag%TYPE := FND_API.G_MISS_CHAR,

42: calculation_type cn_calc_submission_batches.calc_type%TYPE := FND_API.G_MISS_CHAR,
43: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE := FND_API.G_MISS_CHAR,
44: entire_hierarchy cn_calc_submission_batches.hierarchy_flag%TYPE := FND_API.G_MISS_CHAR,
45: concurrent_calculation cn_calc_submission_batches.concurrent_flag%TYPE := FND_API.G_MISS_CHAR,
46: incremental_calculation cn_calc_submission_batches.intelligent_flag%TYPE := FND_API.G_MISS_CHAR,
47: interval_type cn_interval_types.name%type := FND_API.G_MISS_CHAR,
48: org_id cn_calc_submission_batches.org_id%TYPE := NULL,
49: attribute_category cn_comp_plans.attribute_category%TYPE := FND_API.G_MISS_CHAR,
50: attribute1 cn_comp_plans.attribute1%TYPE := FND_API.G_MISS_CHAR,

Line 47: interval_type cn_interval_types.name%type := FND_API.G_MISS_CHAR,

43: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE := FND_API.G_MISS_CHAR,
44: entire_hierarchy cn_calc_submission_batches.hierarchy_flag%TYPE := FND_API.G_MISS_CHAR,
45: concurrent_calculation cn_calc_submission_batches.concurrent_flag%TYPE := FND_API.G_MISS_CHAR,
46: incremental_calculation cn_calc_submission_batches.intelligent_flag%TYPE := FND_API.G_MISS_CHAR,
47: interval_type cn_interval_types.name%type := FND_API.G_MISS_CHAR,
48: org_id cn_calc_submission_batches.org_id%TYPE := NULL,
49: attribute_category cn_comp_plans.attribute_category%TYPE := FND_API.G_MISS_CHAR,
50: attribute1 cn_comp_plans.attribute1%TYPE := FND_API.G_MISS_CHAR,
51: attribute2 cn_comp_plans.attribute2%TYPE := FND_API.G_MISS_CHAR,

Line 49: attribute_category cn_comp_plans.attribute_category%TYPE := FND_API.G_MISS_CHAR,

45: concurrent_calculation cn_calc_submission_batches.concurrent_flag%TYPE := FND_API.G_MISS_CHAR,
46: incremental_calculation cn_calc_submission_batches.intelligent_flag%TYPE := FND_API.G_MISS_CHAR,
47: interval_type cn_interval_types.name%type := FND_API.G_MISS_CHAR,
48: org_id cn_calc_submission_batches.org_id%TYPE := NULL,
49: attribute_category cn_comp_plans.attribute_category%TYPE := FND_API.G_MISS_CHAR,
50: attribute1 cn_comp_plans.attribute1%TYPE := FND_API.G_MISS_CHAR,
51: attribute2 cn_comp_plans.attribute2%TYPE := FND_API.G_MISS_CHAR,
52: attribute3 cn_comp_plans.attribute3%TYPE := FND_API.G_MISS_CHAR,
53: attribute4 cn_comp_plans.attribute4%TYPE := FND_API.G_MISS_CHAR,

Line 50: attribute1 cn_comp_plans.attribute1%TYPE := FND_API.G_MISS_CHAR,

46: incremental_calculation cn_calc_submission_batches.intelligent_flag%TYPE := FND_API.G_MISS_CHAR,
47: interval_type cn_interval_types.name%type := FND_API.G_MISS_CHAR,
48: org_id cn_calc_submission_batches.org_id%TYPE := NULL,
49: attribute_category cn_comp_plans.attribute_category%TYPE := FND_API.G_MISS_CHAR,
50: attribute1 cn_comp_plans.attribute1%TYPE := FND_API.G_MISS_CHAR,
51: attribute2 cn_comp_plans.attribute2%TYPE := FND_API.G_MISS_CHAR,
52: attribute3 cn_comp_plans.attribute3%TYPE := FND_API.G_MISS_CHAR,
53: attribute4 cn_comp_plans.attribute4%TYPE := FND_API.G_MISS_CHAR,
54: attribute5 cn_comp_plans.attribute5%TYPE := FND_API.G_MISS_CHAR,

Line 51: attribute2 cn_comp_plans.attribute2%TYPE := FND_API.G_MISS_CHAR,

47: interval_type cn_interval_types.name%type := FND_API.G_MISS_CHAR,
48: org_id cn_calc_submission_batches.org_id%TYPE := NULL,
49: attribute_category cn_comp_plans.attribute_category%TYPE := FND_API.G_MISS_CHAR,
50: attribute1 cn_comp_plans.attribute1%TYPE := FND_API.G_MISS_CHAR,
51: attribute2 cn_comp_plans.attribute2%TYPE := FND_API.G_MISS_CHAR,
52: attribute3 cn_comp_plans.attribute3%TYPE := FND_API.G_MISS_CHAR,
53: attribute4 cn_comp_plans.attribute4%TYPE := FND_API.G_MISS_CHAR,
54: attribute5 cn_comp_plans.attribute5%TYPE := FND_API.G_MISS_CHAR,
55: attribute6 cn_comp_plans.attribute6%TYPE := FND_API.G_MISS_CHAR,

Line 52: attribute3 cn_comp_plans.attribute3%TYPE := FND_API.G_MISS_CHAR,

48: org_id cn_calc_submission_batches.org_id%TYPE := NULL,
49: attribute_category cn_comp_plans.attribute_category%TYPE := FND_API.G_MISS_CHAR,
50: attribute1 cn_comp_plans.attribute1%TYPE := FND_API.G_MISS_CHAR,
51: attribute2 cn_comp_plans.attribute2%TYPE := FND_API.G_MISS_CHAR,
52: attribute3 cn_comp_plans.attribute3%TYPE := FND_API.G_MISS_CHAR,
53: attribute4 cn_comp_plans.attribute4%TYPE := FND_API.G_MISS_CHAR,
54: attribute5 cn_comp_plans.attribute5%TYPE := FND_API.G_MISS_CHAR,
55: attribute6 cn_comp_plans.attribute6%TYPE := FND_API.G_MISS_CHAR,
56: attribute7 cn_comp_plans.attribute7%TYPE := FND_API.G_MISS_CHAR,

Line 53: attribute4 cn_comp_plans.attribute4%TYPE := FND_API.G_MISS_CHAR,

49: attribute_category cn_comp_plans.attribute_category%TYPE := FND_API.G_MISS_CHAR,
50: attribute1 cn_comp_plans.attribute1%TYPE := FND_API.G_MISS_CHAR,
51: attribute2 cn_comp_plans.attribute2%TYPE := FND_API.G_MISS_CHAR,
52: attribute3 cn_comp_plans.attribute3%TYPE := FND_API.G_MISS_CHAR,
53: attribute4 cn_comp_plans.attribute4%TYPE := FND_API.G_MISS_CHAR,
54: attribute5 cn_comp_plans.attribute5%TYPE := FND_API.G_MISS_CHAR,
55: attribute6 cn_comp_plans.attribute6%TYPE := FND_API.G_MISS_CHAR,
56: attribute7 cn_comp_plans.attribute7%TYPE := FND_API.G_MISS_CHAR,
57: attribute8 cn_comp_plans.attribute8%TYPE := FND_API.G_MISS_CHAR,

Line 54: attribute5 cn_comp_plans.attribute5%TYPE := FND_API.G_MISS_CHAR,

50: attribute1 cn_comp_plans.attribute1%TYPE := FND_API.G_MISS_CHAR,
51: attribute2 cn_comp_plans.attribute2%TYPE := FND_API.G_MISS_CHAR,
52: attribute3 cn_comp_plans.attribute3%TYPE := FND_API.G_MISS_CHAR,
53: attribute4 cn_comp_plans.attribute4%TYPE := FND_API.G_MISS_CHAR,
54: attribute5 cn_comp_plans.attribute5%TYPE := FND_API.G_MISS_CHAR,
55: attribute6 cn_comp_plans.attribute6%TYPE := FND_API.G_MISS_CHAR,
56: attribute7 cn_comp_plans.attribute7%TYPE := FND_API.G_MISS_CHAR,
57: attribute8 cn_comp_plans.attribute8%TYPE := FND_API.G_MISS_CHAR,
58: attribute9 cn_comp_plans.attribute9%TYPE := FND_API.G_MISS_CHAR,

Line 55: attribute6 cn_comp_plans.attribute6%TYPE := FND_API.G_MISS_CHAR,

51: attribute2 cn_comp_plans.attribute2%TYPE := FND_API.G_MISS_CHAR,
52: attribute3 cn_comp_plans.attribute3%TYPE := FND_API.G_MISS_CHAR,
53: attribute4 cn_comp_plans.attribute4%TYPE := FND_API.G_MISS_CHAR,
54: attribute5 cn_comp_plans.attribute5%TYPE := FND_API.G_MISS_CHAR,
55: attribute6 cn_comp_plans.attribute6%TYPE := FND_API.G_MISS_CHAR,
56: attribute7 cn_comp_plans.attribute7%TYPE := FND_API.G_MISS_CHAR,
57: attribute8 cn_comp_plans.attribute8%TYPE := FND_API.G_MISS_CHAR,
58: attribute9 cn_comp_plans.attribute9%TYPE := FND_API.G_MISS_CHAR,
59: attribute10 cn_comp_plans.attribute10%TYPE := FND_API.G_MISS_CHAR,

Line 56: attribute7 cn_comp_plans.attribute7%TYPE := FND_API.G_MISS_CHAR,

52: attribute3 cn_comp_plans.attribute3%TYPE := FND_API.G_MISS_CHAR,
53: attribute4 cn_comp_plans.attribute4%TYPE := FND_API.G_MISS_CHAR,
54: attribute5 cn_comp_plans.attribute5%TYPE := FND_API.G_MISS_CHAR,
55: attribute6 cn_comp_plans.attribute6%TYPE := FND_API.G_MISS_CHAR,
56: attribute7 cn_comp_plans.attribute7%TYPE := FND_API.G_MISS_CHAR,
57: attribute8 cn_comp_plans.attribute8%TYPE := FND_API.G_MISS_CHAR,
58: attribute9 cn_comp_plans.attribute9%TYPE := FND_API.G_MISS_CHAR,
59: attribute10 cn_comp_plans.attribute10%TYPE := FND_API.G_MISS_CHAR,
60: attribute11 cn_comp_plans.attribute11%TYPE := FND_API.G_MISS_CHAR,

Line 57: attribute8 cn_comp_plans.attribute8%TYPE := FND_API.G_MISS_CHAR,

53: attribute4 cn_comp_plans.attribute4%TYPE := FND_API.G_MISS_CHAR,
54: attribute5 cn_comp_plans.attribute5%TYPE := FND_API.G_MISS_CHAR,
55: attribute6 cn_comp_plans.attribute6%TYPE := FND_API.G_MISS_CHAR,
56: attribute7 cn_comp_plans.attribute7%TYPE := FND_API.G_MISS_CHAR,
57: attribute8 cn_comp_plans.attribute8%TYPE := FND_API.G_MISS_CHAR,
58: attribute9 cn_comp_plans.attribute9%TYPE := FND_API.G_MISS_CHAR,
59: attribute10 cn_comp_plans.attribute10%TYPE := FND_API.G_MISS_CHAR,
60: attribute11 cn_comp_plans.attribute11%TYPE := FND_API.G_MISS_CHAR,
61: attribute12 cn_comp_plans.attribute12%TYPE := FND_API.G_MISS_CHAR,

Line 58: attribute9 cn_comp_plans.attribute9%TYPE := FND_API.G_MISS_CHAR,

54: attribute5 cn_comp_plans.attribute5%TYPE := FND_API.G_MISS_CHAR,
55: attribute6 cn_comp_plans.attribute6%TYPE := FND_API.G_MISS_CHAR,
56: attribute7 cn_comp_plans.attribute7%TYPE := FND_API.G_MISS_CHAR,
57: attribute8 cn_comp_plans.attribute8%TYPE := FND_API.G_MISS_CHAR,
58: attribute9 cn_comp_plans.attribute9%TYPE := FND_API.G_MISS_CHAR,
59: attribute10 cn_comp_plans.attribute10%TYPE := FND_API.G_MISS_CHAR,
60: attribute11 cn_comp_plans.attribute11%TYPE := FND_API.G_MISS_CHAR,
61: attribute12 cn_comp_plans.attribute12%TYPE := FND_API.G_MISS_CHAR,
62: attribute13 cn_comp_plans.attribute13%TYPE := FND_API.G_MISS_CHAR,

Line 59: attribute10 cn_comp_plans.attribute10%TYPE := FND_API.G_MISS_CHAR,

55: attribute6 cn_comp_plans.attribute6%TYPE := FND_API.G_MISS_CHAR,
56: attribute7 cn_comp_plans.attribute7%TYPE := FND_API.G_MISS_CHAR,
57: attribute8 cn_comp_plans.attribute8%TYPE := FND_API.G_MISS_CHAR,
58: attribute9 cn_comp_plans.attribute9%TYPE := FND_API.G_MISS_CHAR,
59: attribute10 cn_comp_plans.attribute10%TYPE := FND_API.G_MISS_CHAR,
60: attribute11 cn_comp_plans.attribute11%TYPE := FND_API.G_MISS_CHAR,
61: attribute12 cn_comp_plans.attribute12%TYPE := FND_API.G_MISS_CHAR,
62: attribute13 cn_comp_plans.attribute13%TYPE := FND_API.G_MISS_CHAR,
63: attribute14 cn_comp_plans.attribute14%TYPE := FND_API.G_MISS_CHAR,

Line 60: attribute11 cn_comp_plans.attribute11%TYPE := FND_API.G_MISS_CHAR,

56: attribute7 cn_comp_plans.attribute7%TYPE := FND_API.G_MISS_CHAR,
57: attribute8 cn_comp_plans.attribute8%TYPE := FND_API.G_MISS_CHAR,
58: attribute9 cn_comp_plans.attribute9%TYPE := FND_API.G_MISS_CHAR,
59: attribute10 cn_comp_plans.attribute10%TYPE := FND_API.G_MISS_CHAR,
60: attribute11 cn_comp_plans.attribute11%TYPE := FND_API.G_MISS_CHAR,
61: attribute12 cn_comp_plans.attribute12%TYPE := FND_API.G_MISS_CHAR,
62: attribute13 cn_comp_plans.attribute13%TYPE := FND_API.G_MISS_CHAR,
63: attribute14 cn_comp_plans.attribute14%TYPE := FND_API.G_MISS_CHAR,
64: attribute15 cn_comp_plans.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 61: attribute12 cn_comp_plans.attribute12%TYPE := FND_API.G_MISS_CHAR,

57: attribute8 cn_comp_plans.attribute8%TYPE := FND_API.G_MISS_CHAR,
58: attribute9 cn_comp_plans.attribute9%TYPE := FND_API.G_MISS_CHAR,
59: attribute10 cn_comp_plans.attribute10%TYPE := FND_API.G_MISS_CHAR,
60: attribute11 cn_comp_plans.attribute11%TYPE := FND_API.G_MISS_CHAR,
61: attribute12 cn_comp_plans.attribute12%TYPE := FND_API.G_MISS_CHAR,
62: attribute13 cn_comp_plans.attribute13%TYPE := FND_API.G_MISS_CHAR,
63: attribute14 cn_comp_plans.attribute14%TYPE := FND_API.G_MISS_CHAR,
64: attribute15 cn_comp_plans.attribute15%TYPE := FND_API.G_MISS_CHAR
65: );

Line 62: attribute13 cn_comp_plans.attribute13%TYPE := FND_API.G_MISS_CHAR,

58: attribute9 cn_comp_plans.attribute9%TYPE := FND_API.G_MISS_CHAR,
59: attribute10 cn_comp_plans.attribute10%TYPE := FND_API.G_MISS_CHAR,
60: attribute11 cn_comp_plans.attribute11%TYPE := FND_API.G_MISS_CHAR,
61: attribute12 cn_comp_plans.attribute12%TYPE := FND_API.G_MISS_CHAR,
62: attribute13 cn_comp_plans.attribute13%TYPE := FND_API.G_MISS_CHAR,
63: attribute14 cn_comp_plans.attribute14%TYPE := FND_API.G_MISS_CHAR,
64: attribute15 cn_comp_plans.attribute15%TYPE := FND_API.G_MISS_CHAR
65: );
66:

Line 63: attribute14 cn_comp_plans.attribute14%TYPE := FND_API.G_MISS_CHAR,

59: attribute10 cn_comp_plans.attribute10%TYPE := FND_API.G_MISS_CHAR,
60: attribute11 cn_comp_plans.attribute11%TYPE := FND_API.G_MISS_CHAR,
61: attribute12 cn_comp_plans.attribute12%TYPE := FND_API.G_MISS_CHAR,
62: attribute13 cn_comp_plans.attribute13%TYPE := FND_API.G_MISS_CHAR,
63: attribute14 cn_comp_plans.attribute14%TYPE := FND_API.G_MISS_CHAR,
64: attribute15 cn_comp_plans.attribute15%TYPE := FND_API.G_MISS_CHAR
65: );
66:
67: -- Global variable that represent missing values.

Line 64: attribute15 cn_comp_plans.attribute15%TYPE := FND_API.G_MISS_CHAR

60: attribute11 cn_comp_plans.attribute11%TYPE := FND_API.G_MISS_CHAR,
61: attribute12 cn_comp_plans.attribute12%TYPE := FND_API.G_MISS_CHAR,
62: attribute13 cn_comp_plans.attribute13%TYPE := FND_API.G_MISS_CHAR,
63: attribute14 cn_comp_plans.attribute14%TYPE := FND_API.G_MISS_CHAR,
64: attribute15 cn_comp_plans.attribute15%TYPE := FND_API.G_MISS_CHAR
65: );
66:
67: -- Global variable that represent missing values.
68: g_miss_calc_submission_rec calc_submission_rec_type;

Line 82: -- Default = FND_API.G_FALSE

78: -- salesreps/ passed_in bonus plan elements
79: -- Parameters :
80: -- IN : p_api_version IN NUMBER Require
81: -- p_init_msg_list IN VARCHAR2 Optional
82: -- Default = FND_API.G_FALSE
83: -- p_commit IN VARCHAR2 Optional
84: -- Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional
86: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 84: -- Default = FND_API.G_FALSE

80: -- IN : p_api_version IN NUMBER Require
81: -- p_init_msg_list IN VARCHAR2 Optional
82: -- Default = FND_API.G_FALSE
83: -- p_commit IN VARCHAR2 Optional
84: -- Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional
86: -- Default = FND_API.G_VALID_LEVEL_FULL
87: -- OUT : x_return_status OUT VARCHAR2(1)
88: -- x_msg_count OUT NUMBER

Line 86: -- Default = FND_API.G_VALID_LEVEL_FULL

82: -- Default = FND_API.G_FALSE
83: -- p_commit IN VARCHAR2 Optional
84: -- Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional
86: -- Default = FND_API.G_VALID_LEVEL_FULL
87: -- OUT : x_return_status OUT VARCHAR2(1)
88: -- x_msg_count OUT NUMBER
89: -- x_msg_data OUT VARCHAR2(2000)
90: -- IN : p_calc_submission_rec IN calc_submission_rec_type

Line 155: -- IF p_commit is not fnd_api.g_true, then the calculation will not be submitted even if all

151: -- type can be any of 'PERIOD'/'QUARTER'/'YEAR'
152: --
153: --
154: -- Special Notes:
155: -- IF p_commit is not fnd_api.g_true, then the calculation will not be submitted even if all
156: -- the validations are successful.
157: --
158: ------------------------+
159: -- End of comments

Line 165: * @param p_commit Commit flag (default F). If p_commit is not fnd_api.g_true, then the calculation will not be submitted even if all of the validations are successful.

161: /*#
162: * This procedure creates a new calculation submission batch with the given specifications.
163: * @param p_api_version API version
164: * @param p_init_msg_list Initialize message list (default F)
165: * @param p_commit Commit flag (default F). If p_commit is not fnd_api.g_true, then the calculation will not be submitted even if all of the validations are successful.
166: * @param p_validation_level Validation level (default Full)
167: * @param x_return_status Return status
168: * @param x_msg_count Number of messages returned
169: * @param x_msg_data Contents of message if x_msg_count = 1

Line 185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

181:
182: PROCEDURE Create_Calc_Submission
183: (
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,

Line 186: p_commit IN VARCHAR2 := FND_API.G_FALSE,

182: PROCEDURE Create_Calc_Submission
183: (
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,

Line 187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

183: (
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_calc_submission_rec IN calc_submission_rec_type := g_miss_calc_submission_rec,

Line 210: -- Default = FND_API.G_FALSE

206: -- salesreps/ passed_in bonus plan elements
207: -- Parameters :
208: -- IN : p_api_version IN NUMBER Require
209: -- p_init_msg_list IN VARCHAR2 Optional
210: -- Default = FND_API.G_FALSE
211: -- p_commit IN VARCHAR2 Optional
212: -- Default = FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Optional
214: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 212: -- Default = FND_API.G_FALSE

208: -- IN : p_api_version IN NUMBER Require
209: -- p_init_msg_list IN VARCHAR2 Optional
210: -- Default = FND_API.G_FALSE
211: -- p_commit IN VARCHAR2 Optional
212: -- Default = FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Optional
214: -- Default = FND_API.G_VALID_LEVEL_FULL
215: -- OUT : x_return_status OUT VARCHAR2(1)
216: -- x_msg_count OUT NUMBER

Line 214: -- Default = FND_API.G_VALID_LEVEL_FULL

210: -- Default = FND_API.G_FALSE
211: -- p_commit IN VARCHAR2 Optional
212: -- Default = FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Optional
214: -- Default = FND_API.G_VALID_LEVEL_FULL
215: -- OUT : x_return_status OUT VARCHAR2(1)
216: -- x_msg_count OUT NUMBER
217: -- x_msg_data OUT VARCHAR2(2000)
218: -- IN : p_calc_submission_rec IN calc_submission_rec_type

Line 269: -- IF p_commit is not fnd_api.g_true, then the calculation will not be submitted even if all

265: -- if the plan element already exists or there are duplicates in p_bonus_pe_tbl,
266: -- give out a message without failing the call
267: --
268: -- Special Notes:
269: -- IF p_commit is not fnd_api.g_true, then the calculation will not be submitted even if all
270: -- the validations are successful.
271: --
272: --
273: -- End of comments

Line 281: * @param p_commit Commit flag (default F). If p_commit is not fnd_api.g_true, then the calculation will not be submitted even if all of the validations are successful.

277: /*#
278: * This procedure updates a calculation submission batch with the given specifications.
279: * @param p_api_version API version
280: * @param p_init_msg_list Initialize message list (default F)
281: * @param p_commit Commit flag (default F). If p_commit is not fnd_api.g_true, then the calculation will not be submitted even if all of the validations are successful.
282: * @param p_validation_level Validation level (default 100)
283: * @param x_return_status Return status
284: * @param x_msg_count Number of messages returned
285: * @param x_msg_data Contents of message if x_msg_count = 1

Line 305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

301: */
302: PROCEDURE Update_Calc_Submission
303: (
304: p_api_version IN NUMBER,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,

Line 306: p_commit IN VARCHAR2 := FND_API.G_FALSE,

302: PROCEDURE Update_Calc_Submission
303: (
304: p_api_version IN NUMBER,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,

Line 307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

303: (
304: p_api_version IN NUMBER,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,
311: p_calc_submission_rec_old IN calc_submission_rec_type := g_miss_calc_submission_rec,