APPS.AS_VALIDATE_SETUP dependencies on AS_SALESFORCE

Line 362: FROM AS_SALES_GROUPS a, AS_SALESFORCE b

358: END IF;
359:
360: /* BEGIN
361: SELECT count(*) INTO l_count
362: FROM AS_SALES_GROUPS a, AS_SALESFORCE b
363: WHERE a.manager_person_id = b.employee_person_id
364: and a.manager_salesforce_id <> b.salesforce_id
365: and b.type = 'EMPLOYEE';
366: EXCEPTION

Line 375: ||'): Dangling FK to AS_SALESFORCE found in AS_SALES_GROUPS');

371: l_err_num := l_err_num+1;
372: l_err_total := l_err_total+1;
373: Write_Log(l_module, ' ');
374: Write_Log(l_module, 'Error('||to_char(l_err_total)
375: ||'): Dangling FK to AS_SALESFORCE found in AS_SALES_GROUPS');
376: ELSE
377: Write_Log(l_module, ' ');
378: Write_Log(l_module, 'Success: manager_salesforce_id in AS_SALES_GROUPS'
379: ||' exists in AS_SALESFORCE');

Line 379: ||' exists in AS_SALESFORCE');

375: ||'): Dangling FK to AS_SALESFORCE found in AS_SALES_GROUPS');
376: ELSE
377: Write_Log(l_module, ' ');
378: Write_Log(l_module, 'Success: manager_salesforce_id in AS_SALES_GROUPS'
379: ||' exists in AS_SALESFORCE');
380: END IF;*/
381:
382: BEGIN
383: SELECT count(*) INTO l_count

Line 389: ( select 1 from AS_SALESFORCE sf

385: WHERE not exists
386: ( select 1 from PER_ALL_PEOPLE_F per
387: where per.person_id = sga.person_id )
388: and not exists
389: ( select 1 from AS_SALESFORCE sf
390: where sf.salesforce_id = sga.salesforce_id );
391: EXCEPTION
392: WHEN OTHERS THEN
393: l_count := 0;

Line 410: FROM AS_SALES_GRP_ADMIN a, AS_SALESFORCE b

406: END IF;
407:
408: BEGIN
409: SELECT count(*) INTO l_count
410: FROM AS_SALES_GRP_ADMIN a, AS_SALESFORCE b
411: WHERE a.salesforce_id <> b.salesforce_id
412: and a.person_id = b.employee_person_id
413: and b.type = 'EMPLOYEE';
414: EXCEPTION

Line 423: ||'): Dangling FK to AS_SALESFORCE found in AS_SALES_GRP_ADMIN');

419: l_err_num := l_err_num+1;
420: l_err_total := l_err_total+1;
421: Write_Log(l_module, ' ');
422: Write_Log(l_module, 'Error('||to_char(l_err_total)
423: ||'): Dangling FK to AS_SALESFORCE found in AS_SALES_GRP_ADMIN');
424: ELSE
425: Write_Log(l_module, ' ');
426: Write_Log(l_module, 'Success: salesforce_id in AS_SALES_GRP_ADMIN'
427: ||' exists in AS_SALESFORCE');

Line 427: ||' exists in AS_SALESFORCE');

423: ||'): Dangling FK to AS_SALESFORCE found in AS_SALES_GRP_ADMIN');
424: ELSE
425: Write_Log(l_module, ' ');
426: Write_Log(l_module, 'Success: salesforce_id in AS_SALES_GRP_ADMIN'
427: ||' exists in AS_SALESFORCE');
428: END IF;
429:
430: /* BEGIN
431: SELECT count(*) INTO l_count