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_PVT dependencies on CN_CALC_SUBMISSION_BATCHES

Line 7: (name cn_calc_submission_batches.name%TYPE,

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_CALC_SUBMISSION_PVT';
5:
6: TYPE sub_batch_rec_type IS RECORD
7: (name cn_calc_submission_batches.name%TYPE,
8: org_id cn_calc_submission_batches.org_id%TYPE,
9: calc_sub_batch_id cn_calc_submission_batches.calc_sub_batch_id%TYPE,
10: calc_type cn_calc_submission_batches.calc_type%TYPE,
11: start_date cn_calc_submission_batches.start_date%TYPE,

Line 8: org_id cn_calc_submission_batches.org_id%TYPE,

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_CALC_SUBMISSION_PVT';
5:
6: TYPE sub_batch_rec_type IS RECORD
7: (name cn_calc_submission_batches.name%TYPE,
8: org_id cn_calc_submission_batches.org_id%TYPE,
9: calc_sub_batch_id cn_calc_submission_batches.calc_sub_batch_id%TYPE,
10: calc_type cn_calc_submission_batches.calc_type%TYPE,
11: start_date cn_calc_submission_batches.start_date%TYPE,
12: end_date cn_calc_submission_batches.end_date%TYPE,

Line 9: calc_sub_batch_id cn_calc_submission_batches.calc_sub_batch_id%TYPE,

5:
6: TYPE sub_batch_rec_type IS RECORD
7: (name cn_calc_submission_batches.name%TYPE,
8: org_id cn_calc_submission_batches.org_id%TYPE,
9: calc_sub_batch_id cn_calc_submission_batches.calc_sub_batch_id%TYPE,
10: calc_type cn_calc_submission_batches.calc_type%TYPE,
11: start_date cn_calc_submission_batches.start_date%TYPE,
12: end_date cn_calc_submission_batches.end_date%TYPE,
13: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE,

Line 10: calc_type cn_calc_submission_batches.calc_type%TYPE,

6: TYPE sub_batch_rec_type IS RECORD
7: (name cn_calc_submission_batches.name%TYPE,
8: org_id cn_calc_submission_batches.org_id%TYPE,
9: calc_sub_batch_id cn_calc_submission_batches.calc_sub_batch_id%TYPE,
10: calc_type cn_calc_submission_batches.calc_type%TYPE,
11: start_date cn_calc_submission_batches.start_date%TYPE,
12: end_date cn_calc_submission_batches.end_date%TYPE,
13: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE,
14: hierarchy_flag cn_calc_submission_batches.hierarchy_flag%TYPE,

Line 11: start_date cn_calc_submission_batches.start_date%TYPE,

7: (name cn_calc_submission_batches.name%TYPE,
8: org_id cn_calc_submission_batches.org_id%TYPE,
9: calc_sub_batch_id cn_calc_submission_batches.calc_sub_batch_id%TYPE,
10: calc_type cn_calc_submission_batches.calc_type%TYPE,
11: start_date cn_calc_submission_batches.start_date%TYPE,
12: end_date cn_calc_submission_batches.end_date%TYPE,
13: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE,
14: hierarchy_flag cn_calc_submission_batches.hierarchy_flag%TYPE,
15: concurrent_flag cn_calc_submission_batches.concurrent_flag%TYPE,

Line 12: end_date cn_calc_submission_batches.end_date%TYPE,

8: org_id cn_calc_submission_batches.org_id%TYPE,
9: calc_sub_batch_id cn_calc_submission_batches.calc_sub_batch_id%TYPE,
10: calc_type cn_calc_submission_batches.calc_type%TYPE,
11: start_date cn_calc_submission_batches.start_date%TYPE,
12: end_date cn_calc_submission_batches.end_date%TYPE,
13: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE,
14: hierarchy_flag cn_calc_submission_batches.hierarchy_flag%TYPE,
15: concurrent_flag cn_calc_submission_batches.concurrent_flag%TYPE,
16: intelligent_flag cn_calc_submission_batches.intelligent_flag%TYPE,

Line 13: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE,

9: calc_sub_batch_id cn_calc_submission_batches.calc_sub_batch_id%TYPE,
10: calc_type cn_calc_submission_batches.calc_type%TYPE,
11: start_date cn_calc_submission_batches.start_date%TYPE,
12: end_date cn_calc_submission_batches.end_date%TYPE,
13: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE,
14: hierarchy_flag cn_calc_submission_batches.hierarchy_flag%TYPE,
15: concurrent_flag cn_calc_submission_batches.concurrent_flag%TYPE,
16: intelligent_flag cn_calc_submission_batches.intelligent_flag%TYPE,
17: status cn_calc_submission_batches.status%TYPE,

Line 14: hierarchy_flag cn_calc_submission_batches.hierarchy_flag%TYPE,

10: calc_type cn_calc_submission_batches.calc_type%TYPE,
11: start_date cn_calc_submission_batches.start_date%TYPE,
12: end_date cn_calc_submission_batches.end_date%TYPE,
13: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE,
14: hierarchy_flag cn_calc_submission_batches.hierarchy_flag%TYPE,
15: concurrent_flag cn_calc_submission_batches.concurrent_flag%TYPE,
16: intelligent_flag cn_calc_submission_batches.intelligent_flag%TYPE,
17: status cn_calc_submission_batches.status%TYPE,
18: interval_type_id cn_calc_submission_batches.interval_type_id%TYPE,

Line 15: concurrent_flag cn_calc_submission_batches.concurrent_flag%TYPE,

11: start_date cn_calc_submission_batches.start_date%TYPE,
12: end_date cn_calc_submission_batches.end_date%TYPE,
13: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE,
14: hierarchy_flag cn_calc_submission_batches.hierarchy_flag%TYPE,
15: concurrent_flag cn_calc_submission_batches.concurrent_flag%TYPE,
16: intelligent_flag cn_calc_submission_batches.intelligent_flag%TYPE,
17: status cn_calc_submission_batches.status%TYPE,
18: interval_type_id cn_calc_submission_batches.interval_type_id%TYPE,
19: process_audit_id cn_calc_submission_batches.process_audit_id%TYPE,

Line 16: intelligent_flag cn_calc_submission_batches.intelligent_flag%TYPE,

12: end_date cn_calc_submission_batches.end_date%TYPE,
13: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE,
14: hierarchy_flag cn_calc_submission_batches.hierarchy_flag%TYPE,
15: concurrent_flag cn_calc_submission_batches.concurrent_flag%TYPE,
16: intelligent_flag cn_calc_submission_batches.intelligent_flag%TYPE,
17: status cn_calc_submission_batches.status%TYPE,
18: interval_type_id cn_calc_submission_batches.interval_type_id%TYPE,
19: process_audit_id cn_calc_submission_batches.process_audit_id%TYPE,
20: object_version_number cn_calc_submission_batches.object_version_number%TYPE,

Line 17: status cn_calc_submission_batches.status%TYPE,

13: salesrep_option cn_calc_submission_batches.salesrep_option%TYPE,
14: hierarchy_flag cn_calc_submission_batches.hierarchy_flag%TYPE,
15: concurrent_flag cn_calc_submission_batches.concurrent_flag%TYPE,
16: intelligent_flag cn_calc_submission_batches.intelligent_flag%TYPE,
17: status cn_calc_submission_batches.status%TYPE,
18: interval_type_id cn_calc_submission_batches.interval_type_id%TYPE,
19: process_audit_id cn_calc_submission_batches.process_audit_id%TYPE,
20: object_version_number cn_calc_submission_batches.object_version_number%TYPE,
21: concurrent_request_id cn_process_audits.concurrent_request_id%TYPE);

Line 18: interval_type_id cn_calc_submission_batches.interval_type_id%TYPE,

14: hierarchy_flag cn_calc_submission_batches.hierarchy_flag%TYPE,
15: concurrent_flag cn_calc_submission_batches.concurrent_flag%TYPE,
16: intelligent_flag cn_calc_submission_batches.intelligent_flag%TYPE,
17: status cn_calc_submission_batches.status%TYPE,
18: interval_type_id cn_calc_submission_batches.interval_type_id%TYPE,
19: process_audit_id cn_calc_submission_batches.process_audit_id%TYPE,
20: object_version_number cn_calc_submission_batches.object_version_number%TYPE,
21: concurrent_request_id cn_process_audits.concurrent_request_id%TYPE);
22:

Line 19: process_audit_id cn_calc_submission_batches.process_audit_id%TYPE,

15: concurrent_flag cn_calc_submission_batches.concurrent_flag%TYPE,
16: intelligent_flag cn_calc_submission_batches.intelligent_flag%TYPE,
17: status cn_calc_submission_batches.status%TYPE,
18: interval_type_id cn_calc_submission_batches.interval_type_id%TYPE,
19: process_audit_id cn_calc_submission_batches.process_audit_id%TYPE,
20: object_version_number cn_calc_submission_batches.object_version_number%TYPE,
21: concurrent_request_id cn_process_audits.concurrent_request_id%TYPE);
22:
23: TYPE rep_entry_rec_type IS RECORD

Line 20: object_version_number cn_calc_submission_batches.object_version_number%TYPE,

16: intelligent_flag cn_calc_submission_batches.intelligent_flag%TYPE,
17: status cn_calc_submission_batches.status%TYPE,
18: interval_type_id cn_calc_submission_batches.interval_type_id%TYPE,
19: process_audit_id cn_calc_submission_batches.process_audit_id%TYPE,
20: object_version_number cn_calc_submission_batches.object_version_number%TYPE,
21: concurrent_request_id cn_process_audits.concurrent_request_id%TYPE);
22:
23: TYPE rep_entry_rec_type IS RECORD
24: (name jtf_rs_salesreps.name%TYPE,

Line 134: CURSOR name_check (p_batch_name cn_calc_submission_batches.name%TYPE ) IS

130: IS
131: l_dummy NUMBER;
132: l_quota_name cn_quotas.name%TYPE;
133:
134: CURSOR name_check (p_batch_name cn_calc_submission_batches.name%TYPE ) IS
135: SELECT 1
136: FROM cn_calc_submission_batches_all
137: WHERE name = p_batch_name
138: AND org_id = p_sub_batch_rec.org_id

Line 136: FROM cn_calc_submission_batches_all

132: l_quota_name cn_quotas.name%TYPE;
133:
134: CURSOR name_check (p_batch_name cn_calc_submission_batches.name%TYPE ) IS
135: SELECT 1
136: FROM cn_calc_submission_batches_all
137: WHERE name = p_batch_name
138: AND org_id = p_sub_batch_rec.org_id
139: AND (p_sub_batch_rec.calc_sub_batch_id IS NULL OR calc_sub_batch_id <> p_sub_batch_rec.calc_sub_batch_id);
140:

Line 714: (p_calc_sub_batch_id IN cn_calc_submission_batches.calc_sub_batch_id%TYPE,

710: END translate;
711:
712: -- get submission batch detail
713: PROCEDURE get_submission_batch
714: (p_calc_sub_batch_id IN cn_calc_submission_batches.calc_sub_batch_id%TYPE,
715: x_sub_batch_rec OUT NOCOPY sub_batch_rec_type,
716: x_rep_entry_tbl OUT NOCOPY rep_entry_tbl_type,
717: x_quota_entry_tbl OUT NOCOPY quota_entry_tbl_type,
718: x_interval_type_tbl OUT NOCOPY name_tbl_type)

Line 738: FROM cn_calc_submission_batches

734: interval_type_id,
735: process_audit_id,
736: object_version_number,
737: null
738: FROM cn_calc_submission_batches
739: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
740:
741: CURSOR reps IS
742: SELECT b.name, b.employee_number, a.salesrep_id, a.calc_sub_entry_id

Line 809: update cn_calc_submission_batches_all sb

805: -- This procedure should be invoked only when retrieving calculation batch records in response to a search request
806: -- from the calculation batch search page.
807: PROCEDURE maintain_batch_status IS
808: BEGIN
809: update cn_calc_submission_batches_all sb
810: set status = 'FAILED'
811: where status = 'PROCESSING'
812: and concurrent_flag = 'Y'
813: and exists (select 1

Line 837: p_calc_sub_batch_id IN cn_calc_submission_batches.calc_sub_batch_id%TYPE

833: p_validation_level IN NUMBER,
834: x_return_status OUT NOCOPY VARCHAR2,
835: x_msg_count OUT NOCOPY NUMBER,
836: x_msg_data OUT NOCOPY VARCHAR2,
837: p_calc_sub_batch_id IN cn_calc_submission_batches.calc_sub_batch_id%TYPE
838: )
839: IS
840: l_api_name CONSTANT VARCHAR2(30) := 'Validate';
841: l_api_version CONSTANT NUMBER := 1.0;

Line 965: p_calc_sub_batch_id IN cn_calc_submission_batches.calc_sub_batch_id%TYPE)

961: p_validation_level IN NUMBER,
962: x_return_status OUT NOCOPY VARCHAR2,
963: x_msg_count OUT NOCOPY NUMBER,
964: x_msg_data OUT NOCOPY VARCHAR2,
965: p_calc_sub_batch_id IN cn_calc_submission_batches.calc_sub_batch_id%TYPE)
966: IS
967: l_api_name CONSTANT VARCHAR2(30) := 'Calculate';
968: l_api_version CONSTANT NUMBER := 1.0;
969:

Line 1023: from cn_calc_submission_batches_all

1019: x_process_status_code => l_process_status_code);
1020:
1021: select concurrent_flag
1022: into l_concurrent_flag
1023: from cn_calc_submission_batches_all
1024: where calc_sub_batch_id = p_calc_sub_batch_id;
1025:
1026: IF (l_concurrent_flag = 'N') THEN
1027: IF nvl(l_process_status_code,'FAIL') = 'SUCCESS' THEN

Line 1087: p_calc_sub_batch_id IN cn_calc_submission_batches.calc_sub_batch_id%TYPE,

1083: p_validation_level IN NUMBER,
1084: x_return_status OUT NOCOPY VARCHAR2,
1085: x_msg_count OUT NOCOPY NUMBER,
1086: x_msg_data OUT NOCOPY VARCHAR2,
1087: p_calc_sub_batch_id IN cn_calc_submission_batches.calc_sub_batch_id%TYPE,
1088: p_out_calc_sub_batch_id OUT NOCOPY cn_calc_submission_batches.calc_sub_batch_id%TYPE)
1089: IS
1090: l_api_name CONSTANT VARCHAR2(30) := 'copybatch';
1091: l_api_version CONSTANT NUMBER := 1.0;

