PACKAGE: APPS.CN_QUOTA_RULES_PKG

Source

1 PACKAGE cn_quota_rules_pkg AUTHID CURRENT_USER AS
2 /* $Header: cnpliqrs.pls 120.1 2005/07/11 19:59:25 appldev ship $ */
3 
4    /*
5    Date      Name          Description
6    ----------------------------------------------------------------------------+
7    15-FEB-95 P Cook  Unit tested
8 
9    Name
10 
11    Purpose
12 
13    Notes
14 
15    */
16 
17    -- Name
18    --+
19    -- Purpose
20    --+
21    -- Notes
22    --+
23    --+
24    PROCEDURE begin_record (
25       x_quota_rule_id            IN OUT NOCOPY NUMBER,
26       x_object_version_number    IN OUT NOCOPY NUMBER,
27       x_org_id                            NUMBER,
28       x_operation                         VARCHAR2,
29       x_revenue_class_id                  NUMBER,
30       x_quota_id                          NUMBER,
31       x_last_update_date                  DATE,
32       x_last_updated_by                   NUMBER,
33       x_creation_date                     DATE,
34       x_created_by                        NUMBER,
35       x_last_update_login                 NUMBER,
36       x_target                            NUMBER,
37       x_target_old                        NUMBER,
38       x_payment_amount                    NUMBER,
39       x_payment_amount_old                NUMBER,
40       x_performance_goal                  NUMBER,
41       x_performance_goal_old              NUMBER,
42       x_revenue_class_name                VARCHAR2,
43       x_program_type                      VARCHAR2,
44       x_status_code                       VARCHAR2,
45       x_revenue_class_id_old              NUMBER
46    );
47 
48    -- Name
49    --+
50    -- Purpose
51    --+
52    -- Notes
53    --+
54    --+
55    PROCEDURE end_record (
56       x_rowid                             VARCHAR2,
57       x_revenue_class_id                  NUMBER,
58       x_quota_id                          NUMBER,
59       x_target                            NUMBER,
60       x_payment_amount                    NUMBER,
61       x_performance_goal                  NUMBER,
62       x_quota_rule_id                     NUMBER,
63       x_program_type                      VARCHAR2
64    );
65 
66    -- Name
67    --+
68    -- Purpose
69    --+
70    -- Notes
71    --+
72    --+
73    PROCEDURE get_rev_class_name (
74       x_revenue_class_id                  NUMBER,
75       x_revenue_class_name       IN OUT NOCOPY VARCHAR2
76    );
77 
78    -- Name
79    --+
80    -- Purpose
81    --+
82    -- Notes
83    --+
84    --+
85    PROCEDURE DELETE_RECORD (
86       x_quota_id                          NUMBER,
87       x_quota_rule_id                     NUMBER,
88       x_revenue_class_id                  NUMBER
89    );
90 
91    FUNCTION check_rev_class_hier (
92       x_revenue_class_id                  NUMBER,
93       x_revenue_class_id_old              NUMBER,
94       x_quota_id                          NUMBER,
95       x_start_period_id                   NUMBER,
96       x_end_period_id                     NUMBER
97    )
98       RETURN BOOLEAN;
99 END cn_quota_rules_pkg;