[Home] [Help]
PACKAGE: APPS.AR_AGING_BUCKETS_PKG
Source
1 PACKAGE AR_AGING_BUCKETS_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARAGBKTS.pls 120.0.12010000.2 2009/07/28 06:01:33 nproddut noship $*/
3
4
5 /*==========================================================================
6 | PRIVATE FUNCTION get_reporting_entity_id |
7 | |
8 | DESCRIPTION |
9 | |
10 | |
11 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body) |
12 | |
13 | PARAMETERS |
14 | |
15 | KNOWN ISSUES |
16 | |
17 | NOTES |
18 | |
19 | MODIFICATION HISTORY |
20 | Date Author Description of Changes |
21 | 10-JUL-2009 Naveen Prodduturi Created |
22 *==========================================================================*/
23 FUNCTION get_reporting_entity_id RETURN NUMBER;
24
25
26 /*==========================================================================
27 | PRIVATE FUNCTION get_contact_information |
28 | |
29 | DESCRIPTION |
30 | Returns contact information associated to given site,return values |
31 | also depends on what sort of information is requested |
32 | |
33 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body) |
34 | |
35 | PARAMETERS |
36 | p_site_use_id |
37 | p_info_type -possible values are NAME and PHONE |
38 | KNOWN ISSUES |
39 | |
40 | NOTES |
41 | |
42 | MODIFICATION HISTORY |
43 | Date Author Description of Changes |
44 | 10-JUL-2009 Naveen Prodduturi Created |
45 *==========================================================================*/
46 FUNCTION get_contact_information( p_site_use_id NUMBER,
47 p_info_type VARCHAR2) RETURN VARCHAR2;
48
49
50
51 /*==========================================================================
52 | PRIVATE PROCEDURE aging_seven_buckets |
53 | |
54 | DESCRIPTION |
55 | |
56 | |
57 | CALLED FROM PROCEDURES/FUNCTIONS |
58 | Used as part of the cocurrent program defintion |
59 | |
60 | PARAMETERS |
61 | NONE |
62 | |
63 | KNOWN ISSUES |
64 | |
65 | NOTES |
66 | |
67 | MODIFICATION HISTORY |
68 | Date Author Description of Changes |
69 | 10-JUL-2009 Naveen Prodduturi Created |
70 *==========================================================================*/
71 PROCEDURE aging_seven_buckets(
72 p_rep_type IN VARCHAR2,
73 p_reporting_level IN VARCHAR2,
74 p_reporting_entity_id IN VARCHAR2,
75 p_coaid IN VARCHAR2,
76 p_in_bal_segment_low IN VARCHAR2,
77 p_in_bal_segment_high IN VARCHAR2,
78 p_in_as_of_date_low IN VARCHAR2,
79 p_in_summary_option_low IN VARCHAR2,
80 p_in_format_option_low IN VARCHAR2,
81 p_in_bucket_type_low IN VARCHAR2,
82 p_credit_option IN VARCHAR2,
83 p_risk_option IN VARCHAR2,
84 p_in_currency IN VARCHAR2,
85 p_in_customer_name_low IN VARCHAR2,
86 p_in_customer_name_high IN VARCHAR2,
87 p_in_customer_num_low IN VARCHAR2,
88 p_in_customer_num_high IN VARCHAR2,
89 p_in_amt_due_low IN VARCHAR2,
90 p_in_amt_due_high IN VARCHAR2,
91 p_in_invoice_type_low IN VARCHAR2,
92 p_in_invoice_type_high IN VARCHAR2,
93 p_accounting_method IN VARCHAR2,
94 p_in_worker_id IN VARCHAR2 DEFAULT -1,
95 p_in_worker_count IN VARCHAR2 DEFAULT 1,
96 p_retain_staging_flag IN VARCHAR2 DEFAULT NULL,
97 p_master_req_flag IN VARCHAR2 DEFAULT 'Y' );
98
99
100
101
102 /*==========================================================================
103 | PRIVATE PROCEDURE aging_rep_extract |
104 | |
105 | DESCRIPTION |
106 | Acts as child process,makes required procedure call to process the |
107 | alllocated payment schedules and generate aging information |
108 | |
109 | CALLED FROM PROCEDURES/FUNCTIONS |
110 | Used as part of the cocurrent program defintion |
111 | |
112 | |
113 | KNOWN ISSUES |
114 | |
115 | |
116 | MODIFICATION HISTORY |
117 | Date Author Description of Changes |
118 | 10-JUL-2009 Naveen Prodduturi Created |
119 *==========================================================================*/
120 PROCEDURE aging_rep_extract(
121 p_errbuf OUT NOCOPY VARCHAR2,
122 p_retcode OUT NOCOPY NUMBER,
123 p_rep_type IN VARCHAR2,
124 p_reporting_level IN VARCHAR2,
125 p_reporting_entity_id IN VARCHAR2,
126 p_coaid IN VARCHAR2,
127 p_in_bal_segment_low IN VARCHAR2,
128 p_in_bal_segment_high IN VARCHAR2,
129 p_in_as_of_date_low IN VARCHAR2,
130 p_in_summary_option_low IN VARCHAR2,
131 p_in_format_option_low IN VARCHAR2,
132 p_in_bucket_type_low IN VARCHAR2,
133 p_credit_option IN VARCHAR2,
134 p_risk_option IN VARCHAR2,
135 p_in_currency IN VARCHAR2,
136 p_in_customer_name_low IN VARCHAR2,
137 p_in_customer_name_high IN VARCHAR2,
138 p_in_customer_num_low IN VARCHAR2,
139 p_in_customer_num_high IN VARCHAR2,
140 p_in_amt_due_low IN VARCHAR2,
141 p_in_amt_due_high IN VARCHAR2,
142 p_in_invoice_type_low IN VARCHAR2,
143 p_in_invoice_type_high IN VARCHAR2,
144 p_accounting_method IN VARCHAR2,
145 p_in_worker_id IN VARCHAR2 DEFAULT -1,
146 p_in_worker_count IN VARCHAR2 DEFAULT 1,
147 p_retain_staging_flag IN VARCHAR2 DEFAULT NULL) ;
148
149 END AR_AGING_BUCKETS_PKG;