eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_AP_INTEGRATION dependencies on PA_RESOURCE_LIST_MEMBERS

Line 130: Select distinct resource_list_id from pa_resource_list_members

126:
127: /* -- Original Code
128: Declare
129: Cursor c_resource_list is
130: Select distinct resource_list_id from pa_resource_list_members
131: where vendor_id = p_old_vendor_id and enabled_flag = 'Y';
132: */
133:
134: -- FP.M Data Model Logic

Line 138: Select distinct resource_list_id from pa_resource_list_members

134: -- FP.M Data Model Logic
135:
136: Declare
137: Cursor c_resource_list is
138: Select distinct resource_list_id from pa_resource_list_members
139: where vendor_id = p_old_vendor_id
140: and enabled_flag = 'Y'
141: and nvl(migration_code,'M')= 'M';
142:

Line 157: l_expenditure_category pa_resource_list_members.expenditure_category%type;

153: l_new_vendor_exists_resource number := 0; /*Bug# 4029384*/
154:
155: l_new_vendor_name po_vendors.vendor_name%type;
156:
157: l_expenditure_category pa_resource_list_members.expenditure_category%type;
158: l_parent_member_id pa_resource_list_members.resource_list_member_id%type;
159: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;
160: l_track_as_labor_flag varchar2(10);
161: l_err_code Varchar2(200);

Line 158: l_parent_member_id pa_resource_list_members.resource_list_member_id%type;

154:
155: l_new_vendor_name po_vendors.vendor_name%type;
156:
157: l_expenditure_category pa_resource_list_members.expenditure_category%type;
158: l_parent_member_id pa_resource_list_members.resource_list_member_id%type;
159: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;
160: l_track_as_labor_flag varchar2(10);
161: l_err_code Varchar2(200);
162: l_err_stage Varchar2(200);

Line 159: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;

155: l_new_vendor_name po_vendors.vendor_name%type;
156:
157: l_expenditure_category pa_resource_list_members.expenditure_category%type;
158: l_parent_member_id pa_resource_list_members.resource_list_member_id%type;
159: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;
160: l_track_as_labor_flag varchar2(10);
161: l_err_code Varchar2(200);
162: l_err_stage Varchar2(200);
163: l_err_stack Varchar2(2000);

Line 223: Select nvl(count(*),0) into l_new_vendor_exists_member from pa_resource_list_members

219: Begin
220:
221: /* --Origianal Code
222:
223: Select nvl(count(*),0) into l_new_vendor_exists_member from pa_resource_list_members
224: where resource_list_id = rec1.resource_list_id and VENDOR_ID = p_new_vendor_id;
225: */
226:
227:

Line 232: from pa_resource_list_members

228: -- FP.M Data Model
229:
230: Select nvl(count(*),0)
231: into l_new_vendor_exists_member
232: from pa_resource_list_members
233: where resource_list_id = rec1.resource_list_id
234: and VENDOR_ID = p_new_vendor_id
235: and nvl(migration_code,'M') = 'M';
236:

Line 245: update pa_resource_list_members set enabled_flag = 'N'

241:
242:
243: /* --Origianal Code
244:
245: update pa_resource_list_members set enabled_flag = 'N'
246: where resource_list_id = rec1.resource_list_id
247: and vendor_id = p_old_vendor_id;
248: */
249:

Line 254: update pa_resource_list_members set

250:
251:
252: -- FP.M Data Model
253:
254: update pa_resource_list_members set
255: enabled_flag = 'N'
256: where resource_list_id = rec1.resource_list_id
257: and vendor_id = p_old_vendor_id
258: and nvl(migration_code,'M') = 'M';

Line 270: L_RESOURCE_LIST_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE;