Line 1088: p_out_calc_sub_batch_id OUT NOCOPY cn_calc_submission_batches.calc_sub_batch_id%TYPE)

1084: x_return_status OUT NOCOPY VARCHAR2,
1085: x_msg_count OUT NOCOPY NUMBER,
1086: x_msg_data OUT NOCOPY VARCHAR2,
1087: p_calc_sub_batch_id IN cn_calc_submission_batches.calc_sub_batch_id%TYPE,
1088: p_out_calc_sub_batch_id OUT NOCOPY cn_calc_submission_batches.calc_sub_batch_id%TYPE)
1089: IS
1090: l_api_name CONSTANT VARCHAR2(30) := 'copybatch';
1091: l_api_version CONSTANT NUMBER := 1.0;
1092:

Line 1095: batch_record cn_calc_submission_batches%rowtype;

1091: l_api_version CONSTANT NUMBER := 1.0;
1092:
1093: seq_batchid NUMBER;
1094: dummy_char VARCHAR2(30);
1095: batch_record cn_calc_submission_batches%rowtype;
1096: batch_entries_record cn_calc_submission_entries%rowtype;
1097: batch_bonus_record cn_calc_sub_quotas%rowtype;
1098:
1099: temp_batch_name VARCHAR2(30);

Line 1100: dummy_batch cn_calc_submission_batches%rowtype;

