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

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

Line: 158


        IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,p_old_QUALIFIERS_rec.last_updated_by)
        THEN
            l_index := l_index + 1;

Line: 161


            l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;

Line: 164


        IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,p_old_QUALIFIERS_rec.last_update_date)
        THEN
            l_index := l_index + 1;

Line: 167


            l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;

Line: 170


        IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,p_old_QUALIFIERS_rec.last_update_login)
        THEN
            l_index := l_index + 1;

Line: 173


            l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;

Line: 200


        IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,p_old_QUALIFIERS_rec.program_update_date)
        THEN
            l_index := l_index + 1;

Line: 203


            l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 320


    ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
        l_index := l_index + 1;

Line: 322


        l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;

Line: 323


    ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
        l_index := l_index + 1;

Line: 325


        l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;

Line: 326


    ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
        l_index := l_index + 1;

Line: 328


        l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;

Line: 341


    ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
        l_index := l_index + 1;

Line: 343


        l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 497


    IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,p_old_QUALIFIERS_rec.last_updated_by)
    THEN
        NULL;

Line: 502


    IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,p_old_QUALIFIERS_rec.last_update_date)
    THEN
        NULL;

Line: 507


    IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,p_old_QUALIFIERS_rec.last_update_login)
    THEN
        NULL;

Line: 532


    IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,p_old_QUALIFIERS_rec.program_update_date)
    THEN
        NULL;

Line: 677


    IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_QUALIFIERS_rec.last_updated_by := p_old_QUALIFIERS_rec.last_updated_by;

Line: 681


    IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_QUALIFIERS_rec.last_update_date := p_old_QUALIFIERS_rec.last_update_date;

Line: 685


    IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_QUALIFIERS_rec.last_update_login := p_old_QUALIFIERS_rec.last_update_login;

Line: 705


    IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_QUALIFIERS_rec.program_update_date := p_old_QUALIFIERS_rec.program_update_date;

Line: 842


    IF l_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_QUALIFIERS_rec.last_updated_by := NULL;

Line: 846


    IF l_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_QUALIFIERS_rec.last_update_date := NULL;

Line: 850


    IF l_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_QUALIFIERS_rec.last_update_login := NULL;

Line: 870


    IF l_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_QUALIFIERS_rec.program_update_date := NULL;

Line: 912


PROCEDURE Update_Row
(   p_QUALIFIERS_rec                IN  QP_Modifiers_PUB.Qualifiers_Rec_Type
)
IS
l_check_active_flag VARCHAR2(1);

Line: 921


    SELECT ACTIVE_FLAG
       INTO   l_active_flag
       FROM   QP_LIST_HEADERS_B
       WHERE  LIST_HEADER_ID = p_QUALIFIERS_rec.list_header_id;

Line: 928


    UPDATE  QP_QUALIFIERS
    SET     ATTRIBUTE1                     = p_QUALIFIERS_rec.attribute1
    ,       ATTRIBUTE10                    = p_QUALIFIERS_rec.attribute10
    ,       ATTRIBUTE11                    = p_QUALIFIERS_rec.attribute11
    ,       ATTRIBUTE12                    = p_QUALIFIERS_rec.attribute12
    ,       ATTRIBUTE13                    = p_QUALIFIERS_rec.attribute13
    ,       ATTRIBUTE14                    = p_QUALIFIERS_rec.attribute14
    ,       ATTRIBUTE15                    = p_QUALIFIERS_rec.attribute15
    ,       ATTRIBUTE2                     = p_QUALIFIERS_rec.attribute2
    ,       ATTRIBUTE3                     = p_QUALIFIERS_rec.attribute3
    ,       ATTRIBUTE4                     = p_QUALIFIERS_rec.attribute4
    ,       ATTRIBUTE5                     = p_QUALIFIERS_rec.attribute5
    ,       ATTRIBUTE6                     = p_QUALIFIERS_rec.attribute6
    ,       ATTRIBUTE7                     = p_QUALIFIERS_rec.attribute7
    ,       ATTRIBUTE8                     = p_QUALIFIERS_rec.attribute8
    ,       ATTRIBUTE9                     = p_QUALIFIERS_rec.attribute9
    ,       COMPARISON_OPERATOR_CODE       = p_QUALIFIERS_rec.comparison_operator_code
    ,       CONTEXT                        = p_QUALIFIERS_rec.context
    ,       CREATED_BY                     = p_QUALIFIERS_rec.created_by
    ,       CREATED_FROM_RULE_ID           = p_QUALIFIERS_rec.created_from_rule_id
    ,       CREATION_DATE                  = p_QUALIFIERS_rec.creation_date
    ,       END_DATE_ACTIVE                = p_QUALIFIERS_rec.end_date_active
    ,       EXCLUDER_FLAG                  = p_QUALIFIERS_rec.excluder_flag
    ,       LAST_UPDATED_BY                = p_QUALIFIERS_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_QUALIFIERS_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_QUALIFIERS_rec.last_update_login
    ,       LIST_HEADER_ID                 = p_QUALIFIERS_rec.list_header_id
    ,       LIST_LINE_ID                   = p_QUALIFIERS_rec.list_line_id
    ,       PROGRAM_APPLICATION_ID         = p_QUALIFIERS_rec.program_application_id
    ,       PROGRAM_ID                     = p_QUALIFIERS_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_QUALIFIERS_rec.program_update_date
    ,       QUALIFIER_ATTRIBUTE            = p_QUALIFIERS_rec.qualifier_attribute
    ,       QUALIFIER_ATTR_VALUE           = p_QUALIFIERS_rec.qualifier_attr_value
    ,       QUALIFIER_CONTEXT              = p_QUALIFIERS_rec.qualifier_context
    ,       QUALIFIER_GROUPING_NO          = p_QUALIFIERS_rec.qualifier_grouping_no
    ,       QUALIFIER_ID                   = p_QUALIFIERS_rec.qualifier_id
    ,       QUALIFIER_RULE_ID              = p_QUALIFIERS_rec.qualifier_rule_id
    ,       REQUEST_ID                     = p_QUALIFIERS_rec.request_id
    ,       START_DATE_ACTIVE              = p_QUALIFIERS_rec.start_date_active
    WHERE   QUALIFIER_ID = p_QUALIFIERS_rec.qualifier_id
    ;

Line: 977


  UPDATE qp_pte_segments SET used_in_setup='Y'
  WHERE  nvl(used_in_setup,'N')='N'
  AND segment_id IN
  (SELECT a.segment_id
   FROM   qp_segments_b a,qp_prc_contexts_b b
   WHERE a.segment_mapping_column=p_QUALIFIERS_rec.qualifier_attribute
   AND   a.prc_context_id=b.prc_context_id
   AND   b.prc_context_type='QUALIFIER'
   AND   b.prc_context_code=p_QUALIFIERS_rec.qualifier_context);

Line: 997


            ,   'Update_Row'
            );

Line: 1003


END Update_Row;

Line: 1007


PROCEDURE Insert_Row
(   p_QUALIFIERS_rec                IN  QP_Modifiers_PUB.Qualifiers_Rec_Type
)
IS
l_check_active_flag VARCHAR2(1);

Line: 1014


SELECT ACTIVE_FLAG
       INTO   l_active_flag
       FROM   QP_LIST_HEADERS_B
       WHERE  LIST_HEADER_ID = p_QUALIFIERS_rec.list_header_id;

Line: 1019


    INSERT  INTO QP_QUALIFIERS
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       COMPARISON_OPERATOR_CODE
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATED_FROM_RULE_ID
    ,       CREATION_DATE
    ,       END_DATE_ACTIVE
    ,       EXCLUDER_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_HEADER_ID
    ,       LIST_LINE_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       QUALIFIER_ATTRIBUTE
    ,       QUALIFIER_ATTR_VALUE
    ,       QUALIFIER_CONTEXT
    ,       QUALIFIER_GROUPING_NO
    ,       QUALIFIER_ID
    ,       QUALIFIER_RULE_ID
    ,       REQUEST_ID
    ,       START_DATE_ACTIVE
    )
    VALUES
    (       p_QUALIFIERS_rec.attribute1
    ,       p_QUALIFIERS_rec.attribute10
    ,       p_QUALIFIERS_rec.attribute11
    ,       p_QUALIFIERS_rec.attribute12
    ,       p_QUALIFIERS_rec.attribute13
    ,       p_QUALIFIERS_rec.attribute14
    ,       p_QUALIFIERS_rec.attribute15
    ,       p_QUALIFIERS_rec.attribute2
    ,       p_QUALIFIERS_rec.attribute3
    ,       p_QUALIFIERS_rec.attribute4
    ,       p_QUALIFIERS_rec.attribute5
    ,       p_QUALIFIERS_rec.attribute6
    ,       p_QUALIFIERS_rec.attribute7
    ,       p_QUALIFIERS_rec.attribute8
    ,       p_QUALIFIERS_rec.attribute9
    ,       p_QUALIFIERS_rec.comparison_operator_code
    ,       p_QUALIFIERS_rec.context
    ,       p_QUALIFIERS_rec.created_by
    ,       p_QUALIFIERS_rec.created_from_rule_id
    ,       p_QUALIFIERS_rec.creation_date
    ,       p_QUALIFIERS_rec.end_date_active
    ,       p_QUALIFIERS_rec.excluder_flag
    ,       p_QUALIFIERS_rec.last_updated_by
    ,       p_QUALIFIERS_rec.last_update_date
    ,       p_QUALIFIERS_rec.last_update_login
    ,       p_QUALIFIERS_rec.list_header_id
    ,       p_QUALIFIERS_rec.list_line_id
    ,       p_QUALIFIERS_rec.program_application_id
    ,       p_QUALIFIERS_rec.program_id
    ,       p_QUALIFIERS_rec.program_update_date
    ,       p_QUALIFIERS_rec.qualifier_attribute
    ,       p_QUALIFIERS_rec.qualifier_attr_value
    ,       p_QUALIFIERS_rec.qualifier_context
    ,       p_QUALIFIERS_rec.qualifier_grouping_no
    ,       p_QUALIFIERS_rec.qualifier_id
    ,       p_QUALIFIERS_rec.qualifier_rule_id
    ,       p_QUALIFIERS_rec.request_id
    ,       p_QUALIFIERS_rec.start_date_active
    );

Line: 1105


  UPDATE qp_pte_segments SET used_in_setup='Y'
  WHERE  nvl(used_in_setup,'N')='N'
  AND segment_id IN
  (SELECT a.segment_id
   FROM   qp_segments_b a,qp_prc_contexts_b b
   WHERE a.segment_mapping_column=p_QUALIFIERS_rec.qualifier_attribute
   AND   a.prc_context_id=b.prc_context_id
   AND   b.prc_context_type='QUALIFIER'
   AND   b.prc_context_code=p_QUALIFIERS_rec.qualifier_context);

Line: 1125


            ,   'Insert_Row'
            );

Line: 1131


END Insert_Row;

Line: 1135


PROCEDURE Delete_Row
(   p_qualifier_id                  IN  NUMBER
)
IS
BEGIN

    DELETE  FROM QP_QUALIFIERS
    WHERE   QUALIFIER_ID = p_qualifier_id
    ;

Line: 1153


            ,   'Delete_Row'
            );

Line: 1159


END Delete_Row;

Line: 1190


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       COMPARISON_OPERATOR_CODE
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATED_FROM_RULE_ID
    ,       CREATION_DATE
    ,       END_DATE_ACTIVE
    ,       EXCLUDER_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_HEADER_ID
    ,       LIST_LINE_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       QUALIFIER_ATTRIBUTE
    ,       QUALIFIER_ATTR_VALUE
    ,       QUALIFIER_ATTR_VALUE_TO
    ,       QUALIFIER_CONTEXT
    ,       QUALIFIER_GROUPING_NO
    ,       QUALIFIER_ID
    ,       QUALIFIER_RULE_ID
    ,       REQUEST_ID
    ,       START_DATE_ACTIVE
    ,       LIST_TYPE_CODE
    ,       QUAL_ATTR_VALUE_FROM_NUMBER
    ,       QUAL_ATTR_VALUE_TO_NUMBER
    ,       ACTIVE_FLAG
    ,       QUALIFIER_PRECEDENCE
    ,       QUALIFIER_DATATYPE
    ,	  SEARCH_IND
    ,	  QUALIFIER_GROUP_CNT
    ,	  HEADER_QUALS_EXIST_FLAG
    ,	  DISTINCT_ROW_COUNT
    FROM    QP_QUALIFIERS
    WHERE ( QUALIFIER_ID = p_qualifier_id
    )
    OR (    LIST_HEADER_ID = p_list_header_id
    );

Line: 1296


        l_QUALIFIERS_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 1297


        l_QUALIFIERS_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 1298


        l_QUALIFIERS_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 1303


        l_QUALIFIERS_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 1380


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       COMPARISON_OPERATOR_CODE
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATED_FROM_RULE_ID
    ,       CREATION_DATE
    ,       END_DATE_ACTIVE
    ,       EXCLUDER_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_HEADER_ID
    ,       LIST_LINE_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       QUALIFIER_ATTRIBUTE
    ,       QUALIFIER_ATTR_VALUE
    ,       QUALIFIER_CONTEXT
    ,       QUALIFIER_GROUPING_NO
    ,       QUALIFIER_ID
    ,       QUALIFIER_RULE_ID
    ,       REQUEST_ID
    ,       START_DATE_ACTIVE
    INTO    l_QUALIFIERS_rec.attribute1
    ,       l_QUALIFIERS_rec.attribute10
    ,       l_QUALIFIERS_rec.attribute11
    ,       l_QUALIFIERS_rec.attribute12
    ,       l_QUALIFIERS_rec.attribute13
    ,       l_QUALIFIERS_rec.attribute14
    ,       l_QUALIFIERS_rec.attribute15
    ,       l_QUALIFIERS_rec.attribute2
    ,       l_QUALIFIERS_rec.attribute3
    ,       l_QUALIFIERS_rec.attribute4
    ,       l_QUALIFIERS_rec.attribute5
    ,       l_QUALIFIERS_rec.attribute6
    ,       l_QUALIFIERS_rec.attribute7
    ,       l_QUALIFIERS_rec.attribute8
    ,       l_QUALIFIERS_rec.attribute9
    ,       l_QUALIFIERS_rec.comparison_operator_code
    ,       l_QUALIFIERS_rec.context
    ,       l_QUALIFIERS_rec.created_by
    ,       l_QUALIFIERS_rec.created_from_rule_id
    ,       l_QUALIFIERS_rec.creation_date
    ,       l_QUALIFIERS_rec.end_date_active
    ,       l_QUALIFIERS_rec.excluder_flag
    ,       l_QUALIFIERS_rec.last_updated_by
    ,       l_QUALIFIERS_rec.last_update_date
    ,       l_QUALIFIERS_rec.last_update_login
    ,       l_QUALIFIERS_rec.list_header_id
    ,       l_QUALIFIERS_rec.list_line_id
    ,       l_QUALIFIERS_rec.program_application_id
    ,       l_QUALIFIERS_rec.program_id
    ,       l_QUALIFIERS_rec.program_update_date
    ,       l_QUALIFIERS_rec.qualifier_attribute
    ,       l_QUALIFIERS_rec.qualifier_attr_value
    ,       l_QUALIFIERS_rec.qualifier_context
    ,       l_QUALIFIERS_rec.qualifier_grouping_no
    ,       l_QUALIFIERS_rec.qualifier_id
    ,       l_QUALIFIERS_rec.qualifier_rule_id
    ,       l_QUALIFIERS_rec.request_id
    ,       l_QUALIFIERS_rec.start_date_active
    FROM    QP_QUALIFIERS
    WHERE   QUALIFIER_ID = p_QUALIFIERS_rec.qualifier_id
        FOR UPDATE NOWAIT;

Line: 1506


    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
                         l_QUALIFIERS_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
                         l_QUALIFIERS_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
                         l_QUALIFIERS_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
                         l_QUALIFIERS_rec.list_header_id)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
                         l_QUALIFIERS_rec.list_line_id)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
                         l_QUALIFIERS_rec.program_application_id)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
                         l_QUALIFIERS_rec.program_id)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
                         l_QUALIFIERS_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
                         l_QUALIFIERS_rec.qualifier_attribute)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
                         l_QUALIFIERS_rec.qualifier_attr_value)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
                         l_QUALIFIERS_rec.qualifier_context)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
                         l_QUALIFIERS_rec.qualifier_grouping_no)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
                         l_QUALIFIERS_rec.qualifier_id)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
                         l_QUALIFIERS_rec.qualifier_rule_id)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
                         l_QUALIFIERS_rec.request_id)
    AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
                         l_QUALIFIERS_rec.start_date_active)
    THEN

        --  Row has not changed. Set out parameter.

        x_QUALIFIERS_rec               := l_QUALIFIERS_rec;

Line: 1576


            FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');