1 PACKAGE ar_adjust_pub AUTHID CURRENT_USER AS
2 /* $Header: ARXPADJS.pls 120.8 2008/02/12 13:42:25 mpsingh ship $*/
3 /*#
4 * Adjustment API allows users to create, approve, update, and reverse
5 * adjustments for invoices using simple calls to PL/SQL functions.
6 * @rep:scope public
7 * @rep:metalink 236938.1 See OracleMetaLink note 236938.1
8 * @rep:product AR
9 * @rep:lifecycle active
10 * @rep:displayname Adjustment API
11 * @rep:category BUSINESS_ENTITY AR_ADJUSTMENT
12 */
13
14 G_START_TIME number;
15
16 /*#
17 * Use this procedure to create adjustments to invoices.
18 * @rep:scope public
19 * @rep:lifecycle active
20 * @rep:displayname Create Adjustment
21 */
22
23 PROCEDURE Create_Adjustment (
24 p_api_name IN varchar2,
25 p_api_version IN number,
26 p_init_msg_list IN varchar2 := FND_API.G_FALSE,
27 p_commit_flag IN varchar2 := FND_API.G_FALSE,
28 p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
29 p_msg_count OUT NOCOPY number,
30 p_msg_data OUT NOCOPY varchar2,
31 p_return_status OUT NOCOPY varchar2,
32 p_adj_rec IN ar_adjustments%rowtype,
33 p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
34 p_check_amount IN varchar2 := FND_API.G_TRUE,
35 p_move_deferred_tax IN varchar2 DEFAULT 'Y',
36 p_new_adjust_number OUT NOCOPY ar_adjustments.adjustment_number%type,
37 p_new_adjust_id OUT NOCOPY ar_adjustments.adjustment_id%type,
38 p_called_from IN varchar2 DEFAULT NULL,
39 p_old_adjust_id IN ar_adjustments.adjustment_id%type DEFAULT NULL,
40 p_org_id IN NUMBER DEFAULT NULL
41 );
42
43 /*#
44 * Use this procedure to update an adjustment.
45 * @rep:scope public
46 * @rep:lifecycle active
47 * @rep:displayname Modify Adjustment
48 */
49
50 PROCEDURE Modify_Adjustment(
51 p_api_name IN varchar2,
52 p_api_version IN number,
53 p_init_msg_list IN varchar2 := FND_API.G_FALSE,
54 p_commit_flag IN varchar2 := FND_API.G_FALSE,
55 p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
56 p_msg_count OUT NOCOPY number,
57 p_msg_data OUT NOCOPY varchar2,
58 p_return_status OUT NOCOPY varchar2 ,
59 p_adj_rec IN ar_adjustments%rowtype,
60 p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
61 p_move_deferred_tax IN varchar2 DEFAULT 'Y',
62 p_old_adjust_id IN ar_adjustments.adjustment_id%type,
63 p_org_id IN NUMBER DEFAULT NULL
64 );
65
66 /*#
67 * Use this procedure to reverse an adjustment.
68 * @rep:scope public
69 * @rep:lifecycle active
70 * @rep:displayname Reverse Adjustment
71 */
72
73 PROCEDURE Reverse_Adjustment(
74 p_api_name IN varchar2,
75 p_api_version IN number,
76 p_init_msg_list IN varchar2 := FND_API.G_FALSE,
77 p_commit_flag IN varchar2 := FND_API.G_FALSE,
78 p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
79 p_msg_count OUT NOCOPY number,
80 p_msg_data OUT NOCOPY varchar2,
81 p_return_status OUT NOCOPY varchar2,
82 p_old_adjust_id IN ar_adjustments.adjustment_id%type,
83 p_reversal_gl_date IN date,
84 p_reversal_date IN date,
85 p_comments IN ar_adjustments.comments%type,
86 p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
87 p_move_deferred_tax IN varchar2 DEFAULT 'Y',
88 p_new_adj_id OUT NOCOPY ar_adjustments.adjustment_id%type,
89 p_called_from IN varchar2 DEFAULT NULL ,
90 p_org_id IN NUMBER DEFAULT NULL
91 );
92
93 /*#
94 * Use this procedure to approve an adjustment.
95 * @rep:scope public
96 * @rep:lifecycle active
97 * @rep:displayname Approve Adjustment
98 */
99
100 PROCEDURE Approve_Adjustment (
101 p_api_name IN varchar2,
102 p_api_version IN number,
103 p_init_msg_list IN varchar2 := FND_API.G_FALSE,
104 p_commit_flag IN varchar2 := FND_API.G_FALSE,
105 p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
106 p_msg_count OUT NOCOPY number,
107 p_msg_data OUT NOCOPY varchar2,
108 p_return_status OUT NOCOPY varchar2,
109 p_adj_rec IN ar_adjustments%rowtype,
110 p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
111 p_move_deferred_tax IN varchar2 DEFAULT 'Y',
112 p_old_adjust_id IN ar_adjustments.adjustment_id%type,
113 p_org_id IN NUMBER DEFAULT NULL
114 );
115
116
117 -- Added for Line level Adjustment
118
119 TYPE llca_adj_trx_line_rec_type IS RECORD (
120 customer_trx_line_id NUMBER DEFAULT NULL,
121 line_amount NUMBER DEFAULT NULL,
122 receivables_trx_id NUMBER DEFAULT NULL
123 );
124
125 TYPE llca_adj_trx_line_tbl_type IS TABLE OF llca_adj_trx_line_rec_type
126 INDEX BY BINARY_INTEGER;
127
128
129 TYPE llca_adj_create_rec_type IS RECORD (
130 adjustment_number NUMBER DEFAULT NULL,
131 adjustment_id NUMBER DEFAULT NULL,
132 customer_trx_line_id NUMBER DEFAULT NULL
133 );
134
135 TYPE llca_adj_create_tbl_type IS TABLE OF llca_adj_create_rec_type
136 INDEX BY BINARY_INTEGER;
137
138
139 PROCEDURE create_linelevel_adjustment (
140 p_api_name IN varchar2,
141 p_api_version IN number,
142 p_init_msg_list IN varchar2 := FND_API.G_FALSE,
143 p_commit_flag IN varchar2 := FND_API.G_FALSE,
144 p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
145 p_msg_count OUT NOCOPY number,
146 p_msg_data OUT NOCOPY varchar2,
147 p_return_status OUT NOCOPY varchar2 ,
148 p_adj_rec IN ar_adjustments%rowtype,
149 p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
150 p_llca_adj_trx_lines_tbl IN llca_adj_trx_line_tbl_type,
151 p_check_amount IN varchar2 := FND_API.G_TRUE,
152 p_move_deferred_tax IN varchar2,
153 p_llca_adj_create_tbl_type OUT NOCOPY llca_adj_create_tbl_type,
154 p_called_from IN varchar2,
155 p_old_adjust_id IN ar_adjustments.adjustment_id%type,
156 p_org_id IN NUMBER DEFAULT NULL
157 );
158
159 -- Added for Line level Adjustment [End]
160
161
162 END ar_adjust_pub;
163