[Home] [Help]
PACKAGE BODY: APPS.OE_INVOICE_EXT_PVT
Source
1 PACKAGE BODY OE_Invoice_Ext_Pvt AS
2 /* $Header: OEXVINVB.pls 115.1 2003/10/20 07:24:27 appldev ship $ */
3
4 Procedure Insert_Salescredit(p_salescredit_rec IN Oe_Invoice_Pub.Ra_Interface_Scredits_Rec_Type) IS
5 Begin
6 INSERT INTO RA_INTERFACE_SALESCREDITS_ALL
7 (CREATED_BY
8 ,CREATION_DATE
9 ,LAST_UPDATED_BY
10 ,LAST_UPDATE_DATE
11 ,INTERFACE_SALESCREDIT_ID
12 ,INTERFACE_LINE_ID
13 ,INTERFACE_LINE_CONTEXT
14 ,INTERFACE_LINE_ATTRIBUTE1
15 ,INTERFACE_LINE_ATTRIBUTE2
16 ,INTERFACE_LINE_ATTRIBUTE3
17 ,INTERFACE_LINE_ATTRIBUTE4
18 ,INTERFACE_LINE_ATTRIBUTE5
19 ,INTERFACE_LINE_ATTRIBUTE6
20 ,INTERFACE_LINE_ATTRIBUTE7
21 ,INTERFACE_LINE_ATTRIBUTE8
22 ,INTERFACE_LINE_ATTRIBUTE9
23 ,INTERFACE_LINE_ATTRIBUTE10
24 ,INTERFACE_LINE_ATTRIBUTE11
25 ,INTERFACE_LINE_ATTRIBUTE12
26 ,INTERFACE_LINE_ATTRIBUTE13
27 ,INTERFACE_LINE_ATTRIBUTE14
28 ,INTERFACE_LINE_ATTRIBUTE15
29 ,SALESREP_NUMBER
30 ,SALESREP_ID
31 ,SALES_CREDIT_TYPE_NAME
32 ,SALES_CREDIT_TYPE_ID
33 ,SALES_CREDIT_AMOUNT_SPLIT
34 ,SALES_CREDIT_PERCENT_SPLIT
35 --SG
36 -- ,SALES_GROUP_ID
37 --SG
38 ,INTERFACE_STATUS
39 ,REQUEST_ID
40 ,ATTRIBUTE_CATEGORY
41 ,ATTRIBUTE1
42 ,ATTRIBUTE2
43 ,ATTRIBUTE3
44 ,ATTRIBUTE4
45 ,ATTRIBUTE5
46 ,ATTRIBUTE6
47 ,ATTRIBUTE7
48 ,ATTRIBUTE8
49 ,ATTRIBUTE9
50 ,ATTRIBUTE10
51 ,ATTRIBUTE11
52 ,ATTRIBUTE12
53 ,ATTRIBUTE13
54 ,ATTRIBUTE14
55 ,ATTRIBUTE15
56 ,ORG_ID)
57 VALUES
58 (p_salescredit_rec.CREATED_BY
59 ,p_salescredit_rec.CREATION_DATE
60 ,p_salescredit_rec.LAST_UPDATED_BY
61 ,p_salescredit_rec.LAST_UPDATE_DATE
62 ,p_salescredit_rec.INTERFACE_SALESCREDIT_ID
63 ,p_salescredit_rec.INTERFACE_LINE_ID
64 ,p_salescredit_rec.INTERFACE_LINE_CONTEXT
65 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE1
66 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE2
67 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE3
68 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE4
69 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE5
70 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE6
71 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE7
72 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE8
73 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE9
74 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE10
75 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE11
76 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE12
77 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE13
78 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE14
79 ,p_salescredit_rec.INTERFACE_LINE_ATTRIBUTE15
80 ,p_salescredit_rec.SALESREP_NUMBER
81 ,p_salescredit_rec.SALESREP_ID
82 ,p_salescredit_rec.SALES_CREDIT_TYPE_NAME
83 ,p_salescredit_rec.SALES_CREDIT_TYPE_ID
84 ,p_salescredit_rec.SALES_CREDIT_AMOUNT_SPLIT
85 ,p_salescredit_rec.SALES_CREDIT_PERCENT_SPLIT
86 --SG
87 -- ,p_salescredit_rec.SALES_GROUP_ID
88 --SG
89 ,p_salescredit_rec.INTERFACE_STATUS
90 ,p_salescredit_rec.REQUEST_ID
91 ,p_salescredit_rec.ATTRIBUTE_CATEGORY
92 ,p_salescredit_rec.ATTRIBUTE1
93 ,p_salescredit_rec.ATTRIBUTE2
94 ,p_salescredit_rec.ATTRIBUTE3
95 ,p_salescredit_rec.ATTRIBUTE4
96 ,p_salescredit_rec.ATTRIBUTE5
97 ,p_salescredit_rec.ATTRIBUTE6
98 ,p_salescredit_rec.ATTRIBUTE7
99 ,p_salescredit_rec.ATTRIBUTE8
100 ,p_salescredit_rec.ATTRIBUTE9
101 ,p_salescredit_rec.ATTRIBUTE10
102 ,p_salescredit_rec.ATTRIBUTE11
103 ,p_salescredit_rec.ATTRIBUTE12
104 ,p_salescredit_rec.ATTRIBUTE13
105 ,p_salescredit_rec.ATTRIBUTE14
106 ,p_salescredit_rec.ATTRIBUTE15
107 ,p_salescredit_rec.ORG_ID);
108 OE_DEBUG_PUB.ADD('Successfully inserted Sales Credit Records',5);
109 EXCEPTION WHEN OTHERS THEN
110 OE_DEBUG_PUB.add('Unable to insert Sales Credit records -> '||sqlerrm,1);
111 NULL;
112 END Insert_Salescredit;
113
114 END OE_Invoice_Ext_Pvt;