9139: IS
9140: gpr_return_status VARCHAR2 (1) := NULL;
9141: gpr_msg_count NUMBER := 0;
9142: gpr_msg_data VARCHAR2 (2000);
9143: gpr_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
9144: gpr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
9145: ppr_price_list_rec qp_price_list_pub.price_list_rec_type;
9146: ppr_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
9147: ppr_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
9140: gpr_return_status VARCHAR2 (1) := NULL;
9141: gpr_msg_count NUMBER := 0;
9142: gpr_msg_data VARCHAR2 (2000);
9143: gpr_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
9144: gpr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
9145: ppr_price_list_rec qp_price_list_pub.price_list_rec_type;
9146: ppr_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
9147: ppr_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
9148: ppr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
9141: gpr_msg_count NUMBER := 0;
9142: gpr_msg_data VARCHAR2 (2000);
9143: gpr_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
9144: gpr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
9145: ppr_price_list_rec qp_price_list_pub.price_list_rec_type;
9146: ppr_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
9147: ppr_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
9148: ppr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
9149: ppr_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
9142: gpr_msg_data VARCHAR2 (2000);
9143: gpr_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
9144: gpr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
9145: ppr_price_list_rec qp_price_list_pub.price_list_rec_type;
9146: ppr_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
9147: ppr_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
9148: ppr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
9149: ppr_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
9150: ppr_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
9143: gpr_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
9144: gpr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
9145: ppr_price_list_rec qp_price_list_pub.price_list_rec_type;
9146: ppr_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
9147: ppr_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
9148: ppr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
9149: ppr_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
9150: ppr_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
9151: ppr_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
9144: gpr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
9145: ppr_price_list_rec qp_price_list_pub.price_list_rec_type;
9146: ppr_price_list_val_rec qp_price_list_pub.price_list_val_rec_type;
9147: ppr_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
9148: ppr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
9149: ppr_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
9150: ppr_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
9151: ppr_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
9152: ppr_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
9147: ppr_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type;
9148: ppr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
9149: ppr_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
9150: ppr_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
9151: ppr_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
9152: ppr_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
9153: k NUMBER := 1;
9154: l_api_name CONSTANT VARCHAR2 (30)
9155: := 'Delete_locked_pricebreaks';
9148: ppr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type;
9149: ppr_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
9150: ppr_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
9151: ppr_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type;
9152: ppr_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;
9153: k NUMBER := 1;
9154: l_api_name CONSTANT VARCHAR2 (30)
9155: := 'Delete_locked_pricebreaks';
9156: BEGIN
9186: );
9187: END IF;
9188:
9189: --dbms_output.put_line('before process price list ');
9190: qp_price_list_pub.process_price_list
9191: (p_api_version_number => 1,
9192: p_init_msg_list => fnd_api.g_false,
9193: p_return_values => fnd_api.g_false,
9194: p_commit => fnd_api.g_false,