APPS.OZF_FUND_EXTENSION_PVT dependencies on OZF_FUNDS_ALL_B

Line 215: FROM ozf_funds_all_b

211: AND transfer_type IN ('TRANSFER', 'REQUEST', 'UTILIZED');
212:
213: CURSOR c_get_fund_child(p_child_fund_id NUMBER) IS
214: SELECT fund_id
215: FROM ozf_funds_all_b
216: WHERE parent_fund_id = p_object_id
217: AND fund_id = p_child_fund_id;
218:
219: BEGIN

Line 503: FROM ozf_funds_all_b

499: I NUMBER := 1;
500:
501: CURSOR c_get_fund_info IS
502: SELECT status_code
503: FROM ozf_funds_all_b
504: WHERE fund_id = p_object_id;
505:
506: BEGIN
507: x_return_status := fnd_api.g_ret_sts_success;

Line 630: FROM ozf_funds_all_b

626:
627: CURSOR c_qp_list_header_id
628: IS
629: SELECT plan_id
630: FROM ozf_funds_all_b
631: WHERE fund_id = l_fund_id;
632:
633: BEGIN
634:

Line 744: FROM ozf_funds_all_b

740:
741:
742: CURSOR c_get_child_funds IS
743: SELECT fund_id, object_version_number
744: FROM ozf_funds_all_b
745: WHERE parent_fund_id = p_object_id;
746:
747: CURSOR c_get_fund_info IS
748: SELECT fund_id

Line 1046: DELETE FROM ozf_funds_all_b

1042: END IF;
1043: END IF;
1044: END LOOP;
1045:
1046: DELETE FROM ozf_funds_all_b
1047: WHERE fund_id = p_object_id
1048: AND object_version_number = p_object_version_number;
1049: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' ozf_funds_all_b records with budget ' || l_fund_rec.short_name);
1050: IF SQL%ROWCOUNT > 0 THEN

Line 1049: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' ozf_funds_all_b records with budget ' || l_fund_rec.short_name);

1045:
1046: DELETE FROM ozf_funds_all_b
1047: WHERE fund_id = p_object_id
1048: AND object_version_number = p_object_version_number;
1049: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' ozf_funds_all_b records with budget ' || l_fund_rec.short_name);
1050: IF SQL%ROWCOUNT > 0 THEN
1051: -- l_msg_text := 'Remove table record of budget ' || l_fund_rec.short_name;
1052: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_RECORD');
1053: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);