APPS.QP_MOD_LOADER_PUB SQL Statements

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

Line: 44

 SELECT
    qual.interface_action_code,
    qual.qualifier_id,
    qual.list_header_id,
    qual.excluder_flag,
    qual.comparison_operator_code,
    qual.qualifier_context,
    qual.qualifier_attribute,
    qual.qualifier_attr_value,
    qual.qualifier_datatype,
    qual.qualifier_grouping_no
 FROM
    qp_interface_qualifiers qual
 WHERE
    qual.process_id = p_process_id;

Line: 61

 SELECT
    line.interface_action_code,
    line.list_header_id,
    line.list_line_id,
    line.list_line_type_code,
    line.start_date_active,
    line.end_date_active,
    line.automatic_flag,
    line.override_flag,
    line.modifier_level_code,
    line.price_by_formula_id,
    line.operand,
    line.arithmetic_operator,
    line.product_precedence,
    line.pricing_group_sequence,
    line.pricing_phase_id,
    line.comments,
    line.price_break_type_code,
    line.list_line_no,
    line.charge_type_code,
    line.charge_subtype_code,
    line.price_break_header_index,
    line.attribute1
 FROM
    qp_interface_list_lines line
 WHERE
    line.process_id = p_process_id
 ORDER BY
    TO_NUMBER(line.list_line_no);

Line: 92

 SELECT
    pa.interface_action_code,
    pa.pricing_attribute_id,
    pa.list_header_id,
    pa.list_line_id,
    pa.excluder_flag,
    pa.product_attribute_context,
    pa.product_attribute,
    pa.product_attr_value,
    pa.product_uom_code,
    pa.product_attribute_datatype,
    pa.pricing_attribute_datatype,
    pa.pricing_attribute_context,
    pa.pricing_attribute,
    pa.pricing_attr_value_from,
    pa.pricing_attr_value_to,
    pa.attribute_grouping_no,
    pa.comparison_operator_code,
    --pa.price_list_line_index
    pa.list_line_no
 FROM
    qp_interface_pricing_attribs pa
 WHERE
    pa.process_id = p_process_id
 ORDER BY
    TO_NUMBER(pa.list_line_no);

Line: 126

 SELECT process_type
 INTO   l_process_type
 FROM   qp_interface_list_headers
 WHERE  process_id = p_process_id;

Line: 134

        SELECT
                lhdr.list_header_id,
                lhdr.name,
                lhdr.description,
                lhdr.interface_action_code,
                lhdr.list_type_code,
                lhdr.currency_code,
                TO_DATE(lhdr.start_date_active,'YYYYMMDD HHMISS'),
                TO_DATE(lhdr.end_date_active,'YYYYMMDD HHMISS'),
                lhdr.automatic_flag
        INTO
                gpr_modifier_list_rec.list_header_id,
                gpr_modifier_list_rec.name,
                gpr_modifier_list_rec.description,
                l_operation,
                gpr_modifier_list_rec.list_type_code,
                gpr_modifier_list_rec.currency_code,
                gpr_modifier_list_rec.start_date_active,
                gpr_modifier_list_rec.end_date_active,
                gpr_modifier_list_rec.automatic_flag
        FROM
                qp_interface_list_headers lhdr
        WHERE
                lhdr.process_id = p_process_id
        AND
                rownum < 2;

Line: 162

 SELECT
    lhdr.list_header_id,
    lhdr.name,
    lhdr.description,
    lhdr.interface_action_code,
    lhdr.list_type_code,
    lhdr.currency_code,
    lhdr.start_date_active,
    lhdr.end_date_active,
    'LOGSTX',
    lhdr.automatic_flag,
    lhdr.attribute1
--    lhdr.source_system_code,
--    lhdr.active_flag
 INTO
    gpr_modifier_list_rec.list_header_id,
    gpr_modifier_list_rec.name,
    gpr_modifier_list_rec.description,
    l_operation,
    gpr_modifier_list_rec.list_type_code,
    gpr_modifier_list_rec.currency_code,
    gpr_modifier_list_rec.start_date_active,
    gpr_modifier_list_rec.end_date_active,
    gpr_modifier_list_rec.pte_code,
    gpr_modifier_list_rec.automatic_flag,
    gpr_modifier_list_rec.attribute1
 FROM
    qp_interface_list_headers lhdr
 WHERE
    lhdr.process_id = p_process_id
 AND
    rownum < 2;

Line: 203

        gpr_modifier_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 208

        gpr_modifier_list_rec.operation := QP_GLOBALS.G_OPR_DELETE;

Line: 263

                gpr_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 267

                gpr_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_DELETE;

Line: 338

                gpr_modifiers_tbl(i).operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 342

                gpr_modifiers_tbl(i).operation := QP_GLOBALS.G_OPR_DELETE;

Line: 416

                gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 420

                gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_DELETE;