[Home] [Help]
PACKAGE BODY: APPS.AR_INTERFACESALESCREDITS_GRP
Source
1 PACKAGE BODY AR_InterfaceSalesCredits_GRP AS
2 /* $Header: ARXGISCB.pls 115.3 2003/10/02 22:19:34 kmahajan noship $ */
3
4 /*========================================================================
5 | PUBLIC Procedure Insert_SalesCredit
6 |
7 | DESCRIPTION
8 | This function inserts a row into RA_INTERFACE_SALESCREDITS_ALL and
9 | is passed all the data in p_salescredit_rec
10 |
11 | PSEUDO CODE/LOGIC
12 |
13 | PARAMETERS
14 | IN
15 | p_salescredit_rec
16 | OUT NOCOPY
17 | x_return_status - Standard return status
18 | x_msg_data - Standard msg data
19 | x_msg_count - Standard msg count
20 |
21 |
22 | RETURNS
23 | nothing
24 |
25 | KNOWN ISSUES
26 |
27 | NOTES
28 |
29 | MODIFICATION HISTORY
30 | Date Author Description of Changes
31 | 01-OCT-2003 K.Mahajan Created
32 | 02-OCT-2003 K.Mahajan Added update of salesgroup_id column
33 | - dependency on arati.odf 115.19
34 *=======================================================================*/
35 PROCEDURE insert_salescredit(
36 p_salescredit_rec IN
37 salescredit_rec_type,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2
41 ) IS
42
43 BEGIN
44 arp_util.debug('AR_InterfaceSalesCredits_GRP.insert_salescredit (+)');
45 x_return_status := FND_API.G_RET_STS_SUCCESS;
46
47
48 INSERT INTO ra_interface_salescredits_all
49 (
50 INTERFACE_SALESCREDIT_ID ,
51 INTERFACE_LINE_ID ,
52 INTERFACE_LINE_CONTEXT ,
53 INTERFACE_LINE_ATTRIBUTE1 ,
54 INTERFACE_LINE_ATTRIBUTE2 ,
55 INTERFACE_LINE_ATTRIBUTE3 ,
56 INTERFACE_LINE_ATTRIBUTE4 ,
57 INTERFACE_LINE_ATTRIBUTE5 ,
58 INTERFACE_LINE_ATTRIBUTE6 ,
59 INTERFACE_LINE_ATTRIBUTE7 ,
60 INTERFACE_LINE_ATTRIBUTE8 ,
61 INTERFACE_LINE_ATTRIBUTE9 ,
62 INTERFACE_LINE_ATTRIBUTE10 ,
63 INTERFACE_LINE_ATTRIBUTE11 ,
64 INTERFACE_LINE_ATTRIBUTE12 ,
65 INTERFACE_LINE_ATTRIBUTE13 ,
66 INTERFACE_LINE_ATTRIBUTE14 ,
67 INTERFACE_LINE_ATTRIBUTE15 ,
68 SALESREP_NUMBER ,
69 SALESREP_ID ,
70 SALESGROUP_ID ,
71 SALES_CREDIT_TYPE_NAME ,
72 SALES_CREDIT_TYPE_ID ,
73 SALES_CREDIT_AMOUNT_SPLIT ,
74 SALES_CREDIT_PERCENT_SPLIT ,
75 INTERFACE_STATUS ,
76 REQUEST_ID ,
77 ATTRIBUTE_CATEGORY ,
78 ATTRIBUTE1 ,
79 ATTRIBUTE2 ,
80 ATTRIBUTE3 ,
81 ATTRIBUTE4 ,
82 ATTRIBUTE5 ,
83 ATTRIBUTE6 ,
84 ATTRIBUTE7 ,
85 ATTRIBUTE8 ,
86 ATTRIBUTE9 ,
87 ATTRIBUTE10 ,
88 ATTRIBUTE11 ,
89 ATTRIBUTE12 ,
90 ATTRIBUTE13 ,
91 ATTRIBUTE14 ,
92 ATTRIBUTE15 ,
93 CREATED_BY ,
94 CREATION_DATE ,
95 LAST_UPDATED_BY ,
96 LAST_UPDATE_DATE ,
97 LAST_UPDATE_LOGIN ,
98 ORG_ID
99 )
100 VALUES
101 (
102 p_salescredit_rec.INTERFACE_SALESCREDIT_ID ,
103 p_salescredit_rec.INTERFACE_LINE_ID ,
104 p_salescredit_rec.INTERFACE_LINE_CONTEXT ,
105 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE1 ,
106 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE2 ,
107 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE3 ,
108 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE4 ,
109 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE5 ,
110 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE6 ,
111 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE7 ,
112 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE8 ,
113 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE9 ,
114 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE10 ,
115 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE11 ,
116 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE12 ,
117 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE13 ,
118 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE14 ,
119 p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE15 ,
120 p_salescredit_rec.SALESREP_NUMBER ,
121 p_salescredit_rec.SALESREP_ID ,
122 p_salescredit_rec.SALESGROUP_ID ,
123 p_salescredit_rec.SALES_CREDIT_TYPE_NAME ,
124 p_salescredit_rec.SALES_CREDIT_TYPE_ID ,
125 p_salescredit_rec.SALES_CREDIT_AMOUNT_SPLIT ,
126 p_salescredit_rec.SALES_CREDIT_PERCENT_SPLIT ,
127 p_salescredit_rec.INTERFACE_STATUS ,
128 p_salescredit_rec.REQUEST_ID ,
129 p_salescredit_rec.ATTRIBUTE_CATEGORY ,
130 p_salescredit_rec.ATTRIBUTE1 ,
131 p_salescredit_rec.ATTRIBUTE2 ,
132 p_salescredit_rec.ATTRIBUTE3 ,
133 p_salescredit_rec.ATTRIBUTE4 ,
134 p_salescredit_rec.ATTRIBUTE5 ,
135 p_salescredit_rec.ATTRIBUTE6 ,
136 p_salescredit_rec.ATTRIBUTE7 ,
137 p_salescredit_rec.ATTRIBUTE8 ,
138 p_salescredit_rec.ATTRIBUTE9 ,
139 p_salescredit_rec.ATTRIBUTE10 ,
140 p_salescredit_rec.ATTRIBUTE11 ,
141 p_salescredit_rec.ATTRIBUTE12 ,
142 p_salescredit_rec.ATTRIBUTE13 ,
143 p_salescredit_rec.ATTRIBUTE14 ,
144 p_salescredit_rec.ATTRIBUTE15 ,
145 p_salescredit_rec.CREATED_BY ,
146 p_salescredit_rec.CREATION_DATE ,
147 p_salescredit_rec.LAST_UPDATED_BY ,
148 p_salescredit_rec.LAST_UPDATE_DATE ,
149 p_salescredit_rec.LAST_UPDATE_LOGIN ,
150 p_salescredit_rec.ORG_ID
151 );
152
153 arp_util.debug('AR_InterfaceSalesCredits_GRP.insert_salescredit (-)');
154
155 EXCEPTION
156 WHEN OTHERS THEN
157 arp_util.debug('EXCEPTION: (' || sqlcode || ': ' || sqlerrm ||') AR_InterfaceSalesCredits_GRP.insert_salescredit()');
158 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160
161 END insert_salescredit;
162
163 END AR_InterfaceSalesCredits_GRP;