APPS.PO_UDA_DEFAULTING_PKG SQL Statements

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

Line: 170

            SELECT ENTITY_CODE
            INTO   l_entity_code
            FROM   PO_UDA_AG_TEMPLATES
            WHERE  TEMPLATE_ID = p_template_id;

Line: 189

            select o.pk1_column_name,
                   o.pk2_column_name,
                   o.pk3_column_name,
                   o.pk4_column_name,
                   o.pk5_column_name
            into   l_pk1_column_name,
                   l_pk2_column_name,
                   l_pk3_column_name,
                   l_pk4_column_name,
                   l_pk5_column_name
            from   fnd_objects_vl o
            where  o.obj_name = PO_UDA_DATA_UTIL.g_object_dff_tl(l_entity_code).l_object_name;

Line: 216

        SELECT     DISTINCT(ATTRIBUTE_CATEGORY)
        INTO       l_attr_category
        FROM       po_uda_ag_template_usages
        WHERE      template_id = p_template_id
        AND        attribute_group_id = p_attr_grp_id;

Line: 226

        l_sql_query := 'SELECT 1 FROM ' || l_ext_table;

Line: 366

        SELECT     DISTINCT(ATTRIBUTE_CATEGORY)
        FROM       po_uda_ag_template_usages
        WHERE template_id = p_template_id;

Line: 371

        SELECT     CLM_IDC_TYPE, CONTRACT_TYPE
        FROM       po_lines_merge_v
        WHERE      PO_LINE_ID = p_line_id
        AND        DRAFT_ID = p_draft_id;

Line: 377

        SELECT     CLM_STANDARD_FORM
        FROM       po_headers_merge_v
        WHERE      po_header_id = p_header_id
        AND        DRAFT_ID = p_draft_id;

Line: 416

            SELECT ENTITY_CODE
            INTO   l_entity_code
            FROM   PO_UDA_AG_TEMPLATES
            WHERE  TEMPLATE_ID = p_template_id;

Line: 559

        SELECT  DISTINCT ATTR_GROUP_ID
        FROM    PO_HEADERS_ALL_EXT_B
        WHERE   PO_HEADER_ID = p_header_id
        AND     DRAFT_ID = p_draft_id;

Line: 565

        SELECT  DISTINCT ATTR_GROUP_ID
        FROM    PO_LINES_ALL_EXT_B
        WHERE   PO_LINE_ID = p_line_id
        AND     DRAFT_ID = p_draft_id;

Line: 571

        SELECT  DISTINCT ATTR_GROUP_ID
        FROM    PO_LINE_LOCATIONS_ALL_EXT_B
        WHERE   LINE_LOCATION_ID = p_location_id
        AND     DRAFT_ID = p_draft_id;

Line: 577

        SELECT  END_USER_COLUMN_NAME
        FROM    FND_DESCR_FLEX_COLUMN_USAGES
        WHERE   DESCRIPTIVE_FLEXFIELD_NAME = p_ag_type
        AND     DESCRIPTIVE_FLEX_CONTEXT_CODE = p_ag_name;

Line: 643

            SELECT ENTITY_CODE
            INTO   l_entity_code
            FROM   PO_UDA_AG_TEMPLATES
            WHERE  TEMPLATE_ID = p_template_id;

Line: 666

                    SELECT  DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE
                    INTO    l_ag_type, l_ag_name
                    FROM    EGO_FND_DSC_FLX_CTX_EXT
                    WHERE   ATTR_GROUP_ID = c_po_header_ext_rec.ATTR_GROUP_ID;

Line: 738

                    SELECT  DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE
                    INTO    l_ag_type, l_ag_name
                    FROM    EGO_FND_DSC_FLX_CTX_EXT
                    WHERE   ATTR_GROUP_ID = c_po_line_ext_rec.ATTR_GROUP_ID;

Line: 809

                    SELECT  DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE
                    INTO    l_ag_type, l_ag_name
                    FROM    EGO_FND_DSC_FLX_CTX_EXT
                    WHERE   ATTR_GROUP_ID = c_po_location_ext_rec.ATTR_GROUP_ID;

Line: 1022

        SELECT  PO_LINE_ID, ITEM_ID, LINE_TYPE_ID
        FROM    po_lines_merge_v pll
        WHERE   PO_HEADER_ID = p_po_header_id
          AND   DRAFT_ID = p_draft_id
          AND   EXISTS ( SELECT 1 FROM  EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage
                                        WHERE   act.action_id = actdisp.action_id
                                           AND  pousage.template_id = pll.uda_template_id
                                           AND  pousage.attribute_group_id =  act.attr_group_id
                                           AND  To_Char(pousage.template_id) = act.classification_code
                                           AND  actdisp.execution_method = 'XSC');

