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_ADW_COLLECT_DIMENSIONS dependencies on PA_PROJECTS

Line 445: PA_PROJECTS_IT

441:
442: -- First Try to Update the Row in the Interface Table
443:
444: UPDATE
445: PA_PROJECTS_IT
446: SET
447: PROJECT_TYPE = PROJECTS_R.PROJECT_TYPE,
448: SEGMENT1 = PROJECTS_R.SEGMENT1,
449: NAME = PROJECTS_R.NAME,

Line 479: INSERT INTO PA_PROJECTS_IT

475: -- Check If Any row was updated
476:
477: IF (SQL%ROWCOUNT = 0) THEN
478: -- No row was updated, So Insert a new row into the interface table
479: INSERT INTO PA_PROJECTS_IT
480: (
481: PROJECT_ID,
482: PROJECT_TYPE,
483: SEGMENT1,

Line 543: PA_PROJECTS

539:
540: -- Mark the Projects as transferred to Interface table
541:
542: UPDATE
543: PA_PROJECTS
544: SET
545: ADW_NOTIFY_FLAG = 'N'
546: WHERE
547: PROJECT_ID = PROJECTS_R.PROJECT_ID;