[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_last_updated_by NUMBER(15);
SELECT status_code,
batch_type,
partner_cust_account_id,
partner_party_id,
report_start_date,
report_end_date,
batch_number,
last_updated_by,
currency_code,
partner_claim_number,
org_id
FROM ozf_resale_batches_all
WHERE resale_batch_id = p_id;
SELECT count(1)
FROM ozf_resale_lines_int
WHERE resale_batch_id = p_id
AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;
SELECT resale_line_int_id
FROM ozf_resale_lines_int
WHERE resale_batch_id = p_id
AND order_number = p_order_number
AND sold_from_cust_account_id = p_cust_id
AND date_ordered = p_date
AND status_code = 'PROCESSED';
SELECT a.resale_header_id
FROM ozf_resale_headers a
, ozf_resale_lines_int b
, ozf_resale_lines c
WHERE b.resale_batch_id = p_id
AND b.order_number = p_order_number
AND b.sold_from_cust_account_id = p_cust_id
AND b.date_ordered = p_date
AND b.status_code = 'PROCESSED'
-- AND b.status_code IN ('DUPLICATED', 'PROCESSED')
AND b.duplicated_line_id = c.resale_line_id
AND c.resale_header_id = a.resale_header_id;
SELECT DISTINCT order_number,
sold_from_cust_account_id,
date_ordered
FROM ozf_resale_lines_int
WHERE resale_batch_id = p_id
AND status_code = 'PROCESSED'
-- AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED)
-- AND duplicated_adjustment_id <> -1
ORDER BY date_ordered;
SELECT auto_tp_accrual_flag
FROM ozf_sys_parameters;
SELECT amount
FROM ozf_claims
WHERE claim_id = p_claim_id;
SELECT end_cust_relation_flag
-- BUG 4992408 (+)
-- FROM ozf_sys_parameters_all;
SELECT DISTINCT bill_to_party_name
, bill_to_address
, bill_to_city
, bill_to_state
, bill_to_postal_code
, bill_to_country
FROM ozf_resale_lines_int_all
WHERE resale_batch_id = cv_resale_batch_id
AND status_code = 'PROCESSED'
AND ( duplicated_line_id IS NULL
OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))
AND bill_to_party_id IS NULL
AND bill_to_cust_account_id IS NULL
AND bill_to_party_name IS NOT NULL;
SELECT DISTINCT end_cust_party_name
, end_cust_address
, end_cust_city
, end_cust_state
, end_cust_postal_code
, end_cust_country
, end_cust_site_use_code
FROM ozf_resale_lines_int_all
WHERE resale_batch_id = cv_resale_batch_id
AND status_code = 'PROCESSED'
AND ( duplicated_line_id IS NULL
OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))
AND end_cust_party_id IS NULL
AND end_cust_party_name IS NOT NULL;
SELECT NVL(ospa.ship_debit_accrual_flag, 'F')
FROM ozf_sys_parameters_all ospa,
ozf_resale_batches_all orba
WHERE ospa.org_id = orba.org_id
AND orba.resale_batch_id = p_resale_batch_id;
SELECT
BUDGET_AMOUNT_TC,
BUDGET_AMOUNT_FC,
AVAILABLE_AMOUNT,
TRANSFERED_IN_AMT,
TRANSFERED_OUT_AMT,
PLANNED_AMT,
COMMITTED_AMT,
EARNED_AMT,
PAID_AMT,
RECAL_COMMITTED,
ROLLUP_ORIGINAL_BUDGET,
ROLLUP_TRANSFERED_IN_AMT,
ROLLUP_TRANSFERED_OUT_AMT,
ROLLUP_HOLDBACK_AMT,
ROLLUP_PLANNED_AMT,
ROLLUP_COMMITTED_AMT,
ROLLUP_RECAL_COMMITTED,
ROLLUP_EARNED_AMT,
ROLLUP_PAID_AMT,
UTILIZED_AMT,
ROLLUP_UTILIZED_AMT
FROM OZF_FUNDS_ALL_B
WHERE FUND_ID = p_fund_id;
l_last_updated_by,
l_currency_code,
l_partner_claim_num,
l_org_id; -- Setting MOAC context - Bug#9494377
OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
p_id_value => p_resale_batch_id
,p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_BATCH
,p_error_code => 'OZF_CHBK_BUDGET_NULL'
,p_column_name => NULL
,p_column_value => NULL
,x_return_status => l_return_status
);
UPDATE ozf_resale_batches_all
SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
WHERE resale_batch_id = p_resale_batch_id;
UPDATE ozf_resale_lines_int_all
SET bill_to_party_id = l_new_party_rec.party_id
, bill_to_party_site_id = l_new_party_rec.party_site_id
WHERE resale_batch_id = p_resale_batch_id
AND bill_to_party_id IS NULL
AND bill_to_cust_account_id IS NULL
AND bill_to_party_name = l_orig_billto_cust_tbl(i).bill_to_party_name
AND bill_to_address = l_orig_billto_cust_tbl(i).bill_to_address
AND bill_to_city = l_orig_billto_cust_tbl(i).bill_to_city
AND bill_to_state = l_orig_billto_cust_tbl(i).bill_to_state
AND bill_to_postal_code = l_orig_billto_cust_tbl(i).bill_to_postal_code
AND bill_to_country = l_orig_billto_cust_tbl(i).bill_to_country;
UPDATE ozf_resale_lines_int_all
SET end_cust_party_id = l_new_party_rec.party_id
, end_cust_party_site_id = l_new_party_rec.party_site_id
WHERE resale_batch_id = p_resale_batch_id
AND end_cust_party_id IS NULL
AND end_cust_party_name = l_orig_end_cust_tbl(i).end_cust_party_name
AND end_cust_address = l_orig_end_cust_tbl(i).end_cust_address
AND end_cust_city = l_orig_end_cust_tbl(i).end_cust_city
AND end_cust_state = l_orig_end_cust_tbl(i).end_cust_state
AND end_cust_postal_code = l_orig_end_cust_tbl(i).end_cust_postal_code
AND end_cust_country = l_orig_end_cust_tbl(i).end_cust_country
AND end_cust_site_use_code = l_orig_end_cust_tbl(i).end_cust_site_use_code;
l_order_num_tbl.DELETE;
l_dup_header_id_tbl.DELETE;
UPDATE ozf_resale_lines_int_all
SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
dispute_code = 'OZF_RESALE_MULTI_HEADER',
followup_action_code = 'C',
response_type = 'CA',
response_code = 'N'
WHERE resale_batch_id = p_resale_batch_id
AND order_number = l_order_num_tbl(k).order_number
AND sold_from_cust_account_id = l_order_num_tbl(k).sold_from_cust_account_id
AND date_ordered = l_order_num_tbl(k).date_ordered
AND status_code in (OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED);
l_valid_line_id_tbl.DELETE;
UPDATE ozf_resale_lines_int
SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
dispute_code = 'OZF_LT_INVT',
followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
response_type = 'CA',
response_code = 'N'
WHERE resale_line_int_id = l_line_int_rec.resale_line_int_id;
UPDATE ozf_resale_batches
SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
WHERE resale_batch_id = l_line_int_rec.resale_batch_id;
OZF_RESALE_COMMON_PVT.Insert_Resale_Header(
p_api_version => 1
,p_init_msg_list => FND_API.G_FALSE
,p_commit => FND_API.G_FALSE
,p_validation_level => FND_API.G_VALID_LEVEL_FULL
,p_line_int_rec => l_line_int_rec
,x_header_id => l_header_id
,x_return_status => l_return_status
,x_msg_data => l_msg_data
,x_msg_count => l_msg_count
);
OZF_RESALE_COMMON_PVT.Insert_Resale_Line(
p_api_version => 1
,p_init_msg_list => FND_API.G_FALSE
,p_commit => FND_API.G_FALSE
,p_validation_level => FND_API.G_VALID_LEVEL_FULL
,p_line_int_rec => l_line_int_rec
,p_header_id => l_header_id
,x_line_id => l_line_id
,x_return_status => l_return_status
,x_msg_data => l_msg_data
,x_msg_count => l_msg_count
);
OZF_SALES_TRANSACTIONS_PVT.Update_Inventory_Tmp(
p_api_version => 1.0
,p_init_msg_list => FND_API.G_FALSE
,p_validation_level => FND_API.G_VALID_LEVEL_FULL
,p_sales_transaction_id => l_sales_transaction_id
,x_return_status => l_return_status
,x_msg_data => l_msg_data
,x_msg_count => l_msg_count
);
OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(
p_api_version => 1
,p_init_msg_list => FND_API.G_FALSE
,p_commit => FND_API.G_FALSE
,p_validation_level => FND_API.G_VALID_LEVEL_FULL
,p_resale_batch_id => p_resale_batch_id
,p_line_id => l_line_id
,x_return_status => l_return_status
,x_msg_data => l_msg_data
,x_msg_count => l_msg_count
);
,p_approver_id => l_last_updated_by
,x_return_status => l_return_status
,x_msg_data => l_msg_data
,x_msg_count => l_msg_count
,p_batch_type => 'CHARGEBACK'
,px_ozf_act_budgets_tbl => ozf_act_budgets_tbl
,px_ozf_funds_old_rectype => ozf_funds_old_rectype
,px_ozf_funds_new_tbl => ozf_funds_new_tbl
);
-- Call for the update of funds and budgets where the update happens in one shot.
IF ozf_funds_new_tbl.COUNT > 0 THEN
OZF_UTILITY_PVT.UPDATE_OZF_FUNDS_ALL_B(p_resale_batch_id, x_return_status, x_fund_table_status, ozf_funds_new_tbl, 'CHARGEBACK');
OZF_UTILITY_PVT.UPDATE_OZF_ACT_BUDGETS(p_resale_batch_id, x_return_status, x_budget_table_status, ozf_act_budgets_tbl, 'CHARGEBACK');
OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
p_api_version => 1.0
,p_init_msg_list => FND_API.G_FALSE
,p_commit => FND_API.G_FALSE
,p_validation_level => FND_API.G_VALID_LEVEL_FULL
,p_resale_batch_id => p_resale_batch_id
,x_return_status => l_return_status
,x_msg_data => l_msg_data
,x_msg_count => l_msg_count
);
UPDATE ozf_resale_lines_int
SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
WHERE resale_batch_id = p_resale_batch_id
AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED;
UPDATE ozf_resale_lines_int
SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
WHERE resale_batch_id = p_resale_batch_id
AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED);
-- UPDATE batch status to PENDING_CLOSE as the records are stored in the staging tables
-- and run the concurrent prgm to update the main tables.
IF x_fund_table_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_CLOSE
OR x_budget_table_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_CLOSE THEN
UPDATE ozf_resale_batches
SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_CLOSE,
paid_amount = l_amount_claimed,
last_updated_by = NVL(fnd_global.user_id, -1),
last_update_date = SYSDATE
WHERE resale_batch_id = p_resale_batch_id;
-- UPDATE batch status to closed.
UPDATE ozf_resale_batches
SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED,
paid_amount = l_amount_claimed,
last_updated_by = NVL(fnd_global.user_id, -1),
last_update_date = SYSDATE
WHERE resale_batch_id = p_resale_batch_id;
SELECT resale_line_int_id,
'OZF_RESALE_PUR_PRICE_MISSING',
'PURCHASE_PRICE',
NULL
FROM ozf_resale_lines_int_all
WHERE resale_batch_id = p_batch_id
AND status_code IN (OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED)
AND tracing_flag = 'F'
AND purchase_price IS NULL;
l_id_tbl.DELETE;
l_err_tbl.DELETE;
l_col_tbl.DELETE;
l_val_tbl.DELETE;
OZF_RESALE_COMMON_PVT.Bulk_Insert_Resale_Log (
p_id_value => l_id_tbl,
p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
p_error_code => l_err_tbl,
p_column_name => l_col_tbl,
p_column_value => l_val_tbl,
p_batch_id => p_resale_batch_id, --bug # 5997978 fixed
x_return_status => l_return_status
);
SELECT order_number
, sold_from_cust_account_id
, date_ordered
FROM ozf_resale_lines_int
WHERE resale_line_int_id = p_id;
SELECT gs.currency_code
FROM gl_sets_of_books gs,
ozf_sys_parameters osp
WHERE gs.set_of_books_id = osp.set_of_books_id
AND osp.org_id = MO_GLOBAL.get_current_org_id();
SELECT resale_line_int_id, 'OZF_RESALE_PRICE_ERROR', NULL, NULL
FROM ozf_resale_lines_int
WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
AND order_number = l_order_number
AND date_ordered = l_date_ordered
AND sold_from_cust_account_id =l_cust_account_id
AND dispute_code is null
AND resale_batch_id = p_resale_batch_id;
p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UPDATED;
update ozf_resale_lines_int
set status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
dispute_code = 'OZF_RESALE_PRICE_ERROR',
followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
response_type = 'CA',
response_code = 'N'
where resale_line_int_id = p_line_tbl(i).chargeback_int_id;
OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
p_id_value => p_line_tbl(i).chargeback_int_id,
p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
p_error_code => p_line_tbl(i).pricing_status_code,
p_error_message => p_line_tbl(i).pricing_status_text,
p_column_name => NULL,
p_column_value => NULL,
x_return_status => l_return_status);
OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
p_id_value => p_line_tbl(i).chargeback_int_id,
p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
p_error_code => 'OZF_RESALE_PRICE_ERROR',
p_column_name => NULL,
p_column_value => NULL,
x_return_status => l_return_status);
l_id_tbl.DELETE;
l_err_tbl.DELETE;
l_col_tbl.DELETE;
l_val_tbl.DELETE;
OZF_RESALE_COMMON_PVT.Bulk_Insert_Resale_Log (
p_id_value => l_id_tbl,
p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
p_error_code => l_err_tbl,
p_column_name => l_col_tbl,
p_column_value => l_val_tbl,
p_batch_id => p_resale_batch_id, --bug # 5997978 fixed
x_return_status => l_return_status
);
UPDATE ozf_resale_lines_int_all
SET status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
dispute_code = 'OZF_RESALE_PRICE_ERROR',
followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
response_type = 'CA',
response_code = 'N'
WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
AND order_number = l_order_number
AND date_ordered = l_date_ordered
AND sold_from_cust_account_id =l_cust_account_id
AND dispute_code is null
AND resale_batch_id = p_resale_batch_id;
p_line_tbl(i).pricing_status_code <> QP_PREQ_PUB.G_STATUS_UPDATED;
OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
p_id_value => p_line_tbl(i).chargeback_int_id,
p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
p_error_code => 'OZF_RESALE_INV_LEVEL_ERROR',
p_column_name => NULL,
p_column_value => NULL,
x_return_status => l_return_status);
UPDATE ozf_resale_lines_int
SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
dispute_code = 'OZF_LT_INVT',
followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
response_type = 'CA',
response_code = 'N'
WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id;
UPDATE ozf_resale_batches
SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
WHERE resale_batch_id = l_resale_int_rec.resale_batch_id;
OZF_RESALE_COMMON_PVT.Update_Line_Calculations(
p_resale_line_int_rec => l_resale_int_rec,
p_unit_price => p_line_tbl(i).unit_price,
p_line_quantity => p_line_tbl(i).line_quantity,
p_allowed_amount => l_allowed_amount,
x_return_status => l_return_status);
SELECT *
FROM ozf_resale_lines_int
WHERE order_number = p_order_number
AND sold_from_cust_account_id= p_id
AND date_ordered = p_date
AND status_code = 'OPEN'
-- AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED)
-- AND duplicated_adjustment_id IS NULL
-- bug # 6821886 fixed by ateotia (+)
AND resale_batch_id = p_batch_id;
SELECT *
FROM ozf_resale_lines_int
WHERE order_number = p_order_number
AND sold_from_cust_account_id= p_id
AND date_ordered = p_date
AND status_code = 'OPEN'
AND resale_batch_id = p_batch_id
AND tracing_flag = 'T';
OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
p_id_value => l_order_set_trc_tbl(i).resale_line_int_id,
p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
p_error_code => 'OZF_RESALE_INV_LEVEL_ERROR',
p_column_name => NULL,
p_column_value => NULL,
x_return_status => l_return_status);
UPDATE ozf_resale_lines_int
SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
dispute_code = 'OZF_LT_INVT',
followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
response_type = 'CA',
response_code = 'N'
WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id;
UPDATE ozf_resale_batches
SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
WHERE resale_batch_id = l_resale_int_rec.resale_batch_id;
l_control_rec.temp_table_insert_flag := 'N';
IF l_order_set_tbl.EXISTS(1) THEN l_order_set_tbl.DELETE; END IF;
IF l_line_tbl.EXISTS(1) THEN l_line_tbl.DELETE; END IF;
IF l_ldets_tbl.EXISTS(1) THEN l_ldets_tbl.DELETE; END IF;
IF l_related_lines_tbl.EXISTS(1) THEN l_related_lines_tbl.DELETE; END IF;
IF OZF_ORDER_PRICE_PVT.g_line_rec_tbl.EXISTS(1) THEN OZF_ORDER_PRICE_PVT.g_line_rec_tbl.DELETE; END IF;
DELETE FROM ozf_resale_logs
WHERE resale_id = l_order_set_tbl(J).resale_line_int_id
AND resale_id_type = OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE;
SELECT DISTINCT order_number,
sold_from_cust_account_id,
date_ordered
FROM ozf_resale_lines_int
WHERE status_code = 'OPEN' --(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED)
AND resale_batch_id = p_resale_batch_id
--AND (duplicated_adjustment_id IS NULL OR
-- duplicated_adjustment_id = -1 )
ORDER BY date_ordered;
SELECT partner_party_id, report_start_date, report_end_date
FROM ozf_resale_batches
WHERE resale_batch_id = p_id;
OZF_RESALE_COMMON_PVT.Delete_Log(
p_api_version => 1.0
,p_init_msg_list => FND_API.G_FALSE
,p_commit => FND_API.G_FALSE
,p_validation_level => FND_API.G_VALID_LEVEL_FULL
,p_resale_batch_id => p_resale_batch_id
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
l_order_num_tbl.DELETE;
l_cust_account_id_tbl.DELETE;
l_order_date_tbl.DELETE;
OZF_UTILITY_PVT.debug_message('/*--- before get_order_price Insert resale log done ---*/');
OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
p_id_value => l_line_tbl(j).chargeback_int_id,
p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
p_error_code => 'OZF_GET_ORDER_PRIC_ERR',
p_column_name => NULL,
p_column_value => NULL,
x_return_status => l_return_status);
OZF_UTILITY_PVT.debug_message('/*--- After get_order_price Insert resale log done ---*/');
OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
p_id_value => l_line_tbl(j).chargeback_int_id,
p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
p_error_code => 'OZF_PROC_PRIC_RESLT_ERR',
p_column_name => NULL,
p_column_value => NULL,
x_return_status => l_return_status);
OZF_UTILITY_PVT.debug_message('/*--- After process_pricing_result Insert resale log done ---*/');
UPDATE ozf_resale_lines_int
SET status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
dispute_code = 'OZF_PROC_PRIC_RESLT_ERR',
followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
response_type = 'CA',
response_code = 'N'
WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
AND order_number = l_order_num_tbl(i)
AND date_ordered = l_order_date_tbl(i)
AND sold_from_cust_account_id =l_cust_account_id_tbl(i)
AND dispute_code is null
AND resale_batch_id = p_resale_batch_id;
UPDATE ozf_resale_lines_int_all
SET status_code= 'PROCESSED'
WHERE status_code = 'OPEN'
AND order_number = l_order_num_tbl(i)
AND sold_from_cust_account_id = l_cust_account_id_tbl(i)
AND date_ordered = l_order_date_tbl(i)
AND tracing_flag = 'T'
AND resale_batch_id = p_resale_batch_id; -- bug 5222273
OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
p_api_version => 1.0
,p_init_msg_list => FND_API.G_FALSE
,p_commit => FND_API.G_FALSE
,p_validation_level => FND_API.G_VALID_LEVEL_FULL
,p_resale_batch_id => p_resale_batch_id
,x_return_status => l_return_status
,x_msg_data => l_msg_data
,x_msg_count => l_msg_count
);