Line: 1038

        SELECT  LINE_LOCATION_ID, SHIP_TO_LOCATION_ID
        FROM    po_line_locations_merge_v pll
        WHERE   PO_HEADER_ID = p_po_header_id
          AND   PO_LINE_ID = p_line_id
          AND   DRAFT_ID = p_draft_id
          AND   EXISTS ( SELECT 1 FROM  EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage
                                        WHERE   act.action_id = actdisp.action_id
                                           AND  pousage.template_id = pll.uda_template_id
                                           AND  pousage.attribute_group_id =  act.attr_group_id
                                           AND  To_Char(pousage.template_id) = act.classification_code
                                           AND  actdisp.execution_method = 'XSC');

Line: 1071

            SELECT  VENDOR_ID, VENDOR_SITE_ID, VENDOR_CONTACT_ID
            INTO    l_vendor_id, l_vendor_site_id, l_vendor_contact_id
            FROM    po_headers_merge_v
            WHERE   PO_HEADER_ID = p_po_header_id
            AND     DRAFT_ID = p_draft_id;

Line: 1102

            SELECT  UDA_TEMPLATE_ID
            INTO    l_template_id
            FROM    po_headers_merge_v
            WHERE   PO_HEADER_ID = p_po_header_id
            AND     DRAFT_ID = p_draft_id;

Line: 1160

                    SELECT  UDA_TEMPLATE_ID
                    INTO    l_line_template_id
                    FROM    po_lines_draft_all
                    WHERE   PO_LINE_ID = c_get_lines_rec.PO_LINE_ID
                    AND     DRAFT_ID = p_draft_id;

Line: 1210

                            SELECT  UDA_TEMPLATE_ID
                            INTO    l_shipment_template_id
                            FROM    PO_LINE_LOCATIONS_draft_all
                            WHERE   LINE_LOCATION_ID = c_get_shipments_rec.LINE_LOCATION_ID
                            AND     DRAFT_ID = p_draft_id;

Line: 1318

        SELECT  PO_LINE_ID, ITEM_ID, LINE_TYPE_ID, CONTRACT_TYPE, CATEGORY_ID
        FROM    PO_LINES_DRAFT_ALL
        WHERE   PO_HEADER_ID = p_po_header_id
        AND     DRAFT_ID = p_draft_id;

Line: 1329

        SELECT  LINE_LOCATION_ID, SHIP_TO_LOCATION_ID
        FROM    PO_LINE_LOCATIONS_DRAFT_ALL
        WHERE   PO_HEADER_ID = p_po_header_id
        AND     PO_LINE_ID = p_line_id
        AND     DRAFT_ID = p_draft_id;

Line: 1359

                    SELECT  VENDOR_ID, VENDOR_SITE_ID, VENDOR_CONTACT_ID, ORG_ID, AGENT_ID, UDA_TEMPLATE_ID
                    INTO    l_vendor_id, l_vendor_site_id, l_vendor_contact_id, l_org_id, l_agent_id, l_template_id
                    FROM    PO_HEADERS_MERGE_V
                    WHERE   PO_HEADER_ID = p_po_header_id
                    AND     DRAFT_ID = p_draft_id;

Line: 1377

                    SELECT  VENDOR_ID, VENDOR_SITE_ID, VENDOR_CONTACT_ID, ORG_ID, AGENT_ID, UDA_TEMPLATE_ID
                    INTO    l_vendor_id, l_vendor_site_id, l_vendor_contact_id, l_org_id, l_agent_id, l_template_id
                    FROM    PO_HEADERS_MERGE_V
                    WHERE   PO_HEADER_ID = p_po_header_id
                    AND     DRAFT_ID = -1;

Line: 1394

                SELECT  VENDOR_ID, VENDOR_SITE_ID, VENDOR_CONTACT_ID, ORG_ID, AGENT_ID, UDA_TEMPLATE_ID
                INTO    l_vendor_id, l_vendor_site_id, l_vendor_contact_id, l_org_id, l_agent_id, l_template_id
                FROM    PO_HEADERS_MERGE_V
                WHERE   PO_HEADER_ID = p_po_header_id
                AND     DRAFT_ID = p_draft_id;

Line: 1508

                        SELECT  UDA_TEMPLATE_ID
                        INTO    l_line_template_id
                        FROM    PO_LINES_DRAFT_ALL
                        WHERE   PO_LINE_ID = c_get_lines_rec.PO_LINE_ID
                        AND     DRAFT_ID = p_draft_id;

Line: 1533

                        select 1
                        into   l_present
                        from   po_Lines_all_ext_b
                        where  po_line_id = c_get_lines_rec.PO_LINE_ID
                          and  draft_id = l_draft_id
                          AND  ROWNUM < 2;

Line: 1600

                                SELECT  UDA_TEMPLATE_ID
                                INTO    l_shipment_template_id
                                FROM    PO_LINE_LOCATIONS_DRAFT_ALL
                                WHERE   LINE_LOCATION_ID = c_get_shipments_rec.LINE_LOCATION_ID
                                AND     DRAFT_ID = p_draft_id;

Line: 1624

                                SELECT 1
                                INTO   l_present
                                FROM   po_Line_locations_all_ext_b
                                WHERE  line_location_id = c_get_shipments_rec.LINE_LOCATION_ID
                                  AND  draft_id = l_draft_id
                                  AND  ROWNUM < 2;

Line: 1926

            SELECT ENTITY_CODE
            INTO   l_entity_code
            FROM   PO_UDA_AG_TEMPLATES
            WHERE  TEMPLATE_ID = p_template_id;

Line: 2199

        SELECT  DISTINCT ATTR_GROUP_ID
        FROM    PO_HEADERS_ALL_EXT_B
        WHERE   PO_HEADER_ID = p_header_id;

Line: 2204

        SELECT  DISTINCT ATTR_GROUP_ID
        FROM    PO_LINES_ALL_EXT_B
        WHERE   PO_LINE_ID = p_line_id;

Line: 2209

        SELECT  DISTINCT ATTR_GROUP_ID
        FROM    PO_LINE_LOCATIONS_ALL_EXT_B
        WHERE   LINE_LOCATION_ID = p_location_id;

Line: 2214

        SELECT  END_USER_COLUMN_NAME
        FROM    FND_DESCR_FLEX_COLUMN_USAGES
        WHERE   DESCRIPTIVE_FLEXFIELD_NAME = p_ag_type
        AND     DESCRIPTIVE_FLEX_CONTEXT_CODE = p_ag_name;

Line: 2276

            SELECT ENTITY_CODE
            INTO   l_entity_code
            FROM   PO_UDA_AG_TEMPLATES
            WHERE  TEMPLATE_ID = p_template_id;

Line: 2298

                    SELECT  DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE
                    INTO    l_ag_type, l_ag_name
                    FROM    EGO_FND_DSC_FLX_CTX_EXT
                    WHERE   ATTR_GROUP_ID = c_po_header_ext_rec.ATTR_GROUP_ID;

Line: 2365

                    SELECT  DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE
                    INTO    l_ag_type, l_ag_name
                    FROM    EGO_FND_DSC_FLX_CTX_EXT
                    WHERE   ATTR_GROUP_ID = c_po_line_ext_rec.ATTR_GROUP_ID;

Line: 2430

                    SELECT  DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE
                    INTO    l_ag_type, l_ag_name
                    FROM    EGO_FND_DSC_FLX_CTX_EXT
                    WHERE   ATTR_GROUP_ID = c_po_location_ext_rec.ATTR_GROUP_ID;

Line: 2669

          SELECT  PO_LINE_ID
          FROM    po_lines_all pll
          WHERE   PO_HEADER_ID = p_po_header_id
           AND  EXISTS ( SELECT 1 FROM  EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage
                         WHERE   act.action_id = actdisp.action_id
                            AND  pousage.template_id = pll.uda_template_id
                            AND  pousage.attribute_group_id =  act.attr_group_id
                            AND  To_Char(pousage.template_id) = act.classification_code
                            AND  actdisp.execution_method = p_event_type);

Line: 2684

          SELECT  LINE_LOCATION_ID
          FROM    PO_LINE_LOCATIONS_all pll
          WHERE   PO_HEADER_ID = p_po_header_id
            AND   PO_LINE_ID = p_line_id
            AND   EXISTS ( SELECT 1 FROM  EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage
                           WHERE   act.action_id = actdisp.action_id
                              AND  pousage.template_id = pll.uda_template_id
                              AND  pousage.attribute_group_id =  act.attr_group_id
                              AND  To_Char(pousage.template_id) = act.classification_code
                              AND  actdisp.execution_method = p_event_type);

Line: 2702

            SELECT  UDA_TEMPLATE_ID
            INTO    l_template_id
            FROM    po_headers_all
            WHERE   PO_HEADER_ID = p_po_header_id;

Line: 2737

                    SELECT  UDA_TEMPLATE_ID
                    INTO    l_line_template_id
                    FROM    po_lines_all
                    WHERE   PO_LINE_ID = c_get_lines_rec.PO_LINE_ID;

Line: 2773

                            SELECT  UDA_TEMPLATE_ID
                            INTO    l_shipment_template_id
                            FROM    PO_LINE_LOCATIONS_all
                            WHERE   LINE_LOCATION_ID = c_get_shipments_rec.LINE_LOCATION_ID;

Line: 2840

            select o.pk1_column_name,
                   o.pk2_column_name,
                   o.pk3_column_name,
                   o.pk4_column_name,
                   o.pk5_column_name
            into   l_pk1_column_name,
                   l_pk2_column_name,
                   l_pk3_column_name,
                   l_pk4_column_name,
                   l_pk5_column_name
            from   fnd_objects_vl o
            where  o.obj_name = p_obj_name;