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 194: Select distinct resource_list_id from pa_resource_list_members

190:
191: /* -- Original Code
192: Declare
193: Cursor c_resource_list is
194: Select distinct resource_list_id from pa_resource_list_members
195: where vendor_id = p_old_vendor_id and enabled_flag = 'Y';
196: */
197:
198: -- FP.M Data Model Logic

Line 202: Select distinct resource_list_id from pa_resource_list_members

198: -- FP.M Data Model Logic
199:
200: Declare
201: Cursor c_resource_list is
202: Select distinct resource_list_id from pa_resource_list_members
203: where vendor_id = p_old_vendor_id
204: and enabled_flag = 'Y'
205: and nvl(migration_code,'M')= 'M';
206:

Line 221: l_expenditure_category pa_resource_list_members.expenditure_category%type;

217: l_new_vendor_exists_resource number := 0; /*Bug# 4029384*/
218:
219: l_new_vendor_name po_vendors.vendor_name%type;
220:
221: l_expenditure_category pa_resource_list_members.expenditure_category%type;
222: l_parent_member_id pa_resource_list_members.resource_list_member_id%type;
223: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;
224: l_track_as_labor_flag varchar2(10);
225: l_err_code Varchar2(200);

Line 222: l_parent_member_id pa_resource_list_members.resource_list_member_id%type;

218:
219: l_new_vendor_name po_vendors.vendor_name%type;
220:
221: l_expenditure_category pa_resource_list_members.expenditure_category%type;
222: l_parent_member_id pa_resource_list_members.resource_list_member_id%type;
223: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;
224: l_track_as_labor_flag varchar2(10);
225: l_err_code Varchar2(200);
226: l_err_stage Varchar2(200);

Line 223: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;

219: l_new_vendor_name po_vendors.vendor_name%type;
220:
221: l_expenditure_category pa_resource_list_members.expenditure_category%type;
222: l_parent_member_id pa_resource_list_members.resource_list_member_id%type;
223: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;
224: l_track_as_labor_flag varchar2(10);
225: l_err_code Varchar2(200);
226: l_err_stage Varchar2(200);
227: l_err_stack Varchar2(2000);

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

283: Begin
284:
285: /* --Origianal Code
286:
287: Select nvl(count(*),0) into l_new_vendor_exists_member from pa_resource_list_members
288: where resource_list_id = rec1.resource_list_id and VENDOR_ID = p_new_vendor_id;
289: */
290:
291:

Line 296: from pa_resource_list_members

292: -- FP.M Data Model
293:
294: Select nvl(count(*),0)
295: into l_new_vendor_exists_member
296: from pa_resource_list_members
297: where resource_list_id = rec1.resource_list_id
298: and VENDOR_ID = p_new_vendor_id
299: and nvl(migration_code,'M') = 'M';
300:

Line 309: update pa_resource_list_members set enabled_flag = 'N'

305:
306:
307: /* --Origianal Code
308:
309: update pa_resource_list_members set enabled_flag = 'N'
310: where resource_list_id = rec1.resource_list_id
311: and vendor_id = p_old_vendor_id;
312: */
313:

Line 318: update pa_resource_list_members set

314:
315:
316: -- FP.M Data Model
317:
318: update pa_resource_list_members set
319: enabled_flag = 'N'
320: where resource_list_id = rec1.resource_list_id
321: and vendor_id = p_old_vendor_id
322: and nvl(migration_code,'M') = 'M';

Line 334: L_RESOURCE_LIST_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE;

330: x_stage:=' New Vendor Does not esists as resource member.. creating resource member';
331:
332: Declare
333:
334: L_RESOURCE_LIST_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE;
335: L_RESOURCE_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;
336: L_ORGANIZATION_ID PA_RESOURCE_LIST_MEMBERS.ORGANIZATION_ID%TYPE;
337: L_EXPENDITURE_CATEGORY PA_RESOURCE_LIST_MEMBERS.EXPENDITURE_CATEGORY%TYPE;
338: L_REVENUE_CATEGORY PA_RESOURCE_LIST_MEMBERS.REVENUE_CATEGORY%TYPE;

Line 335: L_RESOURCE_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;

331:
332: Declare
333:
334: L_RESOURCE_LIST_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE;
335: L_RESOURCE_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;
336: L_ORGANIZATION_ID PA_RESOURCE_LIST_MEMBERS.ORGANIZATION_ID%TYPE;
337: L_EXPENDITURE_CATEGORY PA_RESOURCE_LIST_MEMBERS.EXPENDITURE_CATEGORY%TYPE;
338: L_REVENUE_CATEGORY PA_RESOURCE_LIST_MEMBERS.REVENUE_CATEGORY%TYPE;
339: l_res_grouped PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE; /*Bug# 4029384*/

Line 336: L_ORGANIZATION_ID PA_RESOURCE_LIST_MEMBERS.ORGANIZATION_ID%TYPE;

332: Declare
333:
334: L_RESOURCE_LIST_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE;
335: L_RESOURCE_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;
336: L_ORGANIZATION_ID PA_RESOURCE_LIST_MEMBERS.ORGANIZATION_ID%TYPE;
337: L_EXPENDITURE_CATEGORY PA_RESOURCE_LIST_MEMBERS.EXPENDITURE_CATEGORY%TYPE;
338: L_REVENUE_CATEGORY PA_RESOURCE_LIST_MEMBERS.REVENUE_CATEGORY%TYPE;
339: l_res_grouped PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE; /*Bug# 4029384*/
340: Begin

Line 337: L_EXPENDITURE_CATEGORY PA_RESOURCE_LIST_MEMBERS.EXPENDITURE_CATEGORY%TYPE;

333:
334: L_RESOURCE_LIST_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE;
335: L_RESOURCE_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;
336: L_ORGANIZATION_ID PA_RESOURCE_LIST_MEMBERS.ORGANIZATION_ID%TYPE;
337: L_EXPENDITURE_CATEGORY PA_RESOURCE_LIST_MEMBERS.EXPENDITURE_CATEGORY%TYPE;
338: L_REVENUE_CATEGORY PA_RESOURCE_LIST_MEMBERS.REVENUE_CATEGORY%TYPE;
339: l_res_grouped PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE; /*Bug# 4029384*/
340: Begin
341:

Line 338: L_REVENUE_CATEGORY PA_RESOURCE_LIST_MEMBERS.REVENUE_CATEGORY%TYPE;

334: L_RESOURCE_LIST_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE;
335: L_RESOURCE_ID PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;
336: L_ORGANIZATION_ID PA_RESOURCE_LIST_MEMBERS.ORGANIZATION_ID%TYPE;
337: L_EXPENDITURE_CATEGORY PA_RESOURCE_LIST_MEMBERS.EXPENDITURE_CATEGORY%TYPE;
338: L_REVENUE_CATEGORY PA_RESOURCE_LIST_MEMBERS.REVENUE_CATEGORY%TYPE;
339: l_res_grouped PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE; /*Bug# 4029384*/
340: Begin
341:
342:

Line 353: From pa_resource_list_members

349: SELECT
350: RESOURCE_LIST_ID, RESOURCE_ID, ORGANIZATION_ID, EXPENDITURE_CATEGORY, REVENUE_CATEGORY
351: INTO
352: L_RESOURCE_LIST_ID, L_RESOURCE_ID, L_ORGANIZATION_ID,L_EXPENDITURE_CATEGORY, L_REVENUE_CATEGORY
353: From pa_resource_list_members
354: Where RESOURCE_LIST_ID = rec1.resource_list_id
355: And resource_list_member_id = (Select parent_member_id from pa_resource_list_members
356: where RESOURCE_LIST_ID = rec1.resource_list_id
357: and vendor_id= p_old_vendor_id);

Line 355: And resource_list_member_id = (Select parent_member_id from pa_resource_list_members

351: INTO
352: L_RESOURCE_LIST_ID, L_RESOURCE_ID, L_ORGANIZATION_ID,L_EXPENDITURE_CATEGORY, L_REVENUE_CATEGORY
353: From pa_resource_list_members
354: Where RESOURCE_LIST_ID = rec1.resource_list_id
355: And resource_list_member_id = (Select parent_member_id from pa_resource_list_members
356: where RESOURCE_LIST_ID = rec1.resource_list_id
357: and vendor_id= p_old_vendor_id);
358: */
359:

Line 375: From pa_resource_list_members

371: SELECT
372: RESOURCE_LIST_ID, RESOURCE_ID, ORGANIZATION_ID, EXPENDITURE_CATEGORY, REVENUE_CATEGORY
373: INTO
374: L_RESOURCE_LIST_ID, L_RESOURCE_ID, L_ORGANIZATION_ID,L_EXPENDITURE_CATEGORY, L_REVENUE_CATEGORY
375: From pa_resource_list_members
376: Where RESOURCE_LIST_ID = rec1.resource_list_id
377: And resource_list_member_id = (Select parent_member_id from pa_resource_list_members
378: where RESOURCE_LIST_ID = rec1.resource_list_id
379: and vendor_id= p_old_vendor_id

Line 377: And resource_list_member_id = (Select parent_member_id from pa_resource_list_members

373: INTO
374: L_RESOURCE_LIST_ID, L_RESOURCE_ID, L_ORGANIZATION_ID,L_EXPENDITURE_CATEGORY, L_REVENUE_CATEGORY
375: From pa_resource_list_members
376: Where RESOURCE_LIST_ID = rec1.resource_list_id
377: And resource_list_member_id = (Select parent_member_id from pa_resource_list_members
378: where RESOURCE_LIST_ID = rec1.resource_list_id
379: and vendor_id= p_old_vendor_id
380: and nvl(migration_code,'M') = 'M' );
381:

Line 390: From pa_resource_list_members

386: SELECT
387: RESOURCE_LIST_ID, RESOURCE_ID, ORGANIZATION_ID, EXPENDITURE_CATEGORY, REVENUE_CATEGORY
388: INTO
389: L_RESOURCE_LIST_ID, L_RESOURCE_ID, L_ORGANIZATION_ID,L_EXPENDITURE_CATEGORY, L_REVENUE_CATEGORY
390: From pa_resource_list_members
391: Where RESOURCE_LIST_ID = rec1.resource_list_id
392: and vendor_id =p_old_vendor_id
393: and nvl(migration_code,'M') = 'M';
394:

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

456:
457: /* -- Original Logic
458:
459: select 'Y' into l_budget_exists
460: from pa_resource_assignments assign, pa_resource_list_members member, pa_budget_lines budget
461: where assign.RESOURCE_LIST_MEMBER_ID=member.RESOURCE_LIST_MEMBER_ID
462: and member.vendor_id = p_vendor_id
463: and budget.resource_assignment_id = assign.resource_assignment_id
464: and rownum < 2 ;

Line 474: , pa_resource_list_members member

470:
471: select 'Y'
472: into l_budget_exists
473: from pa_resource_assignments assign
474: , pa_resource_list_members member
475: , pa_budget_lines budget
476: where assign.RESOURCE_LIST_MEMBER_ID=member.RESOURCE_LIST_MEMBER_ID
477: and member.vendor_id = p_vendor_id
478: and budget.resource_assignment_id = assign.resource_assignment_id