266: x_stage:=' New Vendor Does not esists as resource member.. creating resource member';
267:
268: Declare
269:
270: L_RESOURCE_LIST_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE;
271: L_RESOURCE_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;
272: L_ORGANIZATION_ID PA_RESOURCE_LIST_MEMBERS.ORGANIZATION_ID%TYPE;
273: L_EXPENDITURE_CATEGORY PA_RESOURCE_LIST_MEMBERS.EXPENDITURE_CATEGORY%TYPE;
274: L_REVENUE_CATEGORY PA_RESOURCE_LIST_MEMBERS.REVENUE_CATEGORY%TYPE;

Line 271: L_RESOURCE_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;

267:
268: Declare
269:
270: L_RESOURCE_LIST_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE;
271: L_RESOURCE_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;
272: L_ORGANIZATION_ID PA_RESOURCE_LIST_MEMBERS.ORGANIZATION_ID%TYPE;
273: L_EXPENDITURE_CATEGORY PA_RESOURCE_LIST_MEMBERS.EXPENDITURE_CATEGORY%TYPE;
274: L_REVENUE_CATEGORY PA_RESOURCE_LIST_MEMBERS.REVENUE_CATEGORY%TYPE;
275: l_res_grouped PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE; /*Bug# 4029384*/

Line 272: L_ORGANIZATION_ID PA_RESOURCE_LIST_MEMBERS.ORGANIZATION_ID%TYPE;

268: Declare
269:
270: L_RESOURCE_LIST_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE;
271: L_RESOURCE_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;
272: L_ORGANIZATION_ID PA_RESOURCE_LIST_MEMBERS.ORGANIZATION_ID%TYPE;
273: L_EXPENDITURE_CATEGORY PA_RESOURCE_LIST_MEMBERS.EXPENDITURE_CATEGORY%TYPE;
274: L_REVENUE_CATEGORY PA_RESOURCE_LIST_MEMBERS.REVENUE_CATEGORY%TYPE;
275: l_res_grouped PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE; /*Bug# 4029384*/
276: Begin

Line 273: L_EXPENDITURE_CATEGORY PA_RESOURCE_LIST_MEMBERS.EXPENDITURE_CATEGORY%TYPE;

269:
270: L_RESOURCE_LIST_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE;
271: L_RESOURCE_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;
272: L_ORGANIZATION_ID PA_RESOURCE_LIST_MEMBERS.ORGANIZATION_ID%TYPE;
273: L_EXPENDITURE_CATEGORY PA_RESOURCE_LIST_MEMBERS.EXPENDITURE_CATEGORY%TYPE;
274: L_REVENUE_CATEGORY PA_RESOURCE_LIST_MEMBERS.REVENUE_CATEGORY%TYPE;
275: l_res_grouped PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE; /*Bug# 4029384*/
276: Begin
277:

Line 274: L_REVENUE_CATEGORY PA_RESOURCE_LIST_MEMBERS.REVENUE_CATEGORY%TYPE;

270: L_RESOURCE_LIST_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE;
271: L_RESOURCE_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;
272: L_ORGANIZATION_ID PA_RESOURCE_LIST_MEMBERS.ORGANIZATION_ID%TYPE;
273: L_EXPENDITURE_CATEGORY PA_RESOURCE_LIST_MEMBERS.EXPENDITURE_CATEGORY%TYPE;
274: L_REVENUE_CATEGORY PA_RESOURCE_LIST_MEMBERS.REVENUE_CATEGORY%TYPE;
275: l_res_grouped PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE; /*Bug# 4029384*/
276: Begin
277:
278:

Line 289: From pa_resource_list_members

285: SELECT
286: RESOURCE_LIST_ID, RESOURCE_ID, ORGANIZATION_ID, EXPENDITURE_CATEGORY, REVENUE_CATEGORY
287: INTO
288: L_RESOURCE_LIST_ID, L_RESOURCE_ID, L_ORGANIZATION_ID,L_EXPENDITURE_CATEGORY, L_REVENUE_CATEGORY
289: From pa_resource_list_members
290: Where RESOURCE_LIST_ID = rec1.resource_list_id
291: And resource_list_member_id = (Select parent_member_id from pa_resource_list_members
292: where RESOURCE_LIST_ID = rec1.resource_list_id
293: and vendor_id= p_old_vendor_id);

Line 291: And resource_list_member_id = (Select parent_member_id from pa_resource_list_members

287: INTO
288: L_RESOURCE_LIST_ID, L_RESOURCE_ID, L_ORGANIZATION_ID,L_EXPENDITURE_CATEGORY, L_REVENUE_CATEGORY
289: From pa_resource_list_members
290: Where RESOURCE_LIST_ID = rec1.resource_list_id
291: And resource_list_member_id = (Select parent_member_id from pa_resource_list_members
292: where RESOURCE_LIST_ID = rec1.resource_list_id
293: and vendor_id= p_old_vendor_id);
294: */
295:

Line 311: From pa_resource_list_members

307: SELECT
308: RESOURCE_LIST_ID, RESOURCE_ID, ORGANIZATION_ID, EXPENDITURE_CATEGORY, REVENUE_CATEGORY
309: INTO
310: L_RESOURCE_LIST_ID, L_RESOURCE_ID, L_ORGANIZATION_ID,L_EXPENDITURE_CATEGORY, L_REVENUE_CATEGORY
311: From pa_resource_list_members
312: Where RESOURCE_LIST_ID = rec1.resource_list_id
313: And resource_list_member_id = (Select parent_member_id from pa_resource_list_members
314: where RESOURCE_LIST_ID = rec1.resource_list_id
315: and vendor_id= p_old_vendor_id

Line 313: And resource_list_member_id = (Select parent_member_id from pa_resource_list_members

309: INTO
310: L_RESOURCE_LIST_ID, L_RESOURCE_ID, L_ORGANIZATION_ID,L_EXPENDITURE_CATEGORY, L_REVENUE_CATEGORY
311: From pa_resource_list_members
312: Where RESOURCE_LIST_ID = rec1.resource_list_id
313: And resource_list_member_id = (Select parent_member_id from pa_resource_list_members
314: where RESOURCE_LIST_ID = rec1.resource_list_id
315: and vendor_id= p_old_vendor_id
316: and nvl(migration_code,'M') = 'M' );
317:

Line 326: From pa_resource_list_members

322: SELECT
323: RESOURCE_LIST_ID, RESOURCE_ID, ORGANIZATION_ID, EXPENDITURE_CATEGORY, REVENUE_CATEGORY
324: INTO
325: L_RESOURCE_LIST_ID, L_RESOURCE_ID, L_ORGANIZATION_ID,L_EXPENDITURE_CATEGORY, L_REVENUE_CATEGORY
326: From pa_resource_list_members
327: Where RESOURCE_LIST_ID = rec1.resource_list_id
328: and vendor_id =p_old_vendor_id
329: and nvl(migration_code,'M') = 'M';
330:

Line 396: from pa_resource_assignments assign, pa_resource_list_members member, pa_budget_lines budget

392:
393: /* -- Original Logic
394:
395: select 'Y' into l_budget_exists
396: from pa_resource_assignments assign, pa_resource_list_members member, pa_budget_lines budget
397: where assign.RESOURCE_LIST_MEMBER_ID=member.RESOURCE_LIST_MEMBER_ID
398: and member.vendor_id = p_vendor_id
399: and budget.resource_assignment_id = assign.resource_assignment_id
400: and rownum < 2 ;

Line 410: , pa_resource_list_members member

406:
407: select 'Y'
408: into l_budget_exists
409: from pa_resource_assignments assign
410: , pa_resource_list_members member
411: , pa_budget_lines budget
412: where assign.RESOURCE_LIST_MEMBER_ID=member.RESOURCE_LIST_MEMBER_ID
413: and member.vendor_id = p_vendor_id
414: and budget.resource_assignment_id = assign.resource_assignment_id