APPS.OZF_NA_RULE_HEADER_PKG dependencies on OZF_NA_RULE_HEADERS_B

Line 64: INSERT INTO ozf_na_rule_headers_b(

60:
61: px_object_version_number := nvl(px_object_version_number, 1);
62:
63:
64: INSERT INTO ozf_na_rule_headers_b(
65: na_rule_header_id,
66: user_status_id,
67: status_code,
68: start_date,

Line 150: Update ozf_na_rule_headers_b

146: )
147:
148: IS
149: BEGIN
150: Update ozf_na_rule_headers_b
151: SET
152: 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),
153: user_status_id = DECODE( p_user_status_id, null, user_status_id, FND_API.G_MISS_NUM, null, p_user_status_id),
154: status_code = DECODE( p_status_code, null, status_code, FND_API.g_miss_char, null, p_status_code),

Line 201: DELETE FROM ozf_na_rule_headers_b

197: p_na_rule_header_id NUMBER,
198: p_object_version_number NUMBER)
199: IS
200: BEGIN
201: DELETE FROM ozf_na_rule_headers_b
202: WHERE na_rule_header_id = p_na_rule_header_id
203: AND object_version_number = p_object_version_number;
204: If (SQL%NOTFOUND) then
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 239: FROM ozf_na_rule_headers_b

235: p_object_version_number NUMBER)
236: IS
237: CURSOR C IS
238: SELECT *
239: FROM ozf_na_rule_headers_b
240: WHERE na_rule_header_id = p_na_rule_header_id
241: AND object_version_number = p_object_version_number
242: FOR UPDATE OF na_rule_header_id NOWAIT;
243: Recinfo C%ROWTYPE;

Line 278: from ozf_na_rule_headers_b b

274: BEGIN
275: delete from ozf_na_rule_headers_tl T
276: where not exists
277: (select NULL
278: from ozf_na_rule_headers_b b
279: where b.na_rule_header_id = t.na_rule_header_id
280: );
281:
282: update ozf_na_rule_headers_tl t set (