DBA Data[Home] [Help]

APPS.XLA_ACCTG_METHODS_PKG dependencies on XLA_ACCTG_METHOD_RULES

Line 42: FROM xla_acctg_method_rules

38: xla_utility_pkg.trace('accounting_method_type_code = '||p_accounting_method_type_code , 20);
39: xla_utility_pkg.trace('accounting_method_code = '||p_accounting_method_code , 20);
40:
41: DELETE
42: FROM xla_acctg_method_rules
43: WHERE accounting_method_type_code = p_accounting_method_type_code
44: AND accounting_method_code = p_accounting_method_code;
45:
46: xla_utility_pkg.trace('< xla_acctg_methods_pkg.delete_method_details' , 10);

Line 86: FROM xla_acctg_method_rules

82: CURSOR c_meth_rules
83: IS
84: SELECT application_id, amb_context_code, product_rule_type_code, product_rule_code,
85: start_date_active, end_date_active
86: FROM xla_acctg_method_rules
87: WHERE accounting_method_type_code = p_old_accting_meth_type_code
88: AND accounting_method_code = p_old_accting_meth_code;
89:
90: l_meth_rule c_meth_rules%rowtype;

Line 112: SELECT xla_acctg_method_rules_s.nextval

108: FETCH c_meth_rules
109: INTO l_meth_rule;
110: EXIT WHEN c_meth_rules%notfound;
111:
112: SELECT xla_acctg_method_rules_s.nextval
113: INTO l_acctg_method_rule_id
114: FROM DUAL;
115:
116: INSERT INTO xla_acctg_method_rules

Line 116: INSERT INTO xla_acctg_method_rules

112: SELECT xla_acctg_method_rules_s.nextval
113: INTO l_acctg_method_rule_id
114: FROM DUAL;
115:
116: INSERT INTO xla_acctg_method_rules
117: (acctg_method_rule_id
118: ,accounting_method_type_code
119: ,accounting_method_code
120: ,application_id