APPS.CN_INTEL_CALC_PKG dependencies on CN_SRP_INTEL_PERIODS

Line 7: -- Table handler for CN_SRP_INTEL_PERIODS

3: --
4: -- Package Name
5: -- CN_INTEL_CALC_PKG
6: -- Purpose
7: -- Table handler for CN_SRP_INTEL_PERIODS
8: -- Form
9: -- N/A
10: -- Block
11: -- N/A

Line 50: SELECT cn_srp_intel_periods_s.NEXTVAL

46: ) IS
47: l_srp_intel_period_id NUMBER(15);
48: l_rowid ROWID;
49: CURSOR u_id IS
50: SELECT cn_srp_intel_periods_s.NEXTVAL
51: FROM dual;
52: CURSOR c IS SELECT ROWID FROM cn_srp_intel_periods
53: WHERE srp_intel_period_id = l_srp_intel_period_id;
54: CURSOR rec IS

Line 52: CURSOR c IS SELECT ROWID FROM cn_srp_intel_periods

48: l_rowid ROWID;
49: CURSOR u_id IS
50: SELECT cn_srp_intel_periods_s.NEXTVAL
51: FROM dual;
52: CURSOR c IS SELECT ROWID FROM cn_srp_intel_periods
53: WHERE srp_intel_period_id = l_srp_intel_period_id;
54: CURSOR rec IS
55: SELECT srp_intel_period_id
56: FROM cn_srp_intel_periods

Line 56: FROM cn_srp_intel_periods

52: CURSOR c IS SELECT ROWID FROM cn_srp_intel_periods
53: WHERE srp_intel_period_id = l_srp_intel_period_id;
54: CURSOR rec IS
55: SELECT srp_intel_period_id
56: FROM cn_srp_intel_periods
57: WHERE period_id = x_period_id
58: AND salesrep_id = x_salesrep_id
59: AND org_id = x_org_id;
60: BEGIN

Line 77: INSERT INTO cn_srp_intel_periods (

73: ELSE
74: l_srp_intel_period_id := x_srp_intel_period_id;
75: END IF;
76:
77: INSERT INTO cn_srp_intel_periods (
78: srp_intel_period_id,
79: salesrep_id,
80: org_id,
81: period_id,

Line 198: FROM cn_srp_intel_periods

194: attribute12,
195: attribute13,
196: attribute14,
197: attribute15
198: FROM cn_srp_intel_periods
199: WHERE srp_intel_period_id = x_srp_intel_period_id
200: FOR UPDATE OF srp_intel_period_id nowait;
201: recinfo c%ROWTYPE;
202: BEGIN

Line 325: UPDATE cn_srp_intel_periods SET

321: x_last_update_date IN DATE,
322: x_last_updated_by IN NUMBER,
323: x_last_update_login IN NUMBER) IS
324: BEGIN
325: UPDATE cn_srp_intel_periods SET
326: salesrep_id = x_salesrep_id,
327: period_id = x_period_id,
328: start_date = x_start_date,
329: end_date = x_end_date,

Line 363: DELETE FROM cn_srp_intel_periods

359: PROCEDURE delete_row (
360: x_srp_intel_period_id IN NUMBER
361: ) IS
362: BEGIN
363: DELETE FROM cn_srp_intel_periods
364: WHERE srp_intel_period_id = x_srp_intel_period_id;
365:
366: IF (SQL%notfound) THEN
367: RAISE no_data_found;