1 PACKAGE ARP_RECEIPTS_MAIN AS
2 /* $Header: ARRECACS.pls 120.3 2007/08/24 13:25:44 dgaurab ship $ */
3
4 /* =======================================================================
5 | PUBLIC Data Types
6 * ======================================================================*/
7 SUBTYPE ae_doc_rec_type IS ARP_ACCT_MAIN.ae_doc_rec_type;
8 SUBTYPE ae_event_rec_type IS ARP_ACCT_MAIN.ae_event_rec_type;
9 SUBTYPE ae_line_rec_type IS ARP_ACCT_MAIN.ae_line_rec_type;
10 SUBTYPE ae_line_tbl_type IS ARP_ACCT_MAIN.ae_line_tbl_type;
11 SUBTYPE ae_sys_rec_type IS ARP_ACCT_MAIN.ae_sys_rec_type;
12 SUBTYPE ae_curr_rec_type IS ARP_ACCT_MAIN.ae_curr_rec_type;
13 SUBTYPE ae_rule_rec_type IS ARP_ACCT_MAIN.ae_app_rule_rec_type;
14
15 --Used to pair a UNAPP record with an APP, UNDID or ACC record as applicable
16 TYPE ae_app_pair_rec_type IS RECORD (
17 status ar_distributions.source_type%TYPE, -- E.g. APP, ACC, UNID only
18 source_id ar_distributions.source_id%TYPE , -- E.g. New APP receivable application id
19 source_id_old ar_distributions.source_id%TYPE , -- E.g. Old APP receivable application id
20 source_table ar_distributions.source_table%TYPE
21 );
22
23 --
24 -- Table for pairing APP, ACC, UNID records with UNAPP records when reversing a Cash Receipt
25 --
26 TYPE ae_app_pair_tbl_type IS TABLE of ae_app_pair_rec_type
27 INDEX BY BINARY_INTEGER;
28
29 ae_app_pair_tbl ae_app_pair_tbl_type;
30
31 ae_app_pair_tbl_ctr BINARY_INTEGER := 0;
32
33
34 ard_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE; -- E.g. Cash Receipt Id used for Initialising table
35
36 --Exception handler which raises an error if unable to derive a valid substituted ccid
37 invalid_ccid_error EXCEPTION; --bug6024475
38
39 /* =======================================================================
40 | PUBLIC Procedures/functions
41 * ======================================================================*/
42
43 /* =======================================================================
44 | PROCEDURE Execute
45 |
46 | DESCRIPTION
47 | Accounting Entry Derivation Method
48 | ----------------------------------
49 | This procedure is the Accounting Entry derivation method for all
50 | accounting events associated with the receivable applications
51 | layer for Receipts and CM's.
52 |
53 | Functions of the AE Derivation Method are:
54 | - Single Entry Point for easy extensibility
55 | - Read Event Data
56 | - Read Transaction and Setup Data
57 | - Determine AE Lines affected
58 | - Derive AE Lines
59 | - Return AE Lines created in a PL/SQL table.
60 |
61 | PARAMETERS
62 | p_mode IN Document or Accounting Event mode
63 | p_ae_doc_rec IN Document Record
64 | p_ae_event_rec IN Event Record
65 | p_ae_line_tbl OUT NOCOPY AE Lines table
66 | p_ae_created OUT NOCOPY AE Lines creation status
67 * ======================================================================*/
68 PROCEDURE Execute( p_mode IN VARCHAR2,
69 p_ae_doc_rec IN ae_doc_rec_type,
70 p_ae_event_rec IN ae_event_rec_type,
71 p_ae_line_tbl OUT NOCOPY ae_line_tbl_type,
72 p_ae_created OUT NOCOPY BOOLEAN,
73 --{HYUDETUPT
74 p_from_llca_call IN VARCHAR2 DEFAULT 'N',
75 p_gt_id IN NUMBER DEFAULT NULL
76 --}
77 );
78
79 /* =======================================================================
80 | PROCEDURE Delete_Acct
81 |
82 | DESCRIPTION
83 | Deletes the accounting entry lines for a document
84 | --------------------------------------------------
85 | This procedure is the Accounting Entry deletion routine which
86 | deletes the accounting entries for Receipts from the
87 | AR_DISTRIBUTIONS table.
88 |
89 | PARAMETERS
90 | p_mode IN Document or Accounting Event mode
91 | p_ae_doc_rec IN Document Record
92 | p_ae_event_rec IN Event Record
93 | p_ae_created OUT NOCOPY AE Lines creation status
94 * ======================================================================*/
95 PROCEDURE Delete_Acct( p_mode IN VARCHAR2,
96 p_ae_doc_rec IN OUT NOCOPY ae_doc_rec_type,
97 p_ae_event_rec IN ae_event_rec_type,
98 p_ae_deleted OUT NOCOPY BOOLEAN);
99
100 END ARP_RECEIPTS_MAIN;