1096: batch_entries_record cn_calc_submission_entries%rowtype;
1097: batch_bonus_record cn_calc_sub_quotas%rowtype;
1098:
1099: temp_batch_name VARCHAR2(30);
1100: dummy_batch cn_calc_submission_batches%rowtype;
1101: dup_name_counter NUMBER := 1;
1102: record_checker BOOLEAN := FALSE;
1103:
1104: cursor batch_cursor is

Line 1105: select * from cn_calc_submission_batches where calc_sub_batch_id = p_calc_sub_batch_id;

1101: dup_name_counter NUMBER := 1;
1102: record_checker BOOLEAN := FALSE;
1103:
1104: cursor batch_cursor is
1105: select * from cn_calc_submission_batches where calc_sub_batch_id = p_calc_sub_batch_id;
1106:
1107: cursor rep_cursor is
1108: select * from cn_calc_submission_entries where calc_sub_batch_id = p_calc_sub_batch_id;
1109:

Line 1113: cursor namecheck_cursor(p_batch_name_to_check cn_calc_submission_batches.name%TYPE) is

1109:
1110: cursor bonus_cursor is
1111: select * from cn_calc_sub_quotas where calc_sub_batch_id = p_calc_sub_batch_id;
1112:
1113: cursor namecheck_cursor(p_batch_name_to_check cn_calc_submission_batches.name%TYPE) is
1114: select * from cn_calc_submission_batches where name = p_batch_name_to_check and rownum = 1;
1115:
1116: BEGIN
1117: -- Standard Start of API savepoint

Line 1114: select * from cn_calc_submission_batches where name = p_batch_name_to_check and rownum = 1;

1110: cursor bonus_cursor is
1111: select * from cn_calc_sub_quotas where calc_sub_batch_id = p_calc_sub_batch_id;
1112:
1113: cursor namecheck_cursor(p_batch_name_to_check cn_calc_submission_batches.name%TYPE) is
1114: select * from cn_calc_submission_batches where name = p_batch_name_to_check and rownum = 1;
1115:
1116: BEGIN
1117: -- Standard Start of API savepoint
1118: SAVEPOINT copybatch_PVT;

Line 1146: select CN_CALC_SUBMISSION_BATCHES_S1.nextval into seq_batchid from dual;

1142: 'cn.plsql.cn_calc_submission_pvt.copybatch.begin',
1143: 'Beginning of copybatch ...' );
1144: end if;
1145:
1146: select CN_CALC_SUBMISSION_BATCHES_S1.nextval into seq_batchid from dual;
1147:
1148: open batch_cursor;
1149: FETCH batch_cursor INTO batch_record;
1150: if batch_cursor%NOTFOUND then

Line 1195: cn_calc_submission_batches

1191: -- Now the non duplicated value must be available
1192: batch_record.name := temp_batch_name;
1193:
1194: insert into
1195: cn_calc_submission_batches
1196: (ORG_ID,CALC_SUB_BATCH_ID,NAME,CALC_FROM_PERIOD_ID,CALC_TO_PERIOD_ID,INTELLIGENT_FLAG,HIERARCHY_FLAG,
1197: SALESREP_OPTION,CONCURRENT_FLAG,LOG_NAME,STATUS,LOGICAL_BATCH_ID,FORECAST_FLAG,ATTRIBUTE_CATEGORY,
1198: ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,
1199: ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,START_DATE,END_DATE,CALC_TYPE,