The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT sob.set_of_books_id,
sob.chart_of_accounts_id,
sob.currency_code,
c.precision,
c.minimum_accountable_unit,
sysp.code_combination_id_gain,
sysp.code_combination_id_loss,
sysp.code_combination_id_round
INTO p_ae_sys_rec.set_of_books_id,
p_ae_sys_rec.coa_id,
p_ae_sys_rec.base_currency,
p_ae_sys_rec.base_precision,
p_ae_sys_rec.base_min_acc_unit,
p_ae_sys_rec.gain_cc_id,
p_ae_sys_rec.loss_cc_id,
p_ae_sys_rec.round_cc_id
FROM ar_system_parameters sysp,
gl_sets_of_books sob,
fnd_currencies c
WHERE sob.set_of_books_id = sysp.set_of_books_id
AND sob.currency_code = c.currency_code;
Select sum(DECODE( lines.line_type,
'TAX',0,
'FREIGHT', 0,
1) * lines.amount_due_remaining) l_line_rem,
sum(DECODE (lines.line_type,
'TAX', 1, 0) * lines.amount_due_remaining) l_tax_rem,
MAX(DECODE(lines.line_type, 'LINE',
lines.line_number, 0))
INTO
l_line_rem,
l_tax_rem,
l_apply_to
FROM ra_customer_trx ct,
ra_customer_trx_lines lines
WHERE (lines.customer_Trx_line_id = p_customer_trx_line_id or
lines.link_to_cust_trx_line_id = p_customer_trx_line_id)
AND ct.customer_Trx_id = lines.customer_trx_id
AND ct.customer_trx_id = p_customer_trx_id;
SELECT ar_activity_details_s.nextval
INTO l_line_id
FROM dual;
INSERT INTO AR_ACTIVITY_DETAILS (
LINE_ID,
APPLY_TO,
customer_trx_line_id,
CASH_RECEIPT_ID,
GROUP_ID,
AMOUNT,
TAX,
CREATED_BY,
CREATION_DATE,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
OBJECT_VERSION_NUMBER,
CREATED_BY_MODULE,
SOURCE_ID,
SOURCE_TABLE
)
VALUES (
l_line_id, -- line_id
1, -- APPLY_TO
p_customer_trx_line_id, -- customer_Trx_line_id
NULL, -- cash_Receipt_id
NULL, -- Group_ID (ll grp adj not implem)
p_line_adjusted, -- Amount
p_tax_adjusted, -- TAX
NVL(FND_GLOBAL.user_id,-1), -- Created_by
SYSDATE, -- Creation_date
decode(FND_GLOBAL.conc_login_id,
null,FND_GLOBAL.login_id,
-1, FND_GLOBAL.login_id,
FND_GLOBAL.conc_login_id), -- Last_update_login
SYSDATE, -- Last_update_date
NVL(FND_GLOBAL.user_id,-1), -- last_updated_by
0, -- object_version_number
'ARXTWADJ', -- created_by_module
p_adj_id, -- source_id
'ADJ' -- source_table
);
/* Insert lines into GT table for processing- if we have a line amt */
IF (p_line_adjusted <> 0) THEN
INSERT INTO AR_LINE_DIST_INTERFACE_GT
( GT_ID,
SOURCE_ID,
SOURCE_TABLE,
CUSTOMER_TRX_ID,
CUSTOMER_TRX_LINE_ID,
LINE_TYPE,
LINE_AMOUNT,
ED_LINE_AMOUNT,
UNED_LINE_AMOUNT)
VALUES (
l_gt_id, -- gt_id
p_adj_id, -- source_id
'ADJ' , -- source_table
p_customer_trx_id, -- customer_trx_id
p_customer_trx_line_id, -- customer_Trx_line_id
'LINE', -- line_type
p_line_adjusted, -- line_amount
NULL, -- ed_line_amount
NULL -- uned_line_amount
);
SELECT *
INTO l_adj_rec
FROM ar_adjustments
WHERE adjustment_id = p_adj_id;
SELECT *
INTO l_trx_rec
FROM ra_customer_trx
WHERE customer_trx_id = p_customer_trx_id;
SELECT lines.extended_amount tax_amt
FROM ra_customer_trx_lines lines
WHERE lines.line_type = 'TAX'
AND lines.link_to_cust_trx_line_id = p_customer_trx_line_id;
SELECT
sum(tl.extended_amount),
Count(tl.customer_Trx_line_id)
INTO l_sum,
l_total_tax_lines
FROM ra_customer_trx_lines tl
WHERE tl.customer_trx_id = p_customer_trx_id
AND tl.link_to_cust_trx_line_id = p_customer_trx_line_id;
SELECT tax_rounding_rule
INTO l_rounding_rule
FROM zx_product_options
WHERE application_id = 222;
the rounding before inserting into the gt table. */
IF ( l_row = l_total_tax_lines) THEN
l_tax_proration := p_tax_adjusted - l_total_proration;
INSERT INTO AR_LINE_DIST_INTERFACE_GT
( GT_ID,
SOURCE_ID,
SOURCE_TABLE,
CUSTOMER_TRX_ID,
CUSTOMER_TRX_LINE_ID,
LINE_TYPE,
TAX_AMOUNT,
ED_TAX_AMOUNT,
UNED_TAX_AMOUNT)
VALUES (
p_gt_id, -- gt_id
p_adjustment_id, -- source_id
'ADJ' , -- source_table
p_customer_trx_id, -- customer_trx_id
p_customer_trx_line_id, -- customer_Trx_line_id
'TAX', -- line_type
l_tax_proration, -- tax_amount
NULL, -- ed_tax_amount
NULL -- uned_tax_amount
);