APPS.QP_PRL_LOADER_PUB SQL Statements

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

Line: 42

 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: 59

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

Line: 87

 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: 121

 SELECT process_type
 INTO   l_process_type
 FROM   qp_interface_list_headers
 WHERE  process_id = p_process_id;

Line: 128

 	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_price_list_rec.list_header_id,
    		gpr_price_list_rec.name,
    		gpr_price_list_rec.description,
    		l_operation,
    		gpr_price_list_rec.list_type_code,
    		gpr_price_list_rec.currency_code,
    		gpr_price_list_rec.start_date_active,
    		gpr_price_list_rec.end_date_active,
    		gpr_price_list_rec.automatic_flag
 	FROM
    		qp_interface_list_headers lhdr
 	WHERE
    		lhdr.process_id = p_process_id
 	AND
    		rownum < 2;

Line: 157

 	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,
    		lhdr.rounding_factor,
    		lhdr.automatic_flag,
    		lhdr.attribute1
 	INTO
    		gpr_price_list_rec.list_header_id,
    		gpr_price_list_rec.name,
    		gpr_price_list_rec.description,
    		l_operation,
    		gpr_price_list_rec.list_type_code,
    		gpr_price_list_rec.currency_code,
    		gpr_price_list_rec.start_date_active,
    		gpr_price_list_rec.end_date_active,
    		gpr_price_list_rec.rounding_factor,
    		gpr_price_list_rec.automatic_flag,
    		gpr_price_list_rec.attribute1
 	FROM
    		qp_interface_list_headers lhdr
 	WHERE
    		lhdr.process_id = p_process_id
 	AND
    		rownum < 2;

Line: 197

	gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 198

	--dbms_output.put_line('Setting operation to update');

Line: 202

	gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_DELETE;

Line: 203

	--dbms_output.put_line('Setting operation to update');

Line: 253

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

Line: 257

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

Line: 327

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

Line: 331

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

Line: 417

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

Line: 421

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