APPS.PA_CLIENT_EXT_FV_BUDGET_INT dependencies on PA_BUDGET_LINES

Line 106: CURSOR C_PA_BUDGET_LINES(grp_id IN VARCHAR2,usr_id IN VARCHAR2) is

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
108: pia.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
109: ,'PROJECTS' SOURCE
110: ,grp_id GROUP_ID -- can be mapped to pbl.attribute1 also

Line 158: ,PA_BUDGET_LINES pbl

154: from PA_PROJECTS_ALL ppa
155: ,PA_PROJECT_TYPES_ALL ppt
156: ,PA_IMPLEMENTATIONS_ALL pia
157: ,PA_BUDGET_VERSIONS pbv
158: ,PA_BUDGET_LINES pbl
159: ,PA_RESOURCE_ASSIGNMENTS pra
160: where ppa.project_id = p_project_id
161: and ppa.project_TYPE = ppt.project_type
162: and ppa.org_id = ppt.org_id

Line 204: OPEN C_PA_BUDGET_LINES(l_VER_GROUP_ID,l_user_id);

200: );
201:
202: -- Do not commit in this package.Calling module will take care of commit;
203:
204: OPEN C_PA_BUDGET_LINES(l_VER_GROUP_ID,l_user_id);
205: LOOP
206: FETCH C_PA_BUDGET_LINES BULK COLLECT INTO
207: l_set_of_books_id
208: ,l_source

Line 206: FETCH C_PA_BUDGET_LINES BULK COLLECT INTO

202: -- Do not commit in this package.Calling module will take care of commit;
203:
204: OPEN C_PA_BUDGET_LINES(l_VER_GROUP_ID,l_user_id);
205: LOOP
206: FETCH C_PA_BUDGET_LINES BULK COLLECT INTO
207: l_set_of_books_id
208: ,l_source
209: ,l_group_id
210: ,l_record_number

Line 428: EXIT WHEN C_PA_BUDGET_LINES%NOTFOUND;

424: ,l_budget_user_id(i)
425: );
426:
427: END IF;
428: EXIT WHEN C_PA_BUDGET_LINES%NOTFOUND;
429:
430: END LOOP;
431:
432: if l_any_rec_found = 'Y' then

Line 441: CLOSE C_PA_BUDGET_LINES;

437: end if;
438:
439: -- Do not commit in this package.
440:
441: CLOSE C_PA_BUDGET_LINES;
442:
443: -- Please set the interface status to True if it is success as per custom logic , by default it is null
444:
445: