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_ENTRIES

Line 27: calc_sub_entry_id cn_calc_submission_entries.calc_sub_entry_id%TYPE);

23: TYPE rep_entry_rec_type IS RECORD
24: (name jtf_rs_salesreps.name%TYPE,
25: employee_number jtf_rs_salesreps.salesrep_number%TYPE,
26: salesrep_id jtf_rs_salesreps.salesrep_id%TYPE,
27: calc_sub_entry_id cn_calc_submission_entries.calc_sub_entry_id%TYPE);
28:
29: TYPE quota_entry_rec_type IS RECORD
30: (name cn_quotas.name%TYPE,
31: quota_id cn_quotas.quota_id%TYPE,

Line 743: FROM cn_calc_submission_entries a,

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
743: FROM cn_calc_submission_entries a,
744: cn_salesreps b
745: WHERE a.calc_sub_batch_id = p_calc_sub_batch_id
746: AND a.salesrep_id = b.salesrep_id;
747:

Line 1096: batch_entries_record cn_calc_submission_entries%rowtype;

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);
1100: dummy_batch cn_calc_submission_batches%rowtype;

Line 1108: select * from cn_calc_submission_entries where calc_sub_batch_id = p_calc_sub_batch_id;

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:
1110: cursor bonus_cursor is
1111: select * from cn_calc_sub_quotas where calc_sub_batch_id = p_calc_sub_batch_id;
1112:

Line 1223: insert into cn_calc_submission_entries(ORG_ID,CALC_SUB_ENTRY_ID,CALC_SUB_BATCH_ID,SALESREP_ID,ATTRIBUTE_CATEGORY,

1219: -- Star
1220: for calc_entries in rep_cursor
1221: loop
1222: -- Process the Entry Records here.
1223: insert into cn_calc_submission_entries(ORG_ID,CALC_SUB_ENTRY_ID,CALC_SUB_BATCH_ID,SALESREP_ID,ATTRIBUTE_CATEGORY,
1224: ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,
1225: ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,CREATED_BY,
1226: CREATION_DATE,SECURITY_GROUP_ID,HIERARCHY_FLAG)
1227: values

Line 1228: (calc_entries.ORG_ID,CN_CALC_SUBMISSION_ENTRIES_S1.nextval,seq_batchid,calc_entries.SALESREP_ID,

1224: ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,
1225: ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,CREATED_BY,
1226: CREATION_DATE,SECURITY_GROUP_ID,HIERARCHY_FLAG)
1227: values
1228: (calc_entries.ORG_ID,CN_CALC_SUBMISSION_ENTRIES_S1.nextval,seq_batchid,calc_entries.SALESREP_ID,
1229: calc_entries.ATTRIBUTE_CATEGORY,calc_entries.ATTRIBUTE1,calc_entries.ATTRIBUTE2,calc_entries.ATTRIBUTE3,
1230: calc_entries.ATTRIBUTE4,calc_entries.ATTRIBUTE5,calc_entries.ATTRIBUTE6,calc_entries.ATTRIBUTE7,
1231: calc_entries.ATTRIBUTE8,calc_entries.ATTRIBUTE9,calc_entries.ATTRIBUTE10,calc_entries.ATTRIBUTE11,
1232: calc_entries.ATTRIBUTE12,calc_entries.ATTRIBUTE13,calc_entries.ATTRIBUTE14,calc_entries.ATTRIBUTE15,