DBA Data[Home] [Help]

APPS.OZF_ACCRUAL_ENGINE dependencies on OZF_FUNDS_UTILIZED_ALL_TL

Line 1788: INSERT INTO ozf_funds_utilized_all_tl

1784: ,l_utilization_rec.year_id -- Fix for Bug 12657908
1785:
1786: );
1787:
1788: INSERT INTO ozf_funds_utilized_all_tl
1789: (utilization_id,last_update_date
1790: ,last_updated_by,last_update_login
1791: ,creation_date,created_by
1792: ,created_from,request_id

Line 1816: FROM ozf_funds_utilized_all_tl t

1812: ,l_utilization_rec.org_id --TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10)) -- org_id
1813: FROM fnd_languages l
1814: WHERE l.installed_flag IN ('I', 'B')
1815: AND NOT EXISTS ( SELECT NULL
1816: FROM ozf_funds_utilized_all_tl t
1817: WHERE t.utilization_id = l_utilization_rec.utilization_id
1818: AND t.language = l.language_code);
1819:
1820: x_utilization_id := l_utilization_rec.utilization_id ;

Line 1842: UPDATE ozf_funds_utilized_all_tl

1838: object_version_number = l_obj_ver_num + 1
1839: WHERE utilization_id = l_utilization_id
1840: AND object_version_number = l_obj_ver_num;
1841:
1842: UPDATE ozf_funds_utilized_all_tl
1843: SET last_update_date = SYSDATE, last_updated_by = NVL (fnd_global.user_id, -1), last_update_login = NVL (fnd_global.conc_login_id, -1),
1844: creation_date = SYSDATE, created_by = NVL (fnd_global.user_id, -1), request_id = fnd_global.conc_request_id,
1845: program_application_id = fnd_global.prog_appl_id, program_id = fnd_global.conc_program_id, program_update_date = SYSDATE,
1846: org_id = l_utilization_rec.org_id