PACKAGE: APPS.AR_INTERFACESALESCREDITS_GRP

Source

1 PACKAGE AR_InterfaceSalesCredits_GRP AUTHID CURRENT_USER AS
2 /* $Header: ARXGISCS.pls 115.1 2003/10/02 22:17:36 kmahajan noship $ */
3 
4 /*=======================================================================+
5  |  Declare PUBLIC Data Types and Variables
6  +=======================================================================*/
7 
8  TYPE application_tbl_type IS TABLE of ar_receivable_applications%ROWTYPE
9       INDEX BY BINARY_INTEGER;
10 
11  TYPE salescredit_rec_type IS RECORD
12    (
13 	INTERFACE_SALESCREDIT_ID	NUMBER(15),
14 	INTERFACE_LINE_ID		NUMBER(15),
15 	INTERFACE_LINE_CONTEXT		VARCHAR2(30),
16 	INTERFACE_LINE_ATTRIBUTE1	VARCHAR2(30),
17 	INTERFACE_LINE_ATTRIBUTE2	VARCHAR2(30),
18 	INTERFACE_LINE_ATTRIBUTE3	VARCHAR2(30),
19 	INTERFACE_LINE_ATTRIBUTE4	VARCHAR2(30),
20 	INTERFACE_LINE_ATTRIBUTE5	VARCHAR2(30),
21 	INTERFACE_LINE_ATTRIBUTE6	VARCHAR2(30),
22 	INTERFACE_LINE_ATTRIBUTE7	VARCHAR2(30),
23 	INTERFACE_LINE_ATTRIBUTE8	VARCHAR2(30),
24 	INTERFACE_LINE_ATTRIBUTE9	VARCHAR2(30),
25 	INTERFACE_LINE_ATTRIBUTE10	VARCHAR2(30),
26 	INTERFACE_LINE_ATTRIBUTE11	VARCHAR2(30),
27 	INTERFACE_LINE_ATTRIBUTE12	VARCHAR2(30),
28 	INTERFACE_LINE_ATTRIBUTE13	VARCHAR2(30),
29 	INTERFACE_LINE_ATTRIBUTE14	VARCHAR2(30),
30 	INTERFACE_LINE_ATTRIBUTE15	VARCHAR2(30),
31 	SALESREP_NUMBER			VARCHAR2(30),
32 	SALESREP_ID			NUMBER(15),
33 	SALESGROUP_ID			NUMBER,
34 	SALES_CREDIT_TYPE_NAME		VARCHAR2(30),
35 	SALES_CREDIT_TYPE_ID		NUMBER(15),
36 	SALES_CREDIT_AMOUNT_SPLIT	NUMBER,
37 	SALES_CREDIT_PERCENT_SPLIT	NUMBER,
38 	INTERFACE_STATUS		VARCHAR2(1),
39 	REQUEST_ID			NUMBER(15),
40 	ATTRIBUTE_CATEGORY		VARCHAR2(30),
41 	ATTRIBUTE1			VARCHAR2(150),
42 	ATTRIBUTE2			VARCHAR2(150),
43 	ATTRIBUTE3			VARCHAR2(150),
44 	ATTRIBUTE4			VARCHAR2(150),
45 	ATTRIBUTE5			VARCHAR2(150),
46 	ATTRIBUTE6			VARCHAR2(150),
47 	ATTRIBUTE7			VARCHAR2(150),
48 	ATTRIBUTE8			VARCHAR2(150),
49 	ATTRIBUTE9			VARCHAR2(150),
50 	ATTRIBUTE10			VARCHAR2(150),
51 	ATTRIBUTE11			VARCHAR2(150),
52 	ATTRIBUTE12			VARCHAR2(150),
53 	ATTRIBUTE13			VARCHAR2(150),
54 	ATTRIBUTE14			VARCHAR2(150),
55 	ATTRIBUTE15			VARCHAR2(150),
56 	CREATED_BY			NUMBER(15),
57 	CREATION_DATE			DATE,
58 	LAST_UPDATED_BY			NUMBER(15),
59 	LAST_UPDATE_DATE		DATE,
60 	LAST_UPDATE_LOGIN		NUMBER(15),
61 	ORG_ID				NUMBER(15)
62    );
63 
64 /*=======================================================================+
65  |  Declare PUBLIC Exceptions
66  +=======================================================================*/
67 
68 /*========================================================================
69  | PUBLIC Procedure Insert_SalesCredit
70  |
71  | DESCRIPTION
72  |       This function inserts a row into RA_INTERFACE_SALESCREDITS_ALL and
73  |	 is passed all the data in the salescredit_rec_type parameter
74  |
75  | PSEUDO CODE/LOGIC
76  |
77  | PARAMETERS
78  |       IN
79  |         p_salescredit_rec
80  |       OUT NOCOPY
81  |         x_return_status  - Standard return status
82  |         x_msg_data       - Standard msg data
83  |         x_msg_count      - Standard msg count
84  |
85  |
86  | RETURNS
87  |      nothing
88  |
89  | KNOWN ISSUES
90  |
91  | NOTES
92  |
93  | MODIFICATION HISTORY
94  | Date                  Author         Description of Changes
95  | 01-OCT-2003           K.Mahajan      Created
96  *=======================================================================*/
97  PROCEDURE insert_salescredit(
98                p_salescredit_rec IN
99                               salescredit_rec_type,
100                x_return_status   OUT NOCOPY VARCHAR2,
101                x_msg_count       OUT NOCOPY NUMBER,
102                x_msg_data        OUT NOCOPY VARCHAR2
103                );
104 
105 END AR_InterfaceSalesCredits_GRP;