APPS.CN_CALC_SUBMISSION_PVT dependencies on CN_CALC_SUB_QUOTAS

Line 32: calc_sub_quota_id cn_calc_sub_quotas.calc_sub_quota_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,
32: calc_sub_quota_id cn_calc_sub_quotas.calc_sub_quota_id%TYPE);
33:
34: TYPE rep_entry_tbl_type IS TABLE OF rep_entry_rec_type INDEX BY BINARY_INTEGER;
35: TYPE quota_entry_tbl_type IS TABLE OF quota_entry_rec_type INDEX BY BINARY_INTEGER;
36: TYPE name_tbl_type IS TABLE OF cn_interval_types_all_tl.name%TYPE INDEX BY BINARY_INTEGER;

Line 750: FROM cn_calc_sub_quotas a,

746: AND a.salesrep_id = b.salesrep_id;
747:
748: CURSOR quotas IS
749: SELECT b.name, a.quota_id, a.calc_sub_quota_id
750: FROM cn_calc_sub_quotas a,
751: cn_quotas b
752: WHERE a.calc_sub_batch_id = p_calc_sub_batch_id
753: AND a.quota_id = b.quota_id;
754:

Line 1097: batch_bonus_record cn_calc_sub_quotas%rowtype;

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;
1101: dup_name_counter NUMBER := 1;

Line 1111: select * from cn_calc_sub_quotas where calc_sub_batch_id = p_calc_sub_batch_id;

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

Line 1245: insert into cn_calc_sub_quotas

1241: -- Star
1242: for bonus_entries in bonus_cursor
1243: loop
1244: -- Process the Entry Records here.
1245: insert into cn_calc_sub_quotas
1246: (ORG_ID,CALC_SUB_QUOTA_ID,CALC_SUB_BATCH_ID,QUOTA_ID,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,
1247: ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,
1248: ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,CREATED_BY,CREATION_DATE,SECURITY_GROUP_ID)
1249: values

Line 1250: (bonus_entries.ORG_ID,CN_CALC_SUB_QUOTAS_S.nextval,seq_batchid,bonus_entries.QUOTA_ID,

1246: (ORG_ID,CALC_SUB_QUOTA_ID,CALC_SUB_BATCH_ID,QUOTA_ID,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,
1247: ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,
1248: ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,CREATED_BY,CREATION_DATE,SECURITY_GROUP_ID)
1249: values
1250: (bonus_entries.ORG_ID,CN_CALC_SUB_QUOTAS_S.nextval,seq_batchid,bonus_entries.QUOTA_ID,
1251: bonus_entries.ATTRIBUTE_CATEGORY,bonus_entries.ATTRIBUTE1,bonus_entries.ATTRIBUTE2,
1252: bonus_entries.ATTRIBUTE3,bonus_entries.ATTRIBUTE4,bonus_entries.ATTRIBUTE5,bonus_entries.ATTRIBUTE6,
1253: bonus_entries.ATTRIBUTE7,bonus_entries.ATTRIBUTE8,bonus_entries.ATTRIBUTE9,bonus_entries.ATTRIBUTE10,
1254: bonus_entries.ATTRIBUTE11,bonus_entries.ATTRIBUTE12,bonus_entries.ATTRIBUTE13,bonus_entries.ATTRIBUTE14,