APPS.CN_SRP_PERIODS_PKG dependencies on CN_SRP_PERIODS

Line 1: PACKAGE BODY CN_SRP_PERIODS_PKG AS

1: PACKAGE BODY CN_SRP_PERIODS_PKG AS
2: /* $Header: cnsrprdb.pls 120.0 2005/06/06 17:53:12 appldev noship $ */
3: --
4: -- Package Name
5: -- CN_SRP_PERIODS_PKG

Line 5: -- CN_SRP_PERIODS_PKG

1: PACKAGE BODY CN_SRP_PERIODS_PKG AS
2: /* $Header: cnsrprdb.pls 120.0 2005/06/06 17:53:12 appldev noship $ */
3: --
4: -- Package Name
5: -- CN_SRP_PERIODS_PKG
6: -- Purpose
7: -- Table Handler for CN_SRP_PERIODS
8: -- History
9: -- 26-Jun-99 Angela Chung Created

Line 7: -- Table Handler for CN_SRP_PERIODS

3: --
4: -- Package Name
5: -- CN_SRP_PERIODS_PKG
6: -- Purpose
7: -- Table Handler for CN_SRP_PERIODS
8: -- History
9: -- 26-Jun-99 Angela Chung Created
10: -- 02-Nov-99 Angela Chung remove proc : mark_event, raise_status
11:

Line 22: -- To get the previous record in cn_srp_periods so can inherit the balance

18: -- /*-------------------------------------------------------------------------*
19: -- Procedure Name
20: -- Get_Previous_Balances
21: -- Purpose
22: -- To get the previous record in cn_srp_periods so can inherit the balance
23: -- from previous record
24: -- *-------------------------------------------------------------------------*/
25: PROCEDURE Get_Previous_Balances
26: (p_salesrep_id IN NUMBER,

Line 33: x_srp_prd_row OUT NOCOPY cn_srp_periods%rowtype) IS

29: p_quota_id IN NUMBER,
30: p_credit_type_id IN NUMBER,
31: p_start_date IN DATE,
32: p_period_id IN NUMBER,
33: x_srp_prd_row OUT NOCOPY cn_srp_periods%rowtype) IS
34:
35: l_max_end_date cn_srp_periods.end_date%TYPE;
36: l_pre_period_year cn_period_statuses.period_year%TYPE;
37: l_cur_period_year cn_period_statuses.period_year%TYPE;

Line 35: l_max_end_date cn_srp_periods.end_date%TYPE;

31: p_start_date IN DATE,
32: p_period_id IN NUMBER,
33: x_srp_prd_row OUT NOCOPY cn_srp_periods%rowtype) IS
34:
35: l_max_end_date cn_srp_periods.end_date%TYPE;
36: l_pre_period_year cn_period_statuses.period_year%TYPE;
37: l_cur_period_year cn_period_statuses.period_year%TYPE;
38:
39:

Line 44: FROM cn_srp_periods_all srp

40: BEGIN
41: -- Find closest previous record
42: SELECT MAX(end_date)
43: INTO l_max_end_date
44: FROM cn_srp_periods_all srp
45: WHERE salesrep_id = p_salesrep_id
46: AND org_id = p_org_id
47: AND role_id = p_role_id
48: AND quota_id = p_quota_id

Line 54: FROM cn_srp_periods_all

50: AND end_date < p_start_date;
51: -- Get all data from previous record
52: SELECT *
53: INTO x_srp_prd_row
54: FROM cn_srp_periods_all
55: WHERE salesrep_id = p_salesrep_id
56: AND org_id = p_org_id
57: AND role_id = p_role_id
58: AND quota_id = p_quota_id

Line 246: l_srp_prd_row cn_srp_periods%ROWTYPE := Null;

242: X_LAST_UPDATED_BY IN NUMBER,
243: X_LAST_UPDATE_LOGIN IN NUMBER
244: ) IS
245: l_dummy NUMBER;
246: l_srp_prd_row cn_srp_periods%ROWTYPE := Null;
247:
248: BEGIN
249: SELECT cn_srp_periods_s.NEXTVAL
250: INTO X_SRP_PERIOD_ID

Line 249: SELECT cn_srp_periods_s.NEXTVAL

245: l_dummy NUMBER;
246: l_srp_prd_row cn_srp_periods%ROWTYPE := Null;
247:
248: BEGIN
249: SELECT cn_srp_periods_s.NEXTVAL
250: INTO X_SRP_PERIOD_ID
251: FROM dual;
252:
253: INSERT INTO cn_srp_periods_all

Line 253: INSERT INTO cn_srp_periods_all

249: SELECT cn_srp_periods_s.NEXTVAL
250: INTO X_SRP_PERIOD_ID
251: FROM dual;
252:
253: INSERT INTO cn_srp_periods_all
254: (SRP_PERIOD_ID ,
255: SALESREP_ID ,
256: org_id,
257: PERIOD_ID ,

Line 558: SELECT 1 INTO l_dummy FROM CN_SRP_PERIODS_all

554: x_last_updated_by ,
555: x_last_update_login
556: );
557:
558: SELECT 1 INTO l_dummy FROM CN_SRP_PERIODS_all
559: WHERE SRP_PERIOD_ID = x_srp_period_id;
560:
561: END Insert_Row;
562:

Line 573: DELETE FROM cn_srp_periods_all

569: PROCEDURE Delete_row( x_srp_period_id NUMBER ) IS
570:
571: BEGIN
572:
573: DELETE FROM cn_srp_periods_all
574: WHERE srp_period_id = x_srp_period_id ;
575: IF (SQL%NOTFOUND) THEN
576: RAISE NO_DATA_FOUND;
577: END IF;

Line 581: END CN_SRP_PERIODS_PKG;

577: END IF;
578:
579: END Delete_row;
580:
581: END CN_SRP_PERIODS_PKG;