[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_last_updated_by NUMBER;
l_last_update_login NUMBER;
SELECT COUNT(set_of_books_id)
FROM ozf_sys_parameters;
l_last_updated_by := NVL(FND_GLOBAL.user_id,-1);
l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
OZF_Utility_PVT.debug_message(l_full_name ||': insert');
INSERT INTO ozf_sys_parameters_all (
set_of_books_id
,object_version_number
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,request_id
,program_application_id
,program_update_date
,program_id
,created_from
,post_to_gl
,transfer_to_gl_in
,ap_payment_term_id
,rounding_level_flag
,gl_id_rounding
,gl_id_ded_clearing
,gl_id_ded_adj
,gl_id_accr_promo_liab
,gl_id_ded_adj_clearing
,gl_rec_ded_account
,gl_rec_clearing_account
,gl_cost_adjustment_acct
,gl_contra_liability_acct
,gl_pp_accrual_acct
,gl_date_type
,days_due
,claim_type_id
,reason_code_id
,autopay_claim_type_id
,autopay_reason_code_id
,autopay_flag
,autopay_periodicity
,autopay_periodicity_type
,accounting_method_option
,billback_trx_type_id
,cm_trx_type_id
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,org_id
,batch_source_id
,payables_source
,default_owner_id
,auto_assign_flag
,exchange_rate_type
,order_type_id
--11.5.10 enhancements
, gl_acct_for_offinv_flag
--, short_payment_reason_code_id
, cb_trx_type_id
, pos_write_off_threshold
, neg_write_off_threshold
, adj_rec_trx_id
, wo_rec_trx_id
, neg_wo_rec_trx_id
, un_earned_pay_allow_to
, un_earned_pay_thold_type
, un_earned_pay_thold_amount
, un_earned_pay_thold_flag
, header_tolerance_calc_code
, header_tolerance_operand
, line_tolerance_calc_code
, line_tolerance_operand
, ship_debit_accrual_flag
, ship_debit_calc_type
, inventory_tracking_flag
, end_cust_relation_flag
, auto_tp_accrual_flag
, gl_balancing_flex_value
, prorate_earnings_flag
, sales_credit_default_type
, net_amt_for_mass_settle_flag
,claim_tax_incl_flag
--For Rule Based Settlement
,rule_based
,approval_new_credit
,approval_matched_credit
,cust_name_match_type
,credit_matching_thold_type
,credit_tolerance_operand
-- For Price Protection Parallel Approval ER
,automate_notification_days
-- For SSD Default Adjustment Types
,ssd_inc_adj_type_id
,ssd_dec_adj_type_id
,ssd_imd_claim_flag
)
VALUES (
l_sys_parameters_rec.set_of_books_id
,l_object_version_number
,SYSDATE -- LAST_UPDATE_DATE
,l_last_updated_by -- LAST_UPDATED_BY
,SYSDATE -- CREATION_DATE
,l_created_by -- CREATED_BY
,l_last_update_login -- LAST_UPDATE_LOGIN
,FND_GLOBAL.CONC_REQUEST_ID -- REQUEST_ID
,FND_GLOBAL.PROG_APPL_ID -- PROGRAM_APPLICATION_ID
,SYSDATE -- PROGRAM_UPDATE_DATE
,FND_GLOBAL.CONC_PROGRAM_ID -- PROGRAM_ID
,l_sys_parameters_rec.created_from -- CREATED_FROM
,l_post_to_gl
,l_transfer_to_gl
,l_sys_parameters_rec.ap_payment_term_id
,l_sys_parameters_rec.rounding_level_flag
,l_sys_parameters_rec.gl_id_rounding
,l_sys_parameters_rec.gl_id_ded_clearing
,l_sys_parameters_rec.gl_id_ded_adj
,l_sys_parameters_rec.gl_id_accr_promo_liab
,l_sys_parameters_rec.gl_id_ded_adj_clearing
,l_sys_parameters_rec.gl_rec_ded_account
,l_sys_parameters_rec.gl_rec_clearing_account
,l_sys_parameters_rec.gl_cost_adjustment_acct
,l_sys_parameters_rec.gl_contra_liability_acct
,l_sys_parameters_rec.gl_pp_accrual_acct
,l_sys_parameters_rec.gl_date_type
,l_sys_parameters_rec.days_due
,l_sys_parameters_rec.claim_type_id
,l_sys_parameters_rec.reason_code_id
,l_sys_parameters_rec.autopay_claim_type_id
,l_sys_parameters_rec.autopay_reason_code_id
,l_sys_parameters_rec.autopay_flag
,l_sys_parameters_rec.autopay_periodicity
,l_sys_parameters_rec.autopay_periodicity_type
,l_sys_parameters_rec.accounting_method_option
,l_sys_parameters_rec.billback_trx_type_id
,l_sys_parameters_rec.cm_trx_type_id
,l_sys_parameters_rec.attribute_category
,l_sys_parameters_rec.attribute1
,l_sys_parameters_rec.attribute2
,l_sys_parameters_rec.attribute3
,l_sys_parameters_rec.attribute4
,l_sys_parameters_rec.attribute5
,l_sys_parameters_rec.attribute6
,l_sys_parameters_rec.attribute7
,l_sys_parameters_rec.attribute8
,l_sys_parameters_rec.attribute9
,l_sys_parameters_rec.attribute10
,l_sys_parameters_rec.attribute11
,l_sys_parameters_rec.attribute12
,l_sys_parameters_rec.attribute13
,l_sys_parameters_rec.attribute14
,l_sys_parameters_rec.attribute15
,l_org_id -- org_id
,l_sys_parameters_rec.batch_source_id
,l_sys_parameters_rec.payables_source
,l_sys_parameters_rec.default_owner_id
,l_sys_parameters_rec.auto_assign_flag
,l_sys_parameters_rec.exchange_rate_type
,l_sys_parameters_rec.order_type_id
--11.5.10 enhancements
,l_sys_parameters_rec.gl_acct_for_offinv_flag
--,l_sys_parameters_rec.short_payment_reason_code_id
,l_sys_parameters_rec.cb_trx_type_id
,l_sys_parameters_rec.pos_write_off_threshold
,l_sys_parameters_rec.neg_write_off_threshold
,l_sys_parameters_rec.adj_rec_trx_id
,l_sys_parameters_rec.wo_rec_trx_id
,l_sys_parameters_rec.neg_wo_rec_trx_id
,l_sys_parameters_rec.un_earned_pay_allow_to
,l_sys_parameters_rec.un_earned_pay_thold_type
,l_sys_parameters_rec.un_earned_pay_threshold
,l_sys_parameters_rec.un_earned_pay_thold_flag
,l_sys_parameters_rec.header_tolerance_calc_code
,l_sys_parameters_rec.header_tolerance_operand
,l_sys_parameters_rec.line_tolerance_calc_code
,l_sys_parameters_rec.line_tolerance_operand
,l_sys_parameters_rec.ship_debit_accrual_flag
,l_sys_parameters_rec.ship_debit_calc_type
,l_sys_parameters_rec.inventory_tracking_flag
,l_sys_parameters_rec.end_cust_relation_flag
,l_sys_parameters_rec.auto_tp_accrual_flag
,l_sys_parameters_rec.gl_balancing_flex_value
,l_sys_parameters_rec.prorate_earnings_flag
,l_sys_parameters_rec.sales_credit_default_type
,l_sys_parameters_rec.net_amt_for_mass_settle_flag
,l_sys_parameters_rec.claim_tax_incl_flag
,l_sys_parameters_rec.rule_based
,l_sys_parameters_rec.approval_new_credit
,l_sys_parameters_rec.approval_matched_credit
,l_sys_parameters_rec.cust_name_match_type
,l_sys_parameters_rec.credit_matching_thold_type
,l_sys_parameters_rec.credit_tolerance_operand
,l_sys_parameters_rec.automate_notification_days
,l_sys_parameters_rec.ssd_inc_adj_type_id
,l_sys_parameters_rec.ssd_dec_adj_type_id
,l_sys_parameters_rec.ssd_imd_claim_flag
);
PROCEDURE Delete_Sys_Parameters(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 := FND_API.g_false
,p_commit IN VARCHAR2 := FND_API.g_false
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_set_of_books_id IN NUMBER
,p_object_version IN NUMBER
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Sys_Parameters';
SAVEPOINT Delete_Sys_Parameters;
OZF_Utility_PVT.debug_message(l_full_name ||': delete');
DELETE FROM ozf_sys_parameters_all
WHERE set_of_books_id = p_set_of_books_id
AND object_version_number = p_object_version
AND org_id = l_org_id; -- R12 Enhancements
ROLLBACK TO Delete_Sys_Parameters;
ROLLBACK TO Delete_Sys_Parameters;
ROLLBACK TO Delete_Sys_Parameters;
END Delete_Sys_Parameters;
SELECT set_of_books_id
FROM ozf_sys_parameters_all
WHERE set_of_books_id = p_set_of_books_id
AND object_version_number = p_object_version
FOR UPDATE OF set_of_books_id NOWAIT;
PROCEDURE Update_Sys_Parameters(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 := FND_API.g_false
,p_commit IN VARCHAR2 := FND_API.g_false
,p_validation_level IN NUMBER := FND_API.g_valid_level_full
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_sys_parameters_rec IN sys_parameters_rec_type
,p_mode IN VARCHAR2 := JTF_PLSQL_API.g_update
,x_object_version_number OUT NOCOPY NUMBER
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'Update_Sys_Parameters';
l_last_updated_by NUMBER;
l_last_update_login NUMBER;
SAVEPOINT Update_Sys_Parameters;
l_last_updated_by := NVL(FND_GLOBAL.user_id,-1);
l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
p_validation_mode => JTF_PLSQL_API.g_update,
x_return_status => l_return_status
);
OZF_Utility_PVT.debug_message(l_full_name ||': update');
UPDATE ozf_sys_parameters_all SET
set_of_books_id = l_sys_parameters_rec.set_of_books_id
,object_version_number = l_object_version_number
,last_update_date = SYSDATE
,last_updated_by = l_last_updated_by
,last_update_login = l_last_update_login
,request_id = FND_GLOBAL.CONC_REQUEST_ID
,program_application_id = FND_GLOBAL.PROG_APPL_ID
,program_update_date = SYSDATE
,program_id = FND_GLOBAL.CONC_PROGRAM_ID
,created_from = l_sys_parameters_rec.created_from
,post_to_gl = l_sys_parameters_rec.post_to_gl
,transfer_to_gl_in = l_sys_parameters_rec.transfer_to_gl_in
,ap_payment_term_id = l_sys_parameters_rec.ap_payment_term_id
,rounding_level_flag = l_sys_parameters_rec.rounding_level_flag
,gl_id_rounding = l_sys_parameters_rec.gl_id_rounding
,gl_id_ded_clearing = l_sys_parameters_rec.gl_id_ded_clearing
,gl_id_ded_adj = l_sys_parameters_rec.gl_id_ded_adj
,gl_id_accr_promo_liab = l_sys_parameters_rec.gl_id_accr_promo_liab
,gl_id_ded_adj_clearing = l_sys_parameters_rec.gl_id_ded_adj_clearing
,gl_rec_ded_account = l_sys_parameters_rec.gl_rec_ded_account
,gl_rec_clearing_account = l_sys_parameters_rec.gl_rec_clearing_account
,gl_cost_adjustment_acct = l_sys_parameters_rec.gl_cost_adjustment_acct
,gl_contra_liability_acct = l_sys_parameters_rec.gl_contra_liability_acct
,gl_pp_accrual_acct = l_sys_parameters_rec.gl_pp_accrual_acct
,gl_date_type = l_sys_parameters_rec.gl_date_type
,days_due = l_sys_parameters_rec.days_due
,claim_type_id = l_sys_parameters_rec.claim_type_id
,reason_code_id = l_sys_parameters_rec.reason_code_id
,autopay_claim_type_id = l_sys_parameters_rec.autopay_claim_type_id
,autopay_reason_code_id = l_sys_parameters_rec.autopay_reason_code_id
,autopay_flag = l_sys_parameters_rec.autopay_flag
,autopay_periodicity = l_sys_parameters_rec.autopay_periodicity
,autopay_periodicity_type = l_sys_parameters_rec.autopay_periodicity_type
,accounting_method_option = l_sys_parameters_rec.accounting_method_option
,billback_trx_type_id = l_sys_parameters_rec.billback_trx_type_id
,cm_trx_type_id = l_sys_parameters_rec.cm_trx_type_id
,attribute_category = l_sys_parameters_rec.attribute_category
,attribute1 = l_sys_parameters_rec.attribute1
,attribute2 = l_sys_parameters_rec.attribute2
,attribute3 = l_sys_parameters_rec.attribute3
,attribute4 = l_sys_parameters_rec.attribute4
,attribute5 = l_sys_parameters_rec.attribute5
,attribute6 = l_sys_parameters_rec.attribute6
,attribute7 = l_sys_parameters_rec.attribute7
,attribute8 = l_sys_parameters_rec.attribute8
,attribute9 = l_sys_parameters_rec.attribute9
,attribute10 = l_sys_parameters_rec.attribute10
,attribute11 = l_sys_parameters_rec.attribute11
,attribute12 = l_sys_parameters_rec.attribute12
,attribute13 = l_sys_parameters_rec.attribute13
,attribute14 = l_sys_parameters_rec.attribute14
,attribute15 = l_sys_parameters_rec.attribute15
--,org_id = l_sys_parameters_rec.org_id
,batch_source_id = l_sys_parameters_rec.batch_source_id
,payables_source = l_sys_parameters_rec.payables_source
,default_owner_id = l_sys_parameters_rec.default_owner_id
,auto_assign_flag = l_sys_parameters_rec.auto_assign_flag
,exchange_rate_type = l_sys_parameters_rec.exchange_rate_type
,order_type_id = l_sys_parameters_rec.order_type_id
--11.5.10 enhancements
,gl_acct_for_offinv_flag = l_sys_parameters_rec.gl_acct_for_offinv_flag
--,short_payment_reason_code_id = l_sys_parameters_rec.short_payment_reason_code_id
,cb_trx_type_id = l_sys_parameters_rec.cb_trx_type_id
,pos_write_off_threshold = l_sys_parameters_rec.pos_write_off_threshold
,neg_write_off_threshold = l_sys_parameters_rec.neg_write_off_threshold
,adj_rec_trx_id = l_sys_parameters_rec.adj_rec_trx_id
,wo_rec_trx_id = l_sys_parameters_rec.wo_rec_trx_id
,neg_wo_rec_trx_id = l_sys_parameters_rec.neg_wo_rec_trx_id
,un_earned_pay_allow_to = l_sys_parameters_rec.un_earned_pay_allow_to
,un_earned_pay_thold_type = l_sys_parameters_rec.un_earned_pay_thold_type
,un_earned_pay_thold_amount = l_sys_parameters_rec.un_earned_pay_threshold
,un_earned_pay_thold_flag = l_sys_parameters_rec.un_earned_pay_thold_flag
,header_tolerance_calc_code = l_sys_parameters_rec.header_tolerance_calc_code
,header_tolerance_operand = l_sys_parameters_rec.header_tolerance_operand
,line_tolerance_calc_code = l_sys_parameters_rec.line_tolerance_calc_code
,line_tolerance_operand = l_sys_parameters_rec.line_tolerance_operand
,ship_debit_accrual_flag = l_sys_parameters_rec.ship_debit_accrual_flag
,ship_debit_calc_type = l_sys_parameters_rec.ship_debit_calc_type
,inventory_tracking_flag = l_sys_parameters_rec.inventory_tracking_flag
,end_cust_relation_flag = l_sys_parameters_rec.end_cust_relation_flag
,auto_tp_accrual_flag = l_sys_parameters_rec.auto_tp_accrual_flag
,gl_balancing_flex_value = l_sys_parameters_rec.gl_balancing_flex_value
,prorate_earnings_flag = l_sys_parameters_rec.prorate_earnings_flag
,sales_credit_default_type = l_sys_parameters_rec.sales_credit_default_type
,net_amt_for_mass_settle_flag = l_sys_parameters_rec.net_amt_for_mass_settle_flag
,claim_tax_incl_flag = l_sys_parameters_rec.claim_tax_incl_flag
-- For Rule Based Settlement
,rule_based = l_sys_parameters_rec.rule_based
,approval_new_credit = l_sys_parameters_rec.approval_new_credit
,approval_matched_credit = l_sys_parameters_rec.approval_matched_credit
,cust_name_match_type = l_sys_parameters_rec.cust_name_match_type
,credit_matching_thold_type = l_sys_parameters_rec.credit_matching_thold_type
,credit_tolerance_operand = l_sys_parameters_rec.credit_tolerance_operand
-- For Price Protection Parallel Approval ER
,automate_notification_days = l_sys_parameters_rec.automate_notification_days
-- For SSD Default Adjustment Types
,ssd_inc_adj_type_id = l_sys_parameters_rec.ssd_inc_adj_type_id
,ssd_dec_adj_type_id = l_sys_parameters_rec.ssd_dec_adj_type_id
,ssd_imd_claim_flag = l_sys_parameters_rec.ssd_imd_claim_flag
WHERE object_version_number = l_sys_parameters_rec.object_version_number
--AND org_id = l_org_id; -- R12 Enhancements
ROLLBACK TO Update_Sys_Parameters;
ROLLBACK TO Update_Sys_Parameters;
ROLLBACK TO Update_Sys_Parameters;
END Update_Sys_Parameters;
SELECT 1
FROM oe_transaction_types_vl
WHERE transaction_type_id = cv_id;
SELECT
set_of_books_id,
object_version_number,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
request_id,
program_application_id,
program_update_date,
program_id,
created_from,
post_to_gl,
transfer_to_gl_in,
ap_payment_term_id,
rounding_level_flag,
gl_id_rounding,
gl_id_ded_clearing,
gl_id_ded_adj,
gl_id_accr_promo_liab,
gl_id_ded_adj_clearing,
gl_rec_ded_account,
gl_rec_clearing_account,
gl_cost_adjustment_acct,
gl_contra_liability_acct ,
gl_pp_accrual_acct ,
gl_date_type,
days_due,
claim_type_id,
reason_code_id,
autopay_claim_type_id,
autopay_reason_code_id,
autopay_flag,
autopay_periodicity,
autopay_periodicity_type,
accounting_method_option,
billback_trx_type_id,
cm_trx_type_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
org_id,
batch_source_id,
payables_source,
default_owner_id,
auto_assign_flag,
exchange_rate_type,
order_type_id,
--11.5.10 enhancements.
gl_acct_for_offinv_flag,
--short_payment_reason_code_id,
cb_trx_type_id,
pos_write_off_threshold,
neg_write_off_threshold,
adj_rec_trx_id,
wo_rec_trx_id,
neg_wo_rec_trx_id,
un_earned_pay_allow_to,
un_earned_pay_thold_type,
un_earned_pay_thold_amount,
un_earned_pay_thold_flag,
header_tolerance_calc_code,
header_tolerance_operand,
line_tolerance_calc_code,
line_tolerance_operand,
ship_debit_accrual_flag,
ship_debit_calc_type,
inventory_tracking_flag,
end_cust_relation_flag,
auto_tp_accrual_flag,
gl_balancing_flex_value,
prorate_earnings_flag,
sales_credit_default_type,
net_amt_for_mass_settle_flag,
claim_tax_incl_flag,
--For Rule Based Settment
rule_based,
approval_new_credit,
approval_matched_credit,
cust_name_match_type,
credit_matching_thold_type,
credit_tolerance_operand,
--For Price Protection Parallel Approval
automate_notification_days,
--For SSD Default Adjustment Types
ssd_inc_adj_type_id,
ssd_dec_adj_type_id,
ssd_imd_claim_flag
FROM ozf_sys_parameters;