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

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

Line: 37


      SELECT AMS_IBA_PS_POSTINGS_B_s.NEXTVAL
      FROM dual;

Line: 41


      SELECT 1
      FROM AMS_IBA_PS_POSTINGS_B
      WHERE POSTING_ID = l_id;

Line: 128


    select 'X' into l_tempchar
    from AMS_IBA_PS_POSTINGS_TL ptl
    where ptl.posting_name = p_ps_posting_rec.posting_name
    and ptl.language = userenv('LANG');

Line: 149


      AMS_IBA_PS_POSTINGS_B_PKG.Insert_Row(
          p_created_by  => FND_GLOBAL.user_id,
          p_creation_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.user_id,
          p_last_update_date  => SYSDATE,
          p_last_update_login  => FND_GLOBAL.conc_login_id,
          px_object_version_number  => l_object_version_number,
          px_posting_id  => l_posting_id,
          p_max_no_contents  => p_ps_posting_rec.max_no_contents,
          p_posting_type  => p_ps_posting_rec.posting_type,
          p_content_type  => p_ps_posting_rec.content_type,
          p_default_content_id  => p_ps_posting_rec.default_content_id,
          p_status_code  => p_ps_posting_rec.status_code,
          p_posting_name  => p_ps_posting_rec.posting_name,
          p_display_name  => p_ps_posting_rec.display_name,
          p_posting_description  => p_ps_posting_rec.posting_description,
          p_attribute_category  => p_ps_posting_rec.attribute_category,
          p_attribute1  => p_ps_posting_rec.attribute1,
          p_attribute2  => p_ps_posting_rec.attribute2,
          p_attribute3  => p_ps_posting_rec.attribute3,
          p_attribute4  => p_ps_posting_rec.attribute4,
          p_attribute5  => p_ps_posting_rec.attribute5,
          p_attribute6  => p_ps_posting_rec.attribute6,
          p_attribute7  => p_ps_posting_rec.attribute7,
          p_attribute8  => p_ps_posting_rec.attribute8,
          p_attribute9  => p_ps_posting_rec.attribute9,
          p_attribute10  => p_ps_posting_rec.attribute10,
          p_attribute11  => p_ps_posting_rec.attribute11,
          p_attribute12  => p_ps_posting_rec.attribute12,
          p_attribute13  => p_ps_posting_rec.attribute13,
          p_attribute14  => p_ps_posting_rec.attribute14,
          p_attribute15  => p_ps_posting_rec.attribute15);

Line: 249


PROCEDURE Update_Ps_Posting(
    p_api_version_number    IN   NUMBER,
    p_init_msg_list         IN   VARCHAR2 := FND_API.G_FALSE,
    p_commit                IN   VARCHAR2 := FND_API.G_FALSE,
    p_validation_level      IN   NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status         OUT NOCOPY  VARCHAR2,
    x_msg_count             OUT NOCOPY  NUMBER,
    x_msg_data              OUT NOCOPY  VARCHAR2,
    p_ps_posting_rec        IN   ps_posting_rec_type,
    x_object_version_number OUT NOCOPY  NUMBER
    )
 IS
l_api_name            CONSTANT VARCHAR2(30) := 'Update_Ps_Posting';

Line: 267


    SELECT object_version_number
    FROM  AMS_IBA_PS_POSTINGS_B
    WHERE posting_id = post_id;

Line: 273


      SAVEPOINT UPDATE_Ps_Posting_PVT;

Line: 301


        AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

Line: 309


        AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
          p_token_name   => 'INFO',
          p_token_value  => 'Ps_Posting') ;

