This script can be used to adjust the Revenue for a particular transaction. The amount can be adjusted from one transaction line to another line by specifying the actual amount to adjust or percentage. Run this procedure in loop to adjust many transactions.<\/p>\n
BEGIN<\/p>\n --GLOBAL VARIABLES INITIALIZATION --ASSIGN VALUES<\/p>\n p_revenue_adj_rec.trx_number := '2008332'; -- ACTUAL BLOCK<\/p>\n ar_revenueadjust_pub.earn_revenue -- DISPLAY OUT PARAMETERS<\/p>\n DBMS_OUTPUT.put_line ('x_return_status: ' || l_return_status); COMMIT;<\/p>\n END adjustment_api;<\/p>\n <\/code><\/p>\n","protected":false},"excerpt":{"rendered":" This script can be used to adjust the Revenue for a particular transaction. The amount can be adjusted from one transaction line to another line by specifying the actual amount to adjust or percentage. Run this procedure in loop to adjust many transactions. CREATE OR REPLACE PROCEDURE adjustment_api IS p_revenue_adj_rec ar_revenue_adjustment_pvt.rev_adj_rec_type; x_return_status VARCHAR2 (2000); x_msg_count […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1848","post","type-post","status-publish","format-standard","hentry","category-scripts"],"yoast_head":"\n
\nCREATE OR REPLACE PROCEDURE adjustment_api
\nIS
\n p_revenue_adj_rec ar_revenue_adjustment_pvt.rev_adj_rec_type;
\n x_return_status VARCHAR2 (2000);
\n x_msg_count NUMBER;
\n x_msg_data VARCHAR2 (2000);
\n x_adjustment_id NUMBER;
\n x_adjustment_number VARCHAR2 (50);
\n l_return_status VARCHAR2 (100);
\n l_msg_count NUMBER;
\n l_msg_data VARCHAR2 (1000);
\n l_adjustment_id NUMBER;
\n l_adjustment_number VARCHAR2 (1000);<\/p>\n
\n DBMS_APPLICATION_INFO.set_client_info (107);
\n arp_global.init_global;
\n arp_standard.init_standard;<\/p>\n
\n p_revenue_adj_rec.batch_source_name := 'WRS ORDER MANAGEMENT';
\n p_revenue_adj_rec.amount_mode := 'P';
\n -- P_REVENUE_ADJ_REC.AMOUNT := 10;
\n p_revenue_adj_rec.PERCENT := 2.6;
\n --P_REVENUE_ADJ_REC.FROM_CUST_TRX_LINE_ID := ;
\n --P_REVENUE_ADJ_REC.TO_CUST_TRX_LINE_ID := ;
\n p_revenue_adj_rec.gl_date := '05-APR-06';
\n p_revenue_adj_rec.reason_code := 'RA';<\/p>\n
\n (p_api_version => 2.0,
\n p_init_msg_list => fnd_api.g_true,
\n x_return_status => l_return_status,
\n x_msg_count => l_msg_count,
\n x_msg_data => l_msg_data,
\n p_rev_adj_rec => p_revenue_adj_rec,
\n x_adjustment_id => l_adjustment_id,
\n x_adjustment_number => l_adjustment_number
\n );<\/p>\n
\n DBMS_OUTPUT.put_line ('x_msg_count: ' || l_msg_count);
\n DBMS_OUTPUT.put_line ('x_msg_data: ' || l_msg_data);
\n DBMS_OUTPUT.put_line ('x_adjustment_id: ' || l_adjustment_id);
\n DBMS_OUTPUT.put_line ('x_adjustment_number: ' || l_adjustment_number);<\/p>\n