APPS.OZF_NA_RULE_LINE_PKG dependencies on OZF_NA_RULE_LINES

Line 60: INSERT INTO ozf_na_rule_lines(

56:
57: px_object_version_number := nvl(px_object_version_number, 1);
58:
59:
60: INSERT INTO ozf_na_rule_lines(
61: na_rule_line_id,
62: na_rule_header_id,
63: na_deduction_rule_id,
64: active_flag,

Line 112: Update ozf_na_rule_lines

108: p_last_update_login NUMBER)
109:
110: IS
111: BEGIN
112: Update ozf_na_rule_lines
113: SET
114: na_rule_line_id = DECODE( p_na_rule_line_id, null, na_rule_line_id, FND_API.G_MISS_NUM, null, p_na_rule_line_id),
115: na_rule_header_id = DECODE( p_na_rule_header_id, null, na_rule_header_id, FND_API.G_MISS_NUM, null, p_na_rule_header_id),
116: 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),

Line 153: DELETE FROM ozf_na_rule_lines

149: p_na_rule_line_id NUMBER,
150: p_object_version_number NUMBER)
151: IS
152: BEGIN
153: DELETE FROM ozf_na_rule_lines
154: WHERE na_rule_line_id = p_na_rule_line_id
155: AND object_version_number = p_object_version_number;
156: If (SQL%NOTFOUND) then
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 183: FROM ozf_na_rule_lines

179: p_object_version_number NUMBER)
180: IS
181: CURSOR C IS
182: SELECT *
183: FROM ozf_na_rule_lines
184: WHERE na_rule_line_id = p_na_rule_line_id
185: AND object_version_number = p_object_version_number
186: FOR UPDATE OF na_rule_line_id NOWAIT;
187: Recinfo C%ROWTYPE;