[Home] [Help]
PACKAGE: APPS.OZF_SD_BATCH_PVT
Source
1 PACKAGE OZF_SD_BATCH_PVT as
2 /* $Header: ozfvsdbs.pls 120.15.12010000.3 2008/09/26 07:49:13 annsrini ship $ */
3
4 -- Start of Comments
5 -- Package name : OZF_SD_BATCH_PVT
6 -- Purpose :
7 -- History :
8 -- 26-SEP-2008 - ANNSRINI - Modified p_start_date and p_end_date to varchar instead of DATE in create_batch_main
9 -- NOTE :
10 -- End of Comments
11
12 --G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_SD_BATCH_PVT';
13 --G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvsdbs.pls';
14
15 -- Author : MBHATT
16 -- Created : 11/16/2007 2:39:16 PM
17 -- Purpose :
18 -- Public function and procedure declarations
19 -- Private type declarations
20
21 PROCEDURE create_batch_main(errbuf OUT nocopy VARCHAR2,
22 retcode OUT nocopy NUMBER,
23 p_org_id IN NUMBER,
24 p_supplier_id IN NUMBER,
25 p_supplier_site_id IN NUMBER,
26 --p_category_id IN NUMBER,
27 p_product_id IN NUMBER,
28 p_request_id IN NUMBER,
29 p_fund_id IN NUMBER,
30 p_start_date IN VARCHAR2,
31 p_end_date IN VARCHAR2,
32 p_period IN VARCHAR2,
33 p_attribute1 IN VARCHAR2 := NULL,
34 p_attribute2 IN VARCHAR2 := NULL,
35 p_attribute3 IN VARCHAR2 := NULL,
36 p_attribute4 IN VARCHAR2 := NULL,
37 p_attribute5 IN VARCHAR2 := NULL,
38 p_attribute6 IN VARCHAR2 := NULL,
39 p_attribute7 IN VARCHAR2 := NULL,
40 p_attribute8 IN VARCHAR2 := NULL,
41 p_attribute9 IN VARCHAR2 := NULL,
42 p_attribute10 IN VARCHAR2 := NULL,
43 p_attribute11 IN VARCHAR2 := NULL,
44 p_attribute12 IN VARCHAR2 := NULL,
45 p_attribute13 IN VARCHAR2 := NULL,
46 p_attribute14 IN VARCHAR2 := NULL,
47 p_attribute15 IN VARCHAR2 := NULL
48 );
49
50 PROCEDURE create_batch_sub(p_org_id IN NUMBER,
51 p_supplier_id IN NUMBER,
52 p_supplier_site_id IN NUMBER,
53 --p_category_id IN NUMBER,
54 p_product_id IN NUMBER,
55 p_request_id IN NUMBER,
56 p_fund_id IN NUMBER,
57 p_start_date IN DATE,
58 p_end_date IN DATE,
59 p_period IN VARCHAR2,
60 p_commit IN VARCHAR2 := FND_API.g_false,
61 p_attribute1 IN VARCHAR2 := NULL,
62 p_attribute2 IN VARCHAR2 := NULL,
63 p_attribute3 IN VARCHAR2 := NULL,
64 p_attribute4 IN VARCHAR2 := NULL,
65 p_attribute5 IN VARCHAR2 := NULL,
66 p_attribute6 IN VARCHAR2 := NULL,
67 p_attribute7 IN VARCHAR2 := NULL,
68 p_attribute8 IN VARCHAR2 := NULL,
69 p_attribute9 IN VARCHAR2 := NULL,
70 p_attribute10 IN VARCHAR2 := NULL,
71 p_attribute11 IN VARCHAR2 := NULL,
72 p_attribute12 IN VARCHAR2 := NULL,
73 p_attribute13 IN VARCHAR2 := NULL,
74 p_attribute14 IN VARCHAR2 := NULL,
75 p_attribute15 IN VARCHAR2 := NULL);
76
77 Procedure CREATE_BATCH(p_empty_batch OUT NOCOPY VARCHAR2,
78 p_supplier_id IN NUMBER,
79 p_supplier_site_id IN NUMBER,
80 p_org_id IN NUMBER,
81 --p_category_id IN NUMBER,
82 p_product_id IN NUMBER,
83 p_request_id IN NUMBER,
84 p_fund_id IN NUMBER,
85 p_start_date IN DATE,
86 p_end_date IN DATE,
87 p_period IN VARCHAR2,
88 p_currency_code IN VARCHAR2,
89 p_attribute1 IN VARCHAR2 := NULL,
90 p_attribute2 IN VARCHAR2 := NULL,
91 p_attribute3 IN VARCHAR2 := NULL,
92 p_attribute4 IN VARCHAR2 := NULL,
93 p_attribute5 IN VARCHAR2 := NULL,
94 p_attribute6 IN VARCHAR2 := NULL,
95 p_attribute7 IN VARCHAR2 := NULL,
96 p_attribute8 IN VARCHAR2 := NULL,
97 p_attribute9 IN VARCHAR2 := NULL,
98 p_attribute10 IN VARCHAR2 := NULL,
99 p_attribute11 IN VARCHAR2 := NULL,
100 p_attribute12 IN VARCHAR2 := NULL,
101 p_attribute13 IN VARCHAR2 := NULL,
102 p_attribute14 IN VARCHAR2 := NULL,
103 p_attribute15 IN VARCHAR2 := NULL
104 );
105
106 Procedure CREATE_BATCH_HEADER(p_supplier_id IN NUMBER,
107 p_supplier_site_id IN NUMBER,
108 p_org_id IN NUMBER,
109 p_batch_threshold NUMBER,
110 p_line_threshold NUMBER,
111 p_batch_currency VARCHAR2,
112 p_batch_new IN VARCHAR2,
113 p_batch_id OUT nocopy NUMBER);
114
115 Procedure CREATE_BATCH_LINES(p_batch_id IN NUMBER,
116 p_supplier_id IN NUMBER,
117 p_supplier_site_id IN NUMBER,
118 p_org_id IN NUMBER,
119 p_thresh_line_limit IN NUMBER,
120 p_batch_currency IN VARCHAR2,
121 --p_category_id IN NUMBER,
122 p_product_id IN NUMBER,
123 p_request_id IN NUMBER,
124 p_fund_id IN NUMBER,
125 p_start_date IN DATE,
126 p_end_date IN DATE,
127 p_period IN VARCHAR2,
128 p_empty_batch OUT NOCOPY VARCHAR2,
129 p_attribute1 IN VARCHAR2 := NULL,
130 p_attribute2 IN VARCHAR2 := NULL,
131 p_attribute3 IN VARCHAR2 := NULL,
132 p_attribute4 IN VARCHAR2 := NULL,
133 p_attribute5 IN VARCHAR2 := NULL,
134 p_attribute6 IN VARCHAR2 := NULL,
135 p_attribute7 IN VARCHAR2 := NULL,
136 p_attribute8 IN VARCHAR2 := NULL,
137 p_attribute9 IN VARCHAR2 := NULL,
138 p_attribute10 IN VARCHAR2 := NULL,
139 p_attribute11 IN VARCHAR2 := NULL,
140 p_attribute12 IN VARCHAR2 := NULL,
141 p_attribute13 IN VARCHAR2 := NULL,
142 p_attribute14 IN VARCHAR2 := NULL,
143 p_attribute15 IN VARCHAR2 := NULL
144 );
145
146 Procedure UPDATE_AMOUNTS(p_batch_id IN NUMBER,
147 p_batch_threshold IN NUMBER);
148
149 function GET_BATCH_CURRENCY_AMOUNT(p_UTILIZATION_ID number,
150 p_batch_currency VARCHAR2,p_batch_id number) return number;
151
152 FUNCTION GET_VENDOR_ITEM_ID(p_product_id number, p_supplier_site_id number)
153 return varchar2;
154
155 FUNCTION CONV_DISC_TO_OFFER_CURR_AMOUNT(p_offer_currency VARCHAR2,
156 p_discount_val_currency VARCHAR2,
157 p_discount_val number,
158 p_batch_id number) RETURN number;
159
160 procedure INVOKE_BATCH_AUTO_CLAIM(errbuf OUT nocopy VARCHAR2,
161 retcode OUT nocopy NUMBER,
162 p_batch_id number,
163 p_vendor_id number,
164 p_vendor_site_id number
165 );
166 END OZF_SD_BATCH_PVT;
167