APPS.CN_CALC_SUB_QUOTAS_PKG dependencies on CN_CALC_SUB_QUOTAS

Line 1: PACKAGE BODY CN_CALC_SUB_QUOTAS_PKG as

1: PACKAGE BODY CN_CALC_SUB_QUOTAS_PKG as
2: /* $Header: cnsbpeb.pls 120.1 2005/08/02 17:53:27 ymao noship $ */
3: G_LAST_UPDATE_DATE DATE := sysdate;
4: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
5: G_CREATION_DATE DATE := sysdate;

Line 15: -- Records into Table cn_calc_sub_quotas

11: -- This Procedure is called to
12: -- 1. Insert
13: -- 2. Update
14: -- 3. Delete
15: -- Records into Table cn_calc_sub_quotas
16: --
17: --
18:
19:

Line 52: SELECT cn_calc_sub_quotas_s.NEXTVAL

48:
49: IF p_calc_sub_quota_id IS NOT NULL THEN
50: l_calc_sub_quota_id := p_calc_sub_quota_id;
51: ELSE
52: SELECT cn_calc_sub_quotas_s.NEXTVAL
53: INTO l_calc_sub_quota_id
54: FROM dual;
55: END IF;
56:

Line 57: INSERT INTO cn_calc_sub_quotas

53: INTO l_calc_sub_quota_id
54: FROM dual;
55: END IF;
56:
57: INSERT INTO cn_calc_sub_quotas
58: ( calc_sub_quota_id,
59: calc_sub_batch_id,
60: quota_id,
61: org_id

Line 143: UPDATE cn_calc_sub_quotas_all SET

139: ) IS
140:
141: BEGIN
142:
143: UPDATE cn_calc_sub_quotas_all SET
144: calc_sub_quota_id = p_calc_sub_quota_id,
145: calc_sub_batch_id = p_calc_sub_batch_id,
146: quota_id = p_quota_id
147: ,attribute_category = p_attribute_category

Line 175: DELETE cn_calc_sub_quotas_all

171:
172: Procedure delete_row ( p_calc_sub_quota_id NUMBER ) IS
173:
174: BEGIN
175: DELETE cn_calc_sub_quotas_all
176: WHERE calc_sub_quota_id = p_calc_sub_quota_id;
177:
178: IF (sql%notfound) THEN
179: raise no_data_found;

Line 209: SELECT * FROM cn_calc_sub_quotas_all

205: P_LAST_UPDATE_DATE DATE ,
206: P_LAST_UPDATED_BY NUMBER
207: ) IS
208: CURSOR C IS
209: SELECT * FROM cn_calc_sub_quotas_all
210: WHERE calc_sub_quota_id = p_calc_sub_quota_id
211: FOR UPDATE OF calc_sub_quota_id NOWAIT;
212:
213: Recinfo C%ROWTYPE;

Line 397: END cn_calc_sub_quotas_pkg;

393: END IF;
394:
395: END begin_record;
396:
397: END cn_calc_sub_quotas_pkg;