Line: 363


       Update AMS_IBA_PS_POSTINGS_B
       SET
         last_updated_by = FND_GLOBAL.user_id,
         last_update_date = SYSDATE,
         last_update_login = FND_GLOBAL.conc_login_id,
         object_version_number = p_ps_posting_rec.object_version_number+1,
         max_no_contents = DECODE( p_ps_posting_rec.max_no_contents, FND_API.g_miss_num, max_no_contents, p_ps_posting_rec.max_no_contents),
         posting_type = DECODE( p_ps_posting_rec.posting_type, FND_API.g_miss_char, posting_type, p_ps_posting_rec.posting_type),
         content_type = DECODE( p_ps_posting_rec.content_type, FND_API.g_miss_char, content_type, p_ps_posting_rec.content_type),
         default_content_id = DECODE( p_ps_posting_rec.default_content_id, FND_API.g_miss_num, default_content_id, p_ps_posting_rec.default_content_id),
         status_code = DECODE( p_ps_posting_rec.status_code, FND_API.g_miss_char, status_code, p_ps_posting_rec.status_code),
       attribute_category = DECODE( p_ps_posting_rec.attribute_category, FND_API.g_miss_char, attribute_category, p_ps_posting_rec.attribute_category),
       attribute1 = DECODE( p_ps_posting_rec.attribute1, FND_API.g_miss_char, attribute1, p_ps_posting_rec.attribute1),
       attribute2 = DECODE( p_ps_posting_rec.attribute2, FND_API.g_miss_char, attribute2, p_ps_posting_rec.attribute2),
       attribute3 = DECODE( p_ps_posting_rec.attribute3, FND_API.g_miss_char, attribute3, p_ps_posting_rec.attribute3),
       attribute4 = DECODE( p_ps_posting_rec.attribute4, FND_API.g_miss_char, attribute4, p_ps_posting_rec.attribute4),
       attribute5 = DECODE( p_ps_posting_rec.attribute5, FND_API.g_miss_char, attribute5, p_ps_posting_rec.attribute5),
       attribute6 = DECODE( p_ps_posting_rec.attribute6, FND_API.g_miss_char, attribute6, p_ps_posting_rec.attribute6),
       attribute7 = DECODE( p_ps_posting_rec.attribute7, FND_API.g_miss_char, attribute7, p_ps_posting_rec.attribute7),
       attribute8 = DECODE( p_ps_posting_rec.attribute8, FND_API.g_miss_char, attribute8, p_ps_posting_rec.attribute8),
       attribute9 = DECODE( p_ps_posting_rec.attribute9, FND_API.g_miss_char, attribute9, p_ps_posting_rec.attribute9),
       attribute10 = DECODE( p_ps_posting_rec.attribute10, FND_API.g_miss_char, attribute10, p_ps_posting_rec.attribute10),
       attribute11 = DECODE( p_ps_posting_rec.attribute11, FND_API.g_miss_char, attribute11, p_ps_posting_rec.attribute11),
       attribute12 = DECODE( p_ps_posting_rec.attribute12, FND_API.g_miss_char, attribute12, p_ps_posting_rec.attribute12),
       attribute13 = DECODE( p_ps_posting_rec.attribute13, FND_API.g_miss_char, attribute13, p_ps_posting_rec.attribute13),
       attribute14 = DECODE( p_ps_posting_rec.attribute14, FND_API.g_miss_char, attribute14, p_ps_posting_rec.attribute14),
       attribute15 = DECODE( p_ps_posting_rec.attribute15, FND_API.g_miss_char, attribute15, p_ps_posting_rec.attribute15)

      WHERE posting_id = p_ps_posting_rec.posting_id
      AND object_version_number = p_ps_posting_rec.object_version_number;

Line: 403


          AMS_UTILITY_PVT.debug_message('Private API: Updated B');

Line: 407


    select 'X' into l_tempchar
    from AMS_IBA_PS_POSTINGS_TL ptl
    where ptl.posting_name = p_ps_posting_rec.posting_name
    and ptl.language = userenv('LANG')
    and p_ps_posting_rec.posting_id <> ptl.posting_id;

