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 504: FROM ozf_funds_all_b

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

Line 632: FROM ozf_funds_all_b

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

Line 747: FROM ozf_funds_all_b

743:
744:
745: CURSOR c_get_child_funds IS
746: SELECT fund_id, object_version_number
747: FROM ozf_funds_all_b
748: WHERE parent_fund_id = p_object_id;
749:
750: CURSOR c_get_fund_info IS
751: SELECT fund_id

Line 1070: DELETE FROM ozf_funds_all_b

1066: END IF;
1067: END IF;
1068: END LOOP;
1069:
1070: DELETE FROM ozf_funds_all_b
1071: WHERE fund_id = p_object_id
1072: AND object_version_number = p_object_version_number;
1073: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' ozf_funds_all_b records with budget ' || l_fund_rec.short_name);
1074: IF SQL%ROWCOUNT > 0 THEN

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

1069:
1070: DELETE FROM ozf_funds_all_b
1071: WHERE fund_id = p_object_id
1072: AND object_version_number = p_object_version_number;
1073: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' ozf_funds_all_b records with budget ' || l_fund_rec.short_name);
1074: IF SQL%ROWCOUNT > 0 THEN
1075: -- l_msg_text := 'Remove table record of budget ' || l_fund_rec.short_name;
1076: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_RECORD');
1077: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);