[Home] [Help]
PACKAGE: APPS.CN_PROC_BATCHES_PKG
Source
1 PACKAGE CN_PROC_BATCHES_PKG as
2 /* $Header: cnsybats.pls 120.2 2005/08/02 17:54:49 ymao ship $ */
3
4
5 -- Procedure Name
6 -- find_srp_incomplete_plan
7 -- Purpose
8 --
9 -- Notes
10 FUNCTION find_srp_incomplete_plan (p_calc_sub_batch_id NUMBER) RETURN boolean;
11
12 PROCEDURE Calculate_Batch
13 (errbuf OUT NOCOPY VARCHAR2,
14 retcode OUT NOCOPY NUMBER,
15 p_calc_sub_batch_id IN cn_calc_submission_batches.calc_sub_batch_id%TYPE);
16
17 PROCEDURE calc( errbuf OUT NOCOPY VARCHAR2,
18 retcode OUT NOCOPY NUMBER,
19 p_batch_name VARCHAR2,
20 p_start_date DATE,
21 p_end_date DATE,
22 p_calc_type VARCHAR2,
23 p_salesrep_option VARCHAR2,
24 p_hierarchy_flag VARCHAR2,
25 p_intelligent_flag VARCHAR2,
26 p_interval_type_id NUMBER,
27 p_salesrep_id NUMBER,
28 p_quota_id NUMBER );
29
30 PROCEDURE calc_curr(errbuf OUT NOCOPY VARCHAR2,
31 retcode OUT NOCOPY NUMBER,
32 p_batch_name VARCHAR2,
33 p_start_date VARCHAR2,
34 p_end_date VARCHAR2,
35 p_calc_type VARCHAR2,
36 p_salesrep_option VARCHAR2,
37 p_hierarchy_flag VARCHAR2,
38 p_intelligent_flag VARCHAR2,
39 p_salesrep_id NUMBER);
40
41 PROCEDURE collection(
42 errbuf OUT NOCOPY VARCHAR2
43 ,retcode OUT NOCOPY NUMBER
44 ,p_start_date DATE
45 ,p_end_date DATE
46 ,p_salesrep_id NUMBER
47 ,p_comp_plan_id NUMBER);
48
49 -- Name
50 --
51 -- Purpose
52 --
53 -- Notes
54 -- Called from calculation submission form CNSBCS
55 --
56 PROCEDURE calculation_submission( p_calc_sub_batch_id NUMBER,
57 x_process_audit_id OUT NOCOPY NUMBER,
58 x_process_status_code OUT NOCOPY VARCHAR2 );
59
60
61 -- Name
62 --
63 -- Purpose
64 --
65 -- Notes
66 --
67 --
68 PROCEDURE runner( errbuf OUT NOCOPY VARCHAR2
69 ,retcode OUT NOCOPY NUMBER
70 ,p_parent_proc_audit_id NUMBER
71 ,p_logical_process VARCHAR2
72 ,p_physical_process VARCHAR2
73 ,p_physical_batch_id NUMBER
74 ,p_salesrep_id NUMBER := NULL
75 ,p_start_date DATE := NULL
76 ,p_end_date DATE := NULL
77 ,p_cls_rol_flag VARCHAR2 := NULL);
78
79 -- Name
80 --
81 -- Purpose
82 --
83 -- Notes
84 --
85 --
86 PROCEDURE processor(
87 errbuf OUT NOCOPY VARCHAR2
88 ,retcode OUT NOCOPY NUMBER
89 ,p_parent_proc_audit_id NUMBER
90 ,p_concurrent_flag VARCHAR2
91 ,p_process_name VARCHAR2
92 ,p_logical_batch_id NUMBER
93 ,p_start_date DATE
94 ,p_end_date DATE
95 ,p_salesrep_id NUMBER
96 ,p_comp_plan_id NUMBER);
97
98 -- processor concurrent wrapper on top of processor, called by the concurrent program CN_BATPROC.
99 -- Do the Canonical-to-Date conversion on the date prarmeters, bug 2610735
100
101 PROCEDURE processor_curr(
102 errbuf OUT NOCOPY VARCHAR2
103 ,retcode OUT NOCOPY NUMBER
104 ,p_parent_proc_audit_id NUMBER
105 ,p_concurrent_flag VARCHAR2
106 ,p_process_name VARCHAR2
107 ,p_logical_batch_id NUMBER
108 ,p_start_date VARCHAR2
109 ,p_end_date VARCHAR2
110 ,p_salesrep_id NUMBER
111 ,p_comp_plan_id NUMBER);
112
113 -- Name
114 --
115 -- Purpose
116 --
117 -- Notes
118 --
119 --
120
121 PROCEDURE main( p_concurrent_flag VARCHAR2 DEFAULT 'N'
122 ,p_process_name VARCHAR2 DEFAULT 'CALCULATION'
123 ,p_logical_batch_id NUMBER
124 ,p_start_date DATE
125 ,p_end_date DATE
126 ,p_salesrep_id NUMBER
127 ,p_comp_plan_id NUMBER
128 ,x_process_audit_id IN OUT NOCOPY NUMBER
129 ,x_process_status_code OUT NOCOPY VARCHAR2);
130
131 FUNCTION get_period_name ( x_period_id IN NUMBER,
132 p_org_id IN NUMBER ) RETURN VARCHAR2;
133
134 PROCEDURE get_person_name_num ( x_salesrep_id NUMBER,
135 p_org_id NUMBER,
136 x_name IN OUT NOCOPY VARCHAR2,
137 x_num IN OUT NOCOPY varchar2);
138
139 PROCEDURE populate_process_batch(p_calc_sub_batch_id NUMBER);
140
141 FUNCTION validate_ruleset_status(p_start_date DATE,
142 p_end_date DATE,
143 p_org_id NUMBER ) RETURN BOOLEAN;
144
145 -- Name
146 -- check_end_of_interval
147 -- Purpose
148 -- Returns 1 if the specified period is the end of an interval of the
149 -- type listed int he X_Interval string.
150 -- History
151 -- 06/13/95 Created Rjin
152 --
153 FUNCTION check_end_of_interval(p_period_id NUMBER,
154 p_interval_type_id NUMBER,
155 p_org_id NUMBER) RETURN BOOLEAN;
156
157
158 END CN_PROC_BATCHES_PKG;