[Home] [Help]
PACKAGE: APPS.CN_CALC_SUBLEDGER_PVT
Source
1 PACKAGE CN_CALC_SUBLEDGER_PVT AUTHID CURRENT_USER as
2 /* $Header: cnvcsubs.pls 120.1 2005/07/06 18:56:01 appldev ship $ */
3
4 TYPE srp_subledger_rec_type IS RECORD
5 ( physical_batch_id NUMBER(15));
6
7 TYPE srp_pe_subledger_rec_type IS RECORD
8 ( salesrep_id NUMBER(15),
9 quota_id NUMBER(15),
10 accu_period_id NUMBER(15),
11 srp_plan_assign_id NUMBER(15),
12 input_ptd cn_formula_common_pkg.num_table_type,
13 input_itd cn_formula_common_pkg.num_table_type,
14 output_ptd NUMBER,
15 output_itd NUMBER,
16 perf_ptd NUMBER,
17 perf_itd NUMBER,
18 rollover NUMBER,
19 calc_type VARCHAR2(30));
20
21 TYPE je_batch_rec_type IS RECORD
22 ( ledger_je_batch_id NUMBER(15));
23
24 -- API name : update_srp_subledger
25 -- Type : Private.
26 -- Pre-reqs :
27 -- Usage :
28 --
29 -- Desc :
30 --
31 --
32 --
33 -- Parameters :
34 -- IN : p_api_version NUMBER Require
35 -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
36 -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
37 -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
38 -- OUT : x_return_status VARCHAR2(1)
39 -- x_msg_count NUMBER
40 -- x_msg_data VARCHAR2(2000)
41 -- IN : p_srp_subledger srp_subledger_rec_type Require
42 --
43 --
44 --
45 -- Version : Current version 1.0
46 -- Initial version 1.0
47 --
48 -- Notes :
49 --
50 -- End of comments
51
52 PROCEDURE update_srp_subledger
53 ( p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55 p_commit IN VARCHAR2 := FND_API.G_FALSE,
56 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
57
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61
62 p_srp_subledger IN srp_subledger_rec_type
63 );
64
65 -- API name : update_srp_pe_subledger
66 -- Type : Private.
67 -- Pre-reqs :
68 -- Usage :
69 --
70 -- Desc :
71 --
72 --
73 --
74 -- Parameters :
75 -- IN : p_api_version NUMBER Require
76 -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
77 -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
78 -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
79 -- OUT : x_return_status VARCHAR2(1)
80 -- x_msg_count NUMBER
81 -- x_msg_data VARCHAR2(2000)
82 -- IN : p_srp_pe_subledger srp_pe_subledger_rec_type Require
83 -- p_mode IN VARCHAR2 := 'A'
84 --
85 --
86 -- Version : Current version 1.0
87 -- Initial version 1.0
88 --
89 -- Notes :
90 --
91 -- End of comments
92
93 PROCEDURE update_srp_pe_subledger
94 ( p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96 p_commit IN VARCHAR2 := FND_API.G_FALSE,
97 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
98
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102
103 p_srp_pe_subledger IN srp_pe_subledger_rec_type,
104 p_mode IN VARCHAR2 := 'A'
105 );
106
107 -- API name : post_je_batch
108 -- Type : Private.
109 -- Pre-reqs :
110 -- Usage :
111 --
112 -- Desc :
113 --
114 --
115 --
116 -- Parameters :
117 -- IN : p_api_version NUMBER Require
118 -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
119 -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
120 -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
121 -- OUT : x_return_status VARCHAR2(1)
122 -- x_msg_count NUMBER
123 -- x_msg_data VARCHAR2(2000)
124 -- IN : p_je_batch je_batch_rec_type Require
125 --
126 --
127 --
128 -- Version : Current version 1.0
129 -- Initial version 1.0
130 --
131 -- Notes :
132 --
133 -- End of comments
134
135 PROCEDURE post_je_batch
136 ( p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138 p_commit IN VARCHAR2 := FND_API.G_FALSE,
139 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
140
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144
145 p_je_batch IN je_batch_rec_type
146 );
147
148
149 PROCEDURE roll_quotas_forecast(p_salesrep_id NUMBER,
150 p_period_id NUMBER,
151 p_quota_id NUMBER,
152 p_srp_plan_assign_id NUMBER);
153
154 END cn_calc_subledger_pvt;