APPS.OZF_NA_DDN_RULE_PKG dependencies on OZF_NA_DEDUCTION_RULES_B

Line 64: INSERT INTO ozf_na_deduction_rules_b(

60:
61: px_object_version_number := nvl(px_object_version_number, 1);
62:
63:
64: INSERT INTO ozf_na_deduction_rules_b(
65: na_deduction_rule_id,
66: transaction_source_code,
67: transaction_type_code,
68: deduction_identifier_id,

Line 150: Update ozf_na_deduction_rules_b

146: )
147:
148: IS
149: BEGIN
150: Update ozf_na_deduction_rules_b
151: SET
152: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),
153: transaction_source_code = DECODE( p_transaction_source_code, null, transaction_source_code, FND_API.g_miss_char, null, p_transaction_source_code),
154: transaction_type_code = DECODE( p_transaction_type_code, null, transaction_type_code, FND_API.g_miss_char, null, p_transaction_type_code),

Line 201: DELETE FROM ozf_na_deduction_rules_b

197: p_na_deduction_rule_id NUMBER,
198: p_object_version_number NUMBER)
199: IS
200: BEGIN
201: DELETE FROM ozf_na_deduction_rules_b
202: WHERE na_deduction_rule_id = p_na_deduction_rule_id
203: AND object_version_number = p_object_version_number;
204: DELETE FROM ozf_na_deduction_rules_tl
205: WHERE na_deduction_rule_id = p_na_deduction_rule_id;

Line 234: FROM ozf_na_deduction_rules_b

230: p_object_version_number NUMBER)
231: IS
232: CURSOR C IS
233: SELECT *
234: FROM ozf_na_deduction_rules_b
235: WHERE na_deduction_rule_id = p_na_deduction_rule_id
236: AND object_version_number = p_object_version_number
237: FOR UPDATE OF na_deduction_rule_id NOWAIT;
238: Recinfo C%ROWTYPE;

Line 273: from ozf_na_deduction_rules_b b

269: BEGIN
270: delete from ozf_na_deduction_rules_tl T
271: where not exists
272: (select NULL
273: from ozf_na_deduction_rules_b b
274: where b.na_deduction_rule_id = t.na_deduction_rule_id
275: );
276:
277: update ozf_na_deduction_rules_tl t set (