Line: 427


     UPDATE AMS_IBA_PS_POSTINGS_TL SET
       posting_name = decode( p_ps_posting_rec.posting_name, FND_API.G_MISS_CHAR, posting_name, p_ps_posting_rec.posting_name),
       display_name = decode( p_ps_posting_rec.display_name, FND_API.G_MISS_CHAR, display_name, p_ps_posting_rec.display_name),
       posting_description = decode( p_ps_posting_rec.posting_description, FND_API.G_MISS_CHAR, posting_description, p_ps_posting_rec.posting_description),
       last_update_date = SYSDATE,
       last_updated_by = FND_GLOBAL.user_id,
       last_update_login = FND_GLOBAL.conc_login_id,
       source_lang = USERENV('LANG')
     WHERE posting_id = p_ps_posting_rec.posting_id
     AND USERENV('LANG') IN (language, source_lang);

Line: 447


        AMS_UTILITY_PVT.debug_message('Private API: Updated TL');

Line: 473


     ROLLBACK TO UPDATE_Ps_Posting_PVT;

Line: 483


     ROLLBACK TO UPDATE_Ps_Posting_PVT;

Line: 493


     ROLLBACK TO UPDATE_Ps_Posting_PVT;

Line: 505


End Update_Ps_Posting;

Line: 508


PROCEDURE Delete_Ps_Posting(
    p_api_version_number     IN  NUMBER,
    p_init_msg_list          IN  VARCHAR2  := FND_API.G_FALSE,
    p_commit                 IN  VARCHAR2  := FND_API.G_FALSE,
    p_validation_level       IN  NUMBER    := FND_API.G_VALID_LEVEL_FULL,
    x_return_status          OUT NOCOPY  VARCHAR2,
    x_msg_count              OUT NOCOPY  NUMBER,
    x_msg_data               OUT NOCOPY  VARCHAR2,
    p_posting_id             IN  NUMBER,
    p_object_version_number  IN  NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Ps_Posting';

Line: 529


	SELECT COUNT(*)
	FROM AMS_IBA_PL_PLACEMENTS_B
	where posting_id = post_id;

Line: 534


	SELECT object_version_number
	FROM AMS_IBA_PS_POSTINGS_B
	where posting_id = post_id;

Line: 539


	SELECT rulegroup_id
	FROM AMS_IBA_PS_RULEGRPS_B
	where posting_id = post_id;

Line: 545


      SAVEPOINT DELETE_Ps_Posting_PVT;

Line: 585


          DELETE FROM AMS_IBA_PS_POSTINGS_B
          WHERE posting_id = p_posting_id;

Line: 596


          DELETE FROM AMS_IBA_PS_POSTINGS_TL
          WHERE posting_id = p_posting_id;

Line: 606


            DELETE FROM AMS_IBA_PS_RULES
            WHERE rulegroup_id = l_rulegroup_id;

Line: 609


            DELETE FROM AMS_IBA_PS_RULEGRPS_TL
            WHERE rulegroup_id = l_rulegroup_id;

Line: 612


            DELETE FROM AMS_IBA_PS_RL_ST_PARAMS
            WHERE rulegroup_id = l_rulegroup_id;

Line: 615


            DELETE FROM AMS_IBA_PS_RL_ST_FLTRS
            WHERE rulegroup_id = l_rulegroup_id;

Line: 620


          DELETE FROM AMS_IBA_PS_RULEGRPS_B
          WHERE posting_id = p_posting_id;

Line: 666


     ROLLBACK TO DELETE_Ps_Posting_PVT;

Line: 676


     ROLLBACK TO DELETE_Ps_Posting_PVT;

Line: 686


     ROLLBACK TO DELETE_Ps_Posting_PVT;

Line: 698


End Delete_Ps_Posting;

Line: 722


   SELECT POSTING_ID
   FROM AMS_IBA_PS_POSTINGS_B
   WHERE POSTING_ID = p_POSTING_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 834


      SELECT *
      FROM ams_iba_ps_postings_b
      WHERE posting_id = p_ps_posting_rec.posting_id;

Line: 857


   IF p_ps_posting_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := l_ps_posting_rec.last_updated_by;

Line: 862


   IF p_ps_posting_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := l_ps_posting_rec.last_update_date;

Line: 867


   IF p_ps_posting_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := l_ps_posting_rec.last_update_login;