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.IRC_DEFAULT_POSTING_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 303


procedure update_default_posting
(P_VALIDATE                   IN  BOOLEAN    default FALSE
,P_LANGUAGE_CODE              IN  VARCHAR2   default hr_api.userenv_lang
,P_DEFAULT_POSTING_ID         IN  NUMBER
,P_POSITION_ID                IN  NUMBER     default hr_api.g_number
,P_JOB_ID                     IN  NUMBER     default hr_api.g_number
,P_ORGANIZATION_ID            IN  NUMBER     default hr_api.g_number
,P_ORG_NAME                   IN  VARCHAR2   default hr_api.g_varchar2
,P_ORG_DESCRIPTION            IN  VARCHAR2   default hr_api.g_varchar2
,P_JOB_TITLE                  IN  VARCHAR2   default hr_api.g_varchar2
,P_BRIEF_DESCRIPTION          IN  VARCHAR2   default hr_api.g_varchar2
,P_DETAILED_DESCRIPTION       IN  VARCHAR2   default hr_api.g_varchar2
,P_JOB_REQUIREMENTS           IN  VARCHAR2   default hr_api.g_varchar2
,P_ADDITIONAL_DETAILS         IN  VARCHAR2   default hr_api.g_varchar2
,P_HOW_TO_APPLY               IN  VARCHAR2   default hr_api.g_varchar2
,P_IMAGE_URL                  IN  VARCHAR2   default hr_api.g_varchar2
,P_IMAGE_URL_ALT              IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE_CATEGORY         IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE1                 IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE2                 IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE3                 IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE4                 IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE5                 IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE6                 IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE7                 IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE8                 IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE9                 IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE10                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE11                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE12                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE13                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE14                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE15                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE16                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE17                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE18                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE19                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE20                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE21                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE22                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE23                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE24                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE25                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE26                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE27                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE28                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE29                IN  VARCHAR2   default hr_api.g_varchar2
,P_ATTRIBUTE30                IN  VARCHAR2   default hr_api.g_varchar2
,P_OBJECT_VERSION_NUMBER      IN OUT NOCOPY NUMBER
) is
  --
  -- Declare cursors and local variables
  --

  l_proc                varchar2(72) := g_package||'update_default_posting';

Line: 366


  savepoint update_default_posting;

Line: 374


    irc_default_posting_bk2.update_default_posting_b
    (P_DEFAULT_POSTING_ID         => P_DEFAULT_POSTING_ID
    ,P_POSITION_ID                => P_POSITION_ID
    ,P_JOB_ID                     => P_JOB_ID
    ,P_ORGANIZATION_ID            => P_ORGANIZATION_ID
    ,P_LANGUAGE_CODE              => L_LANGUAGE_CODE
    ,P_ORG_NAME                   => P_ORG_NAME
    ,P_ORG_DESCRIPTION            => P_ORG_DESCRIPTION
    ,P_JOB_TITLE                  => P_JOB_TITLE
    ,P_BRIEF_DESCRIPTION          => P_BRIEF_DESCRIPTION
    ,P_DETAILED_DESCRIPTION       => P_DETAILED_DESCRIPTION
    ,P_JOB_REQUIREMENTS           => P_JOB_REQUIREMENTS
    ,P_ADDITIONAL_DETAILS         => P_ADDITIONAL_DETAILS
    ,P_HOW_TO_APPLY               => P_HOW_TO_APPLY
    ,P_IMAGE_URL                  => P_IMAGE_URL
    ,P_IMAGE_URL_ALT              => P_IMAGE_URL_ALT
    ,P_ATTRIBUTE_CATEGORY         => P_ATTRIBUTE_CATEGORY
    ,P_ATTRIBUTE1                 => P_ATTRIBUTE1
    ,P_ATTRIBUTE2                 => P_ATTRIBUTE2
    ,P_ATTRIBUTE3                 => P_ATTRIBUTE3
    ,P_ATTRIBUTE4                 => P_ATTRIBUTE4
    ,P_ATTRIBUTE5                 => P_ATTRIBUTE5
    ,P_ATTRIBUTE6                 => P_ATTRIBUTE6
    ,P_ATTRIBUTE7                 => P_ATTRIBUTE7
    ,P_ATTRIBUTE8                 => P_ATTRIBUTE8
    ,P_ATTRIBUTE9                 => P_ATTRIBUTE9
    ,P_ATTRIBUTE10                => P_ATTRIBUTE10
    ,P_ATTRIBUTE11                => P_ATTRIBUTE11
    ,P_ATTRIBUTE12                => P_ATTRIBUTE12
    ,P_ATTRIBUTE13                => P_ATTRIBUTE13
    ,P_ATTRIBUTE14                => P_ATTRIBUTE14
    ,P_ATTRIBUTE15                => P_ATTRIBUTE15
    ,P_ATTRIBUTE16                => P_ATTRIBUTE16
    ,P_ATTRIBUTE17                => P_ATTRIBUTE17
    ,P_ATTRIBUTE18                => P_ATTRIBUTE18
    ,P_ATTRIBUTE19                => P_ATTRIBUTE19
    ,P_ATTRIBUTE20                => P_ATTRIBUTE20
    ,P_ATTRIBUTE21                => P_ATTRIBUTE21
    ,P_ATTRIBUTE22                => P_ATTRIBUTE22
    ,P_ATTRIBUTE23                => P_ATTRIBUTE23
    ,P_ATTRIBUTE24                => P_ATTRIBUTE24
    ,P_ATTRIBUTE25                => P_ATTRIBUTE25
    ,P_ATTRIBUTE26                => P_ATTRIBUTE26
    ,P_ATTRIBUTE27                => P_ATTRIBUTE27
    ,P_ATTRIBUTE28                => P_ATTRIBUTE28
    ,P_ATTRIBUTE29                => P_ATTRIBUTE29
    ,P_ATTRIBUTE30                => P_ATTRIBUTE30
    );

Line: 425


        (p_module_name => 'update_default_posting'
        ,p_hook_type   => 'BP'
        );

Line: 502


     irc_default_posting_bk2.update_default_posting_a
    (P_POSITION_ID                => P_POSITION_ID
    ,P_JOB_ID                     => P_JOB_ID
    ,P_ORGANIZATION_ID            => P_ORGANIZATION_ID
    ,P_LANGUAGE_CODE              => L_LANGUAGE_CODE
    ,P_ORG_NAME                   => P_ORG_NAME
    ,P_ORG_DESCRIPTION            => P_ORG_DESCRIPTION
    ,P_JOB_TITLE                  => P_JOB_TITLE
    ,P_BRIEF_DESCRIPTION          => P_BRIEF_DESCRIPTION
    ,P_DETAILED_DESCRIPTION       => P_DETAILED_DESCRIPTION
    ,P_JOB_REQUIREMENTS           => P_JOB_REQUIREMENTS
    ,P_ADDITIONAL_DETAILS         => P_ADDITIONAL_DETAILS
    ,P_HOW_TO_APPLY               => P_HOW_TO_APPLY
    ,P_IMAGE_URL                  => P_IMAGE_URL
    ,P_IMAGE_URL_ALT              => P_IMAGE_URL_ALT
    ,P_ATTRIBUTE_CATEGORY         => P_ATTRIBUTE_CATEGORY
    ,P_ATTRIBUTE1                 => P_ATTRIBUTE1
    ,P_ATTRIBUTE2                 => P_ATTRIBUTE2
    ,P_ATTRIBUTE3                 => P_ATTRIBUTE3
    ,P_ATTRIBUTE4                 => P_ATTRIBUTE4
    ,P_ATTRIBUTE5                 => P_ATTRIBUTE5
    ,P_ATTRIBUTE6                 => P_ATTRIBUTE6
    ,P_ATTRIBUTE7                 => P_ATTRIBUTE7
    ,P_ATTRIBUTE8                 => P_ATTRIBUTE8
    ,P_ATTRIBUTE9                 => P_ATTRIBUTE9
    ,P_ATTRIBUTE10                => P_ATTRIBUTE10
    ,P_ATTRIBUTE11                => P_ATTRIBUTE11
    ,P_ATTRIBUTE12                => P_ATTRIBUTE12
    ,P_ATTRIBUTE13                => P_ATTRIBUTE13
    ,P_ATTRIBUTE14                => P_ATTRIBUTE14
    ,P_ATTRIBUTE15                => P_ATTRIBUTE15
    ,P_ATTRIBUTE16                => P_ATTRIBUTE16
    ,P_ATTRIBUTE17                => P_ATTRIBUTE17
    ,P_ATTRIBUTE18                => P_ATTRIBUTE18
    ,P_ATTRIBUTE19                => P_ATTRIBUTE19
    ,P_ATTRIBUTE20                => P_ATTRIBUTE20
    ,P_ATTRIBUTE21                => P_ATTRIBUTE21
    ,P_ATTRIBUTE22                => P_ATTRIBUTE22
    ,P_ATTRIBUTE23                => P_ATTRIBUTE23
    ,P_ATTRIBUTE24                => P_ATTRIBUTE24
    ,P_ATTRIBUTE25                => P_ATTRIBUTE25
    ,P_ATTRIBUTE26                => P_ATTRIBUTE26
    ,P_ATTRIBUTE27                => P_ATTRIBUTE27
    ,P_ATTRIBUTE28                => P_ATTRIBUTE28
    ,P_ATTRIBUTE29                => P_ATTRIBUTE29
    ,P_ATTRIBUTE30                => P_ATTRIBUTE30
    ,P_DEFAULT_POSTING_ID         => P_DEFAULT_POSTING_ID
    );

Line: 553


        (p_module_name => 'update_default_posting'
        ,p_hook_type   => 'AP'
        );

Line: 573


    rollback to update_default_posting;

Line: 587


    rollback to update_default_posting;

Line: 593


end update_default_posting;

Line: 600


procedure delete_default_posting
  (P_VALIDATE                  in       BOOLEAN  default false
  ,P_DEFAULT_POSTING_ID        in       NUMBER
  ,P_OBJECT_VERSION_NUMBER     in       NUMBER
  ) is

  --
  -- Declare cursors and local variables
  --

  l_proc                   varchar2(72) := g_package||'delete_default_posting';

Line: 618


  savepoint delete_default_posting;

Line: 624


    irc_default_posting_bk3.delete_default_posting_b
    (P_DEFAULT_POSTING_ID      => P_DEFAULT_POSTING_ID
    );

Line: 630


        (p_module_name => 'delete_default_posting'
        ,p_hook_type   => 'BP'
        );

Line: 663


    irc_default_posting_bk3.delete_default_posting_a
    (P_DEFAULT_POSTING_ID      => P_DEFAULT_POSTING_ID
    );

Line: 669


        (p_module_name => 'delete_default_posting'
        ,p_hook_type   => 'AP'
        );

Line: 687


    rollback to delete_default_posting;

Line: 698


    rollback to delete_default_posting;

Line: 701


end delete_default_posting;