[Home] [Help]
PACKAGE: APPS.OE_OE_MULTI_HEADER_SCREDIT
Source
1 PACKAGE OE_OE_Multi_Header_Scredit AUTHID CURRENT_USER AS
2 /* $Header: OEXMHSCS.pls 120.1.12000000.2 2007/07/27 08:20:54 cpati ship $ */
3
4 TYPE HEADER_MULTI_Scredit_Tbl_Type IS TABLE OF OE_ORDER_PUB.Header_Scredit_Rec_Type
5 INDEX BY BINARY_INTEGER;
6
7 Function Get_Multi_Errors
8 (p_start_with_first Varchar2 default FND_API.G_TRUE
9 ) Return Varchar2;
10
11 Procedure Add_Multi_Header_Scredit_Req
12 (p_init IN Varchar2 Default FND_API.G_FALSE
13 ,p_salesrep_id IN Number
14 ,p_sales_Credit_type_id IN Number
15 ,p_percent IN Number
16 -- changes start for bug 3742335
17 ,p_Context Varchar2
18 ,p_Attribute1 Varchar2
19 ,p_Attribute2 Varchar2
20 ,p_Attribute3 Varchar2
21 ,p_Attribute4 Varchar2
22 ,p_Attribute5 Varchar2
23 ,p_Attribute6 Varchar2
24 ,p_Attribute7 Varchar2
25 ,p_Attribute8 Varchar2
26 ,p_Attribute9 Varchar2
27 ,p_Attribute10 Varchar2
28 ,p_Attribute11 Varchar2
29 ,p_Attribute12 Varchar2
30 ,p_Attribute13 Varchar2
31 ,p_Attribute14 Varchar2
32 ,p_Attribute15 Varchar2
33 -- changes end for bug 3742335
34 ,p_sales_group_id IN Number --5692017
35 ,p_sales_group_updated_flag IN Varchar2 --5692017
36 ,p_return_status OUT NOCOPY Varchar2
37
38 ,p_msg_count OUT NOCOPY NUMBER
39
40 ,p_msg_data OUT NOCOPY Varchar2
41
42 );
43
44 /* Replace credit type : R - Revenue
45 NR - Non Revenue
46 B - Both Revenue and Non-Revenue
47 */
48 Procedure Replace_Multi_Header_Scredit
49 (
50 p_cont_on_error IN Varchar2 Default FND_API.G_TRUE
51 ,p_header_id_list IN Oe_Globals.Selected_Record_Tbl
52 ,p_replace_credit_type IN Varchar2
53 ,p_Return_Status OUT NOCOPY Varchar2
54
55 ,p_msg_count OUT NOCOPY NUMBER
56
57 ,p_msg_data OUT NOCOPY Varchar2
58
59 );
60
61 /* Returns a substr separted by null char ie chr(12) */
62 Procedure Get_Substring
63 (String IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 , Sub_string IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65 );
66
67 END OE_OE_Multi_Header_Scredit;
68