[Home] [Help]
99: l_limit NUMBER := 200;
100: l_any_rec_found VARCHAR2(1) := 'N';
101:
102: -- 1.Select additional columns here to map them to
103: -- the FV_BE_INTERFACE table columns.
104: -- 2.Put additional filters here ,if required.
105:
106: CURSOR C_PA_BUDGET_LINES(grp_id IN VARCHAR2,usr_id IN VARCHAR2) is
107: SELECT
179: into l_VER_GROUP_ID,l_user_id
180: FROM dual;
181:
182: -- Insert one record for each budget version baseline into
183: -- the table FV_BE_INTERFACE_CONTOL
184:
185: INSERT INTO FV_BE_INTERFACE_CONTROL
186: (
187: SOURCE
181:
182: -- Insert one record for each budget version baseline into
183: -- the table FV_BE_INTERFACE_CONTOL
184:
185: INSERT INTO FV_BE_INTERFACE_CONTROL
186: (
187: SOURCE
188: ,GROUP_ID
189: ,STATUS
252: ,l_budget_user_id
253: LIMIT l_limit;
254:
255: -- Enter Your Business Rules Here to manipulate the attribute vales to be inserted into
256: -- FV_BE_INTERFACE table or Use The the provided default.
257:
258: -- Insert one record for each budget line and one for each reverse budget line into
259: -- the table FV_BE_INTERFACE table.
260:
255: -- Enter Your Business Rules Here to manipulate the attribute vales to be inserted into
256: -- FV_BE_INTERFACE table or Use The the provided default.
257:
258: -- Insert one record for each budget line and one for each reverse budget line into
259: -- the table FV_BE_INTERFACE table.
260:
261: -- Try to insert into FV_BE_INTERFACE only if any record is found for this loop
262:
263: IF l_set_of_books_id.COUNT > 0 then
257:
258: -- Insert one record for each budget line and one for each reverse budget line into
259: -- the table FV_BE_INTERFACE table.
260:
261: -- Try to insert into FV_BE_INTERFACE only if any record is found for this loop
262:
263: IF l_set_of_books_id.COUNT > 0 then
264:
265: --
266: l_any_rec_found := 'Y';
267:
268: FORALL i IN 1..l_set_of_books_id.COUNT
269:
270: INSERT INTO FV_BE_INTERFACE
271: (
272: SET_OF_BOOKS_ID
273: ,SOURCE
274: ,GROUP_ID