DBA Data[Home] [Help]

PACKAGE: APPS.ARP_CHARGEBACK_COVER

Source


1 PACKAGE ARP_CHARGEBACK_COVER  AS
2 /* $Header: ARXCBCVS.pls 120.5 2005/06/03 18:43:03 jbeckett noship $ */
3 
4 /*=======================================================================+
5  |  Declare PUBLIC Data Types and Variables
6  +=======================================================================*/
7     TYPE Chargeback_Rec_Type IS RECORD (
8       amount                          NUMBER
9     , attribute_category              VARCHAR2(30)
10     , attribute1                      VARCHAR2(150)
11     , attribute2                      VARCHAR2(150)
12     , attribute3                      VARCHAR2(150)
13     , attribute4                      VARCHAR2(150)
14     , attribute5                      VARCHAR2(150)
15     , attribute6                      VARCHAR2(150)
16     , attribute7                      VARCHAR2(150)
17     , attribute8                      VARCHAR2(150)
18     , attribute9                      VARCHAR2(150)
19     , attribute10                     VARCHAR2(150)
20     , attribute11                     VARCHAR2(150)
21     , attribute12                     VARCHAR2(150)
22     , attribute13                     VARCHAR2(150)
23     , attribute14                     VARCHAR2(150)
24     , attribute15                     VARCHAR2(150)
25     , cust_trx_type_id                NUMBER
26     , code_combination_id             NUMBER
27     , reason_code                     RA_CUSTOMER_TRX.reason_code%TYPE
28     , comments                        RA_CUSTOMER_TRX.comments%TYPE
29     , default_ussgl_trx_code_context  ra_customer_trx.default_ussgl_trx_code_context%TYPE
30     , default_ussgl_transaction_code  ra_customer_trx.default_ussgl_transaction_code%TYPE
31     , gl_date                         DATE
32     , due_date                        DATE
33     , cash_receipt_id                 NUMBER
34     , secondary_application_ref_id    NUMBER
35     , new_second_application_ref_id   NUMBER
36     , application_ref_type            ar_receivable_applications.application_ref_type%TYPE
37     , bill_to_site_use_id             NUMBER
38     , interface_header_context        VARCHAR2(30)
39     , interface_header_attribute1     VARCHAR2(30)
40     , interface_header_attribute2     VARCHAR2(30)
41     , interface_header_attribute3     VARCHAR2(30)
42     , interface_header_attribute4     VARCHAR2(30)
43     , interface_header_attribute5     VARCHAR2(30)
44     , interface_header_attribute6     VARCHAR2(30)
45     , interface_header_attribute7     VARCHAR2(30)
46     , interface_header_attribute8     VARCHAR2(30)
47     , interface_header_attribute9     VARCHAR2(30)
48     , interface_header_attribute10    VARCHAR2(30)
49     , interface_header_attribute11    VARCHAR2(30)
50     , interface_header_attribute12    VARCHAR2(30)
51     , interface_header_attribute13    VARCHAR2(30)
52     , interface_header_attribute14    VARCHAR2(30)
53     , interface_header_attribute15    VARCHAR2(30)
54     , internal_notes                  ra_customer_trx.internal_notes%TYPE
55     , customer_reference              ra_customer_trx.customer_reference%TYPE
56     , legal_entity_id 		      ra_customer_trx.legal_entity_id%TYPE
57 );
58 /*=======================================================================+
59  |  Declare PUBLIC Exceptions
60  +=======================================================================*/
61     temp_exception EXCEPTION;
62 
63 /*========================================================================
64  | PUBLIC PROCEDURE    create_chargeback
65  |
66  | DESCRIPTION
67  |
68  | PSEUDO CODE/LOGIC
69  |
70  | PARAMETERS
71  |
72  | KNOWN ISSUES
73  |
74  | NOTES
75  |
76  | MODIFICATION HISTORY
77  | Date                  Author            Description of Changes
78  | 03-OCT-2001           jbeckett          Created
79  |
80  *=======================================================================*/
81 PROCEDURE create_chargeback (
82   p_chargeback_rec           IN  arp_chargeback_cover.Chargeback_Rec_Type,
83   p_init_msg_list            IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
84   x_doc_sequence_id          OUT NOCOPY  NUMBER,
85   x_doc_sequence_value       OUT NOCOPY ra_customer_trx.doc_sequence_value%TYPE,
86   x_trx_number               OUT NOCOPY ra_customer_trx.trx_number%TYPE,
87   x_customer_trx_id          OUT NOCOPY NUMBER,
88   x_return_status            OUT NOCOPY VARCHAR2,
89   x_msg_count                OUT NOCOPY NUMBER,
90   x_msg_data                 OUT NOCOPY VARCHAR2);
91 
92 
93 END ARP_CHARGEBACK